Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Add-Type –Path (Resolve-Path "C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions16ISAPIMicrosoft.SharePoint.Client.dll")
- Add-Type –Path (Resolve-Path "C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions16ISAPIMicrosoft.SharePoint.Client.Runtime.dll")
- $UserName = "lee@xxx.onmicrosoft.com"
- $Password = Read-Host -Prompt "Enter password" -AsSecureString
- $Url = "https://xxx.sharepoint.com/sites/sts"
- #$Context = Get-SPOContext -Url $Url -UserName $UserName -Password $Password
- #$items = Get-ListItems -Context $Context -ListTitle "EmployeeInfo"
- $spoContext = Get-SPOContext -Url $Url -UserName $UserName -Password $Password
- $listTitle = "EmployeeInfo"
- #$password = Read-Host -Prompt "Enter password" -AsSecureString
- #$credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials("M.okoro-ogbobe@shell.com", $password)
- $web = $spoContext.Web
- $List = $web.Lists.GetByTitle($listTitle)
- $a = [Microsoft.SharePoint.Client.CamlQuery]::CreateAllItemsQuery()
- $items = $List.GetItems( $a )
- $spoContext.Load($web)
- $spoContext.Load($items)
- #execute query
- $spoContext.ExecuteQuery()
- Function Get-SPOContext([string]$Url,[string]$UserName,$Password)
- {
- write-host Get-SPOContext
- #$SecurePassword = $Password | ConvertTo-SecureString -AsPlainText -Force
- $Context = New-Object Microsoft.SharePoint.Client.ClientContext($Url)
- $Context.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($UserName, $Password) #SecurePassword
- return $Context
- }
- Function Get-ListItems([Microsoft.SharePoint.Client.ClientContext]$Context, [String]$ListTitle) {
- write-host Get-ListItems
- $list = $Context.Web.Lists.GetByTitle($listTitle)
- $qry = [Microsoft.SharePoint.Client.CamlQuery]::CreateAllItemsQuery(13,'ID','Created','Modified','Title')
- $items = $list.GetItems($qry)
- $Context.Load($list)
- $Context.Load($items)
- $Context.ExecuteQuery()
- return $items
- }
Add Comment
Please, Sign In to add comment