Since SharePoint 2013 introduces a Representational State Transfer (REST) service that is comparable to the existing SharePoint client object models, it opens up a huge capabilities, in particular for administering and automating SharePoint Online when used with PowerShell.
My first idea was to utilize Invoke-RestMethod cmdlet, which was introduced in Windows PowerShell 3.0. Invoke-RestMethod cmdlet contains Credential parameter which could accept basic, digest, NTLM, and Kerberos authentication.
SharePoint Client Component SDK comes with a SharePointOnlineCredentials class which represents an object that provides credentials to access SharePoint Online resources. But unfortunately SharePoint Online credentials could not be passed in Invoke-RestMethod cmdlet, since claims based authentication is not supported by this cmdlet.
Below is demonstrated a simplified PowerShell script that to some extent mimics Invoke-RestMethod cmdlet. This script is intended for sending HTTPS request to a SharePoint Online REST service:
Examples
References
- Get started with the SharePoint 2013 REST service
- Use OData query operations in SharePoint REST requests
- InvokeRestMethod for the Rest of Us
Pingback: Consuming the SharePoint 2013 REST API from PowerShell | Yet Another SharePoint Blog
Pingback: Invoke-SPORestMethod: Using the SharePoint Online REST API with PowerShell « SharePoint Automation
Pingback: Consuming the SharePoint Online REST API from PowerShell: Part 2 | YASP Blog
Thankyou! This was very helpful.
Hi Vadim, I tried to access “My site” but the script fails with
Exception lors de l’appel de « GetResponse » avec « 0 » argument(s) : « The request was aborted: The request was canceled. »
Au caractère C:\temp\sharepoint.ps1:23 : 1
+ $response = $request.GetResponse()
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : WebException
I have to pass trough a proxy in my office, I tried
$request.proxy=New-Object system.net.webproxy(“http://10.24.18.18:8080″)
but it also failed.
What can I try next?
Thank you
Had the same issue, eventually resolved by setting the credentials with the domain.
$Credentials = New-Object System.Net.NetworkCredential($sUserName,$sPassword,$sDomain)
Please consult the example here
https://gallery.technet.microsoft.com/office/How-to-Get-all-the-Lists-a0af6259
I get a array dimensions exceed supported range, any ideas?