Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [Reflection.Assembly]::LoadFile(([System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint.Client").location))
- [Reflection.Assembly]::LoadFile(([System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint.Client.runtime").location))
- Function Get-SPOContext([string]$Url,[string]$UserName,[string]$Password)
- {
- $SecurePassword = $Password | ConvertTo-SecureString -AsPlainText -Force
- $context = New-Object Microsoft.SharePoint.Client.ClientContext($Url)
- $context.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($UserName, $SecurePassword)
- return $context
- }
- Function Get-ListItems([Microsoft.SharePoint.Client.ClientContext]$Context, [String]$ListTitle) {
- $list = $Context.Web.Lists.GetByTitle($listTitle)
- $qry = [Microsoft.SharePoint.Client.CamlQuery]::CreateAllItemsQuery()
- $items = $list.GetItems($qry)
- $Context.Load($items)
- $Context.ExecuteQuery()
- return $items
- }
- $UserName = read-host "Please enter your name:"
- $PasswordReadHost = Read-Host -Prompt "Enter password" -AsSecureString
- $Password = [Runtime.InteropServices.Marshal]::PtrToStringAuto([Runtime.InteropServices.Marshal]::SecureStringToBSTR($PasswordReadHost))
- $Url = "https://domain.sharepoint.com/"
- $ListTitle = "VMList"
- $context = Get-SPOContext -Url $Url -UserName $UserName -Password $Password
- $items = Get-ListItems -Context $context -ListTitle $ListTitle
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement