Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Function Get-ListItems([Microsoft.SharePoint.Client.ClientContext]$Context, [String]$ListTitle) {
- $list = $Context.Web.Lists.GetByTitle($ListTitle)
- $items = $list.GetItems([Microsoft.SharePoint.Client.CamlQuery]::CreateAllItemsQuery())
- $Context.Load($items)
- $Context.ExecuteQuery()
- return $items
- }
- #set environment
- $targetsite = "https://sites/testsite"
- $targetlist = "testlist"
- $adminUsername = "admin@account"
- $secureAdminPassword = Read-Host -AsSecureString "please enter password"
- #ask the user to log in
- $usercredentials = Get-Credential
- #creating sharepiont credentials object
- #$sharepointcred = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($usercredentials.UserName, $usercredentials.Password)
- $sharepointcred = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($adminUsername, $secureAdminPassword)
- #tried both
- #create context
- $Context = New-Object Microsoft.SharePoint.Client.ClientContext($targetsite)
- #assign sharepoint credentials to context
- $Context.Credentials = $sharepointcred
- #read list
- $list = Get-ListItems -Context $Context -ListTitle $targetlist
- $items = Get-ListItems -Context $context -ListTitle $targetlist
- foreach($item in $items)
- {
- Write-Host $item.Title
- }
Add Comment
Please, Sign In to add comment