Pega 8.6 integration with Sharepoint
Hi Team,
We need help in integrating Pega with O-365 and specifically Sharepoint. Please share some documents and please share some experience around this implementation. Please share if there is a known implementation using Graph API for this.
Accepted Solution
Updated: 28 Jun 2021 1:24 EDT
InnoFissionAI
IN
Graph API provided a lot of options and using MS Graph API all the functionalities can be achieved.
Able to upload a document, retrieve the Web URL and save it in Pega, allow online editing, copy document, move the document to different folder path, change access rights.
Infosys Ltd
IN
Requirement is to create folders in Sharepoint from Pega depending on the authorization of Pega User. What is the App Permission Level required for this in Sharepoint Online Application. There is push back from Infosec team for providing Edit access at all Tenant level. Pls guide
<AppPermissionRequests>
<AppPermissionRequest Scope="http://sharepoint/content/sitecollection" Right="Edit"/>
<AppPermissionRequest Scope="http://sharepoint/content/sitecollection/web" Right="Edit"/>
<AppPermissionRequest Scope="http://sharepoint/content/sitecollection/web/list" Right="Edit"/>
<AppPermissionRequest Scope="http://sharepoint/content/tenant" Right="Edit"/>
</AppPermissionRequests>
Boardwalk Pipelines
US
@Sayan Das Could you please provide a high level details how did you upload a large document using graph API rest call from Pega.
Thanks In Advance.
Sri
Capgemini
SE
You would need to call two Rest APIs to achieve this. First to create a upload session by calling createUploadSession. This is going to give you the upload URL and this URL should become the endpoint for your next call.
In the second call, you would need to pass the binary content and a header attribute Content-Range. This needs to be of the form
"bytes 0-(filesize in bytes -1)/filesize".
e.g. bytes 0-1023/1024
You can upload a file up to 60 MiB as per graph documentation.
https://docs.microsoft.com/en-us/graph/api/driveitem-createuploadsession?view=graph-rest-1.0
All of this can be achieved by two data pages. The first data page to call createUploadSession and the URL from there can be directly referred in the second data page as end point URL.
