Guest User

Untitled

a guest
Nov 8th, 2017
400
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.92 KB | None | 0 0
  1. Add-Type –Path (Resolve-Path "C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions16ISAPIMicrosoft.SharePoint.Client.dll")
  2. Add-Type –Path (Resolve-Path "C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions16ISAPIMicrosoft.SharePoint.Client.Runtime.dll")
  3.  
  4. $UserName = "lee@xxx.onmicrosoft.com"
  5. $Password = Read-Host -Prompt "Enter password" -AsSecureString
  6. $Url = "https://xxx.sharepoint.com/sites/sts"
  7.  
  8.  
  9. #$Context = Get-SPOContext -Url $Url -UserName $UserName -Password $Password
  10. #$items = Get-ListItems -Context $Context -ListTitle "EmployeeInfo"
  11.  
  12. $spoContext = Get-SPOContext -Url $Url -UserName $UserName -Password $Password
  13. $listTitle = "EmployeeInfo"
  14.  
  15. #$password = Read-Host -Prompt "Enter password" -AsSecureString
  16. #$credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials("M.okoro-ogbobe@shell.com", $password)
  17.  
  18. $web = $spoContext.Web
  19.  
  20. $List = $web.Lists.GetByTitle($listTitle)
  21. $a = [Microsoft.SharePoint.Client.CamlQuery]::CreateAllItemsQuery()
  22. $items = $List.GetItems( $a )
  23.  
  24. $spoContext.Load($web)
  25. $spoContext.Load($items)
  26. #execute query
  27. $spoContext.ExecuteQuery()
  28.  
  29. Function Get-SPOContext([string]$Url,[string]$UserName,$Password)
  30. {
  31. write-host Get-SPOContext
  32. #$SecurePassword = $Password | ConvertTo-SecureString -AsPlainText -Force
  33. $Context = New-Object Microsoft.SharePoint.Client.ClientContext($Url)
  34. $Context.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($UserName, $Password) #SecurePassword
  35. return $Context
  36. }
  37.  
  38. Function Get-ListItems([Microsoft.SharePoint.Client.ClientContext]$Context, [String]$ListTitle) {
  39. write-host Get-ListItems
  40. $list = $Context.Web.Lists.GetByTitle($listTitle)
  41. $qry = [Microsoft.SharePoint.Client.CamlQuery]::CreateAllItemsQuery(13,'ID','Created','Modified','Title')
  42. $items = $list.GetItems($qry)
  43. $Context.Load($list)
  44. $Context.Load($items)
  45. $Context.ExecuteQuery()
  46. return $items
  47. }
Add Comment
Please, Sign In to add comment