{"id":3295,"date":"2013-07-02T00:01:00","date_gmt":"2013-07-02T00:01:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2013\/07\/02\/use-powershell-to-work-with-skydrive-for-powerful-automation\/"},"modified":"2013-07-02T00:01:00","modified_gmt":"2013-07-02T00:01:00","slug":"use-powershell-to-work-with-skydrive-for-powerful-automation","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/use-powershell-to-work-with-skydrive-for-powerful-automation\/","title":{"rendered":"Use PowerShell to Work with SkyDrive for Powerful Automation"},"content":{"rendered":"

Summary<\/strong>: Microsoft PFE, Chris Wu, talks about creating powerful automation scenarios by using Windows PowerShell and SkyDrive.<\/span><\/p>\n

Microsoft Scripting Guy, Ed Wilson, is here. Chris Wu<\/a> is back with us today. I will let Chris dive right in…<\/p>\n

On the Microsoft Download Center, you can download Live SDK v5.3<\/a>, which contains APIs and a great deal of information about how to achieve common tasks. You can also find the information on the Live Connect documentation<\/a> site. If you have stored a valid access token (by using wl.skydrive<\/strong> or wl.skydrive_update scope<\/strong>) in a variable (for example, $AccessToken<\/strong>), most of the tasks can be easily achieved with Windows PowerShell. For information about how to create a valid access token, read my previous post, Use PowerShell 3.0 to Get More Out of Windows Live<\/a>.<\/p>\n

A bit of background about the SkyDrive folder structure…<\/p>\n

Each SkyDrive user has a unique ID, with a top-level folder usually named in the form “folder.<user id><\/em><\/strong>“. Files and folders also have unique IDs, which are composed of several parts including a keyword (such as “folder” or “file”) and the owner’s unique ID. So, every file and folder in SkyDrive can be uniquely identified and individually accessed.<\/p>\n

Browse SkyDrive folders<\/h2>\n

To access the current user’s top-level folder, simply invoke a Rest<\/strong> method. The JSON-formatted object that’s returned will show properties of the folder in a very familiar way:<\/p>\n

$ApiUri = “https:\/\/apis.live.net\/v5.0”<\/p>\n

Invoke-RestMethod -Uri “$ApiUri\/me\/skydrive?access_token=$AccessToken”<\/p>\n

\"Image<\/a><\/p>\n

There are some interesting properties such as ID, name, number of items, and permission. Among them, the upload_location<\/strong> property is actually the API URI through which we can enumerate or upload files. This example shows how to enumerate child items:<\/p>\n

$Root = Invoke-RestMethod -Uri “$ApiUri\/me\/skydrive?access_token=$AccessToken”<\/p>\n

$r = Invoke-RestMethod -Uri “$($Root.upload_location)?access_token=$AccessToken”<\/p>\n

$r.data | ft Name, id, upload_location –AutoSize<\/p>\n

\"Image<\/a><\/p>\n

This enables you to browse the hierarchy inside the SkyDrive.<\/p>\n

Access SkyDrive folders through friendly names<\/h2>\n

Folders such as Documents, Pictures, and Public can be accessed through friendly names such as those shown in the following table:<\/p>\n\n\n\n\n\n\n\n
\n

Friendly Name<\/strong><\/p>\n<\/td>\n

\n

Folder<\/strong><\/p>\n<\/td>\n<\/tr>\n

\n

camera_roll<\/p>\n<\/td>\n

\n

The camera roll folder<\/p>\n<\/td>\n<\/tr>\n

\n

my_documents<\/p>\n<\/td>\n

\n

The Documents folder<\/p>\n<\/td>\n<\/tr>\n

\n

my_photos<\/p>\n<\/td>\n

\n

The Pictures folder<\/p>\n<\/td>\n<\/tr>\n

\n

public_documents<\/p>\n<\/td>\n

\n

The Public folder<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

To get the Documents folder’s property, simply call:<\/p>\n

$Docs = Invoke-RestMethod -Uri “$ApiUri\/me\/skydrive\/my_documents?access_token=$AccessToken”<\/p>\n

And to enumerate child items in Documents, call:<\/p>\n

Invoke-RestMethod -Uri “$ApiUri\/me\/skydrive\/my_documents\/files?access_token=$AccessToken”<\/p>\n

Upload and download files<\/h2>\n

Before uploading files, we need to make sure that the access token that originally was requested includes wl.skydrive_update scope<\/strong>. We can upload files only with proper permissions. It’s also good to check the available space on SkyDrive. Here is how to query the information:<\/p>\n

Invoke-RestMethod -Uri “$ApiUri\/me\/skydrive\/quota?access_token=$AccessToken”<\/p>\n

The following screenshot shows that 7 GB is available:<\/p>\n

\"Image<\/a><\/p>\n

Uploading a file can be accomplished through a Post<\/strong> request or Put<\/strong> request. The Put<\/strong> method is preferred whenever it’s applicable, although a small caveat is that the target file name on SkyDrive has to be specified in the request. The following example uploads a Windows PowerShell script from c:\\temp\\myscript.ps1 to the root on SkyDrive:<\/p>\n

$fn = “myscript.ps1”<\/p>\n

Invoke-RestMethod -Uri “$ApiUri\/me\/skydrive\/files\/$fn`?access_token=$AccessToken” -Method Put -InFile “c:\\temp\\$fn”<\/p>\n

\"Image<\/a><\/p>\n

We can use any folder’s upload_location<\/strong> property as the destination to upload a file. We have a $Docs<\/strong> variable from previous tests, so the following script snippet uploads a binary file to the Documents folder on SkyDrive:<\/p>\n

$fn=”test.zip”<\/p>\n

Invoke-RestMethod -Uri “$($Docs.upload_location)\/$fn`?access_token=$AccessToken” -Method Put -InFile “C:\\temp\\$fn”<\/p>\n

If a file with exactly the same name already exists in the target folder, it will be replaced with new content.<\/p>\n

To download a file, we basically request the content of a file. Assuming a file’s ID has been determined through folder browsing or from the object that is returned when uploading it, the following command downloads the content of a text-based file:<\/p>\n

$fileid = “file.6e8e4812f1211e8a.6E8E4812F1211E8A!205”<\/p>\n

Invoke-RestMethod -Uri “$ApiUri\/$fileid\/content?access_token=$AccessToken”<\/p>\n

\"Image<\/a><\/p>\n

The previous script snippet downloads a script and saves the code into a variable. This works great if the script is an ANSI-encoded text file. However, binary files and text files encoded in UTF8 may suffer data distortion due to the cmdlet’s attempt to parse the content. Saving the content directly into a local file can solve the problem:<\/p>\n

Invoke-RestMethod -Uri “$ApiUri\/$fileid\/content?access_token=$AccessToken” -OutFile c:\\temp\\test2.zip<\/p>\n

Other users’ files<\/h2>\n

So far, we have been accessing the folders and files of currently signed-in users. But the same syntax applies to folders and files for other user’s in SkyDrive that have been shared with you by the owner. The “me” portion in the URI used earlier is simply an alias for the current user, and it can be replaced with another user’s ID to browse those folders.<\/p>\n

To get a current user’s ID, send a web request to “$ApiUri\/me”:<\/p>\n

$UserID = (Invoke-RestMethod -Uri “$ApiUri\/me?access_token=$AccessToken”).id
With the user ID figured out, the following command can return all items shared by the user in the Public folder (assuming you have permission to access them):<\/p>\n

(Invoke-RestMethod -Uri “$ApiUri\/$UserID\/skydrive\/public_documents?access_token=$AccessToken”).data | ft name, id -autosize<\/p>\n

To wrap things up, I use the following script snippet to synchronize a SkyDrive folder (one-way sync) to a local disk:<\/p>\n

# Function to sync all files from one SkyDrive Folder to a local Target<\/p>\n

function Sync-SkyDriveFolder {<\/p>\n

  Param(<\/p>\n

    [PSObject]$Folder,<\/p>\n

    [String]$Target,<\/p>\n

    [Switch]$Recurse<\/p>\n

  )<\/p>\n

 <\/p>\n

  (Invoke-RestMethod -Uri “$($Folder.upload_location)?access_token=$AccessToken”).data | % {<\/p>\n

    $Path = “$Target\\$($_.Name)”<\/p>\n

    if($_.type -eq “file”) {<\/p>\n

      if(!(Test-Path $Path) -or $_.size -ne (Get-Item $Path).Length) {<\/p>\n

        Invoke-RestMethod -Uri “$($_.upload_location)?access_token=$AccessToken” -OutFile $Path<\/p>\n

      }<\/p>\n

    }<\/p>\n

elseif ($Recurse) {<\/p>\n

      if(!(Test-Path $Path)) { New-Item -Path $Path -ItemType Directory | Out-Null }<\/p>\n

      Sync-SkyDriveFolder -Folder $_ -Target $Path -Recurse<\/p>\n

    }<\/p>\n

  }<\/p>\n

}<\/p>\n

 <\/p>\n

$ApiUri = “https:\/\/apis.live.net\/v5.0”<\/p>\n

$Source = “Documents\\Tools”  # Relative path of the SkyDrive folder<\/p>\n

$Destination = “C:\\Tools”    # Local folder to save files to<\/p>\n

 <\/p>\n

# Find the object representing the source folder on SkyDrive<\/p>\n

$Folder = Invoke-RestMethod -Uri “$ApiUri\/me\/skydrive?access_token=$AccessToken”<\/p>\n

foreach($s in $Source -split ‘[\\\\\\\/]’) {<\/p>\n

  if ($s = $s.Trim()) {<\/p>\n

    $Folder = (Invoke-RestMethod -Uri “$($Folder.upload_location)?access_token=$AccessToken”).data | ? { $_.name -eq $s }<\/p>\n

    if(! $Folder) { return }<\/p>\n

  }<\/p>\n

}<\/p>\n

 <\/p>\n

# Start download recursively<\/p>\n

Sync-SkyDriveFolder -Folder $Folder -Target $Destination -Recurse<\/p>\n

Apparently, the script is pretty rough at this point. It checks identical files based only on size. It doesn’t confirm the validity of access tokens, which may lead to failure for a long-running task, and there is no error handling. But still, it serves its purpose pretty well. With further polish, it can even be a replacement desktop SkyDrive app for my Surface RT (or any computer running Windows RT).<\/p>\n

~Chris<\/p>\n

Thanks again for sharing, Chris. Join us tomorrow for more of Chris Wu and WindowsPowerShell.<\/p>\n

I invite you to follow me on Twitter<\/a> and Facebook<\/a>. If you have any questions, send email to me at scripter@microsoft.com<\/a>, or post your questions on the Official Scripting Guys Forum<\/a>. See you tomorrow. Until then, peace.<\/p>\n

Ed Wilson, Microsoft Scripting Guy<\/strong> <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Summary: Microsoft PFE, Chris Wu, talks about creating powerful automation scenarios by using Windows PowerShell and SkyDrive. Microsoft Scripting Guy, Ed Wilson, is here. Chris Wu is back with us today. I will let Chris dive right in… On the Microsoft Download Center, you can download Live SDK v5.3, which contains APIs and a great […]<\/p>\n","protected":false},"author":596,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[302,56,434,3,12,167,45],"class_list":["post-3295","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-chris-wu","tag-guest-blogger","tag-invoke-restmethod","tag-scripting-guy","tag-storage","tag-using-the-internet","tag-windows-powershell"],"acf":[],"blog_post_summary":"

Summary: Microsoft PFE, Chris Wu, talks about creating powerful automation scenarios by using Windows PowerShell and SkyDrive. Microsoft Scripting Guy, Ed Wilson, is here. Chris Wu is back with us today. I will let Chris dive right in… On the Microsoft Download Center, you can download Live SDK v5.3, which contains APIs and a great […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/3295","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/596"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=3295"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/3295\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=3295"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=3295"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=3295"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}