Appian - Sharepoint Online (Cloud) integration

Question

am trying to integrate Appian with Sharepoint Online (Cloud) - Office 365.
I make use of Sharepoint Connector, but it seems that something goes wrong with the Authentication. I am following the instructions as noted on the product documentation (e.g. use third party credentials - Username, Password, Domain) and i get "UnauthorizedAccessException".
Is there anyone that overcame this issue (without a custom smart service implementation)?

*To mention that for a local sharepoint installation the connection is successful !

Robert Shankin · Answer

Based on my experience integrating with sharepoint in the past, I'd suggest you start with elevating the permissions associated with the sharepoint login credentials to full control. As I recall, the required permission levels vary in sharepoint depending on the operation. 
 
Perhaps research in MS documentation/forums what the permissions levels are required to perform the desired operation.

Arun Theja Muthyalu · Answer

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

aloks0189 · Answer

Hi Arun, 
 You can follow below mentioned steps to identify / resolve this issue: 
 
 Cross-Check your request headers such as Bearer while posting the data(POST, PUT etc..) to Sharepoint, and in order to use this header you will need an accessToken, which you can only obtain only upon the successful Authentication as it's response. 
 If you are able to Authenticate successfully but unable to receive the accessToken then i would recommend you to re-verify Authorization Endpoint, Access Token Endpoint, Client Id, Client Secret etc.. with the Sharepoint team, as i suspect your Token Request Endpoint URL , if all correct and still you are unable to receive a token upon successful authentication, try doing the same test using some Third-Party tools such as SOAP-UI and compare the response. 
 Also it's worth discussing with sharepoint team by sharing the Trace ID and the Correlation ID you have to identify the root cause from their end. 
 
 Hope you will be able to trace out the root cause of this failure.

Appian - Sharepoint Online (Cloud) integration

Top Replies