Connecting to SharePoint Online


(Dan Wahry) #1

v5.5.2.2

We’ve tried two methods to connect Squiz Matrix to our SharePoint Online environment. All the settings have worked when running through Postman so we know that the SharePoint setup is correct.

One was to use the OAUTH 2.0 Token Asset and then to pass that to a REST Resource Asset that connects to the SharePoint Online list and retrieves data. While this seemed like the perfect option, we were unable to get the access token. I think this is due to the need to use “grant-type: client_credentials” in the Request Body which I so far haven’t seen a way of entering into the OAUTH 2.0 Token Asset settings.

The second method was to use two REST Resource Assets - one to retrieve the token and then to pass that via a variable to a second REST Resource Asset which communicates with the SharePoint list. The first REST Resource Asset correctly retrieves the token but I am stumped as to how to pass the token to the second REST Resource Asset and even if I hard code the token in, it says it is a bad call so I am assuming it has something to do with the formatting of the Request Headers which I would have assumed would be “Key: Value” i.e. “Accept:application/json;odata=verbose” etc

Has anyone successfully managed to connect Squiz Matrix to SharePoint Online?


(TT) #2

I haven’t connected sharepoint online but I have done something similar when connecting with a different system.

We use 1 REST resource asset to request the token. We use the js section at the bottom to print out just the returned token value.

Then in the second rest resource, nest the first in via the request header e.g.:

Authorization:Bearer %globals_asset_contents_raw:12345% where 12345 is the id of the first REST resource asset.

This seems to work well for what we need it for.

Also in the request headers we have on separate lines:
Content-Type: application/x-www-form-urlencoded
grant_type:password

but obviously they would be different depending on whats needed for sharepoint.

Have you tried copying how it’s being sent in postman and pasting that in exactly the same format?

Tim


(Byrne) #3

Setting the cache time on the first rest asset (token request) will also stop the token from being requested on every single API request.