UPDATED! Microsoft Graph API for SharePoint

[ewilson]

The Microsoft Graph API connector for SharePoint was recently updated to include actions for uploading/downloading files. You can find the latest .bprelease file here.

Some things to be aware of:

• The Upload File action of this connector is limited to files less than 4MB in size. There is an additional connector, making its way through the tech/marketing review process, that implements support for the Upload Session feature of Graph. That connector will support uploading files greater than 4MB through chunking. We expect that connector to be published on the DX later this week, possibly early next week.
• While the main connector includes support for downloading files, there is a limitation within the Web API feature of Blue Prism that impacts downloading binary files. As a result, only text files will be successfully downloaded. To address this, you can use the connector to collect the metadata of a file on SharePoint. That metadata will include a direct download URL for the specific file. You can then use the HTTP VBO to download the file using that URL.

Cheers,


------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

[ewilson]

Hi @sachintaneja,

So your environment is using federated auth services? Unfortunately, we do not have an asset at the moment that wraps MSAL, but we can look into creating one. In the meantime we'll need to investigate this redirect issue a bit more. The authentication VBO uses the Utility - HTTP VBO to perform all of the network requests, and that VBO supports redirects by default as it's using the .NET HttpWebRequest client under the wraps.

Do you have Fiddler installed by chance? Just wondering if you could perform a capture of the request and see what the redirect actually looks like? I assume it's just a HTTP response in the 300 range (ex. 301 or 302).

Cheers,
​

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

[AP.Philippa]

Hi @ewilson,

We currently are also experiencing the same error and have logged a ticket for this with Microsoft.

In our situation the majority of our accounts are unable to obtain a token (same AADSTS50126 error), however we also do have some AD accounts that are able to obtain a token (for all: username & password are correct + same Azure tenant).

Do you have any ideas on why we may see differences per AD accounts?

Thanks in advance!
​​

------------------------------
Arthur Philippa
RPA Developer
Port of Rotterdam
Europe/Amsterdam
------------------------------

[ewilson]

Hi @AP.Philippa,

If you take a look at the link below you'll see an answer to the question that might help you. From what I understand the accounts, in your environment, that work may have been synchronized through Selective Password Hash Sync.

https://docs.microsoft.com/en-us/answers/questions/385629/aadsts50126-error-validating-credentials-due-to-in-1.html

Cheers,
​

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

[kgupta]

Hello Eric,

Do we have a new MS Graph API Connector that supports file upload larger than 4 MB? I still the one on DX with 4 MB limit.

Thanks,

------------------------------
Kapil Gupta
------------------------------

[ewilson]

@kgupta,

The 4MB limit is imposed by the Graph API on the File Upload endpoint. If you have a file larger than 4 MB that you need to upload, you need to use the Microsoft Graph API - SharePoint Upload Sessions object.

https://digitalexchange.blueprism.com/dx/entry/3439/solution/microsoft-graph-api---sharepoint-upload-sessions

Cheers,
​

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

[SandeepSatish]

Hi Eric ,
I am planning to use Microsoft Graph API Sharepoint object. To start with, for all the actions within the object to work is there a list of Azure app permissions that blueprism can share ? Since the tool capability is defined, it would be good to have the capability to permission mapping, it will help for faster set up.

------------------------------
Sandeep Satish
Asia/Kolkata
------------------------------

[ewilson]

Hello @SandeepSatish 

This is really an organizational specific sort of thing. Different people need different permissions based on their specific use cases. The best approach is to review the available Graph permissions documented by Microsoft at the following link:

https://learn.microsoft.com/en-us/graph/permissions-reference

For SharePoint, you'll be primarily interested in Sites permissions, but you should also pay attention to Files permissions especially if you're looking at working with files on SharePoint.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------