zplume

Moving Files with SharePoint Online REST APIs in Microsoft Flow

About

This is an overview of how to move files with Microsoft Flow using the SharePoint - Send an HTTP request to SharePoint action and SharePoint Online REST APIs.

These SharePoint Online REST APIs can be used outside of Flow, but you will need to handle authentication and provide an X-RequestDigest header with any POST requests (as with any SP REST POST request).

In the case of Flow's SharePoint - Send an HTTP request to SharePoint action, authentication is handled for you and you do not need to provide the X-RequestDigest header.

zplume

Retrieving list item changes with the SharePoint Online Folder.GetListItemChanges REST API in Microsoft Flow

About

This post demonstrates how to retrieve SharePoint list item changes in Microsoft Flow using the SharePoint - Send an HTTP request to SharePoint action and the SharePoint Online Folder.GetListItemChanges REST API.

Why

This is something I started looking at after reading this set of tweets by John Liu:

zplume

Cross-site collection file copy with SharePoint Online REST APIs in Microsoft Flow

About

This is a follow up to my previous post: Moving Files with SharePoint Online REST APIs in Microsoft Flow, which explains how to move/copy files with Microsoft Flow using the SharePoint - Send an HTTP request to SharePoint action and the SharePoint Online SP.MoveCopyUtil REST API.

This post demonstrates using a similar approach, but using the CreateCopyJobs and GetCopyJobProgress APIs to copy files from one site collection to another.

I suggest reading the previous post first for context if you haven't already.

zplume

using UnityEngine;
using System;

[Serializable]
public class Collectable : PolymorphicObject
{
    public string Name;
}

zplume

// This script returns an array of Role Definition objects, containing the Permission Levels for the site

// See http://msdn.microsoft.com/en-us/library/office/jj244931(v=office.15).aspx for examples of how to use the
// SP.PermissionKind object to assign permissions to a Role Definition

// replacement function for console.log(), which avoids 'undefined' exception in IE 8
window.LogMsg = function (msg) {
    if (window.console) {
        console.log(msg);
    }

zplume

var SharedData = (function () {
    function SharedData() {
    }
    SharedData.prototype.loadData = function () {
        console.log("Loading data (should only be called once)");
        SharedData.loadingData = true;
        // simulate AJAX call to retrieve data
        return SharedData.loadingPromise = new Promise(function (resolve, reject) {
            setTimeout(function () {
                SharedData.loadedData = true;

zplume

const queryStrings = window.location.search.substring(1).split("&").reduce((output, item, index) => {
    if(item === "")
        return output;
    
    const keyValue = item.split("=");
    
    output[decodeURIComponent(keyValue[0])] = keyValue[1] !== undefined ?
        decodeURIComponent(keyValue[1]) :
        true; // return true for query strings with no value
    

zplume

(function() {
	var nsName = "LS"; // root namespace name
	var ns = window[nsName]; // root namespace alias
	var utils = ns.Utils; // utils alias
	ns.SP = ns.SP || {};

	ns.SP.JSOM = {
		Data: {
			Sites: {} // cache for Taxonomy terms JSON
		},

zplume

param(
    [Parameter(Mandatory = $true)]
    [string]$SourceEnv,
    [Parameter(Mandatory = $true)]
    [string]$DestinationEnv
)

$ErrorActionPreference = "Stop"

# Note: these values could be loaded from elsewhere, e.g. CSV/XML (or dynamically if you want to get fancy)

zplume

$inputFile = "AuditLog_2017-05-18_2017-05-27.csv"
$outputFile = "AuditLogData.csv"
Import-Csv -Path $inputFile | ForEach-Object { $_.AuditData } | ConvertFrom-Json | Export-Csv -Path $outputFile -NoTypeInformation