Integrating Appian with SharePoint

Hi All,

Please refer to the document below for the solution. This approach uses Azure Active Directory for Authentication & Authorization and Appian OOTB functionality only.

Appian-SharePointOnline_Integration.docx

Arun - this is fantastic. I've seen this question asked so many times but never a reply on how to actually do it. I've had files uploading in less than 20 minutes..

Then despite messing for an hour i couldnt get folder creation working. Do you happen to know the syntax for adding this?

Cheers
Chris

*and retrieve document if you happen to know!

Hi chrism967,

It's great to know that my documentation helped you upload documents in SharePoint in no time. But I haven't tried the scenarios that you have mentioned. But by now we have the Connected System successfully pointing to the SharePoint. So I believe it's more of SharePoint stuff, as you need to find the appropriate REST URI for folder creation and document download.

SharePoint Folder Creation - REST API might help.

Good luck with that and please post when you sort that out in your free time. That might be useful for other folks. Thank you!

Hi chrism967,

It's great to know that my documentation helped you upload documents in SharePoint in no time. But I haven't tried the scenarios that you have mentioned. But by now we have the Connected System successfully pointing to the SharePoint. So I believe it's more of SharePoint stuff, as you need to find the appropriate REST URI for folder creation and document download.

SharePoint Folder Creation - REST API might help.

Good luck with that and please post when you sort that out in your free time. That might be useful for other folks. Thank you!

Well it took a bit of wrestling but in the end it fell into place!

https://[YourSharepointSiteAddress]/_api/web/getfolderbyserverrelativeurl('Shared%20Documents')/folders/add(url='Testing')

nesting can be done using

https://[YourSharepointSiteAddress]/_api/web/getfolderbyserverrelativeurl('Shared%20Documents/Testing')/folders/add(url='Testing2')

You need to loop through creating folders as you go - there's no point in testing if a folder already exists before creating it as it just means more API calls in the event they're not there - may as well just create and if it already exists then no harm done.