Appian - Sharepoint Online (Cloud) integration

Hi,

So the Authorization Endpoint and Token Request Endpoint seems to be different then what I usually use.

We use Authorization Endpoint as following

login.microsoftonline.com/xxxxxxx/oauth2/authorize URI trying to access"

XXXXXXXXXX is the resource id of the sharepoint which can be accessed from Azure

and Token Endpoint is as following

login.microsoftonline.com/xxxxxxxx/oauth2/token

XXXXXXXX is the same resource id used in the auth endpoint.

Hope this helps

Hi Chanakya Volam (chanakyav0001),

I am getting the below error.

Btw, I have registered Appian as a SharePoint Add-In.

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.

Hi Chanakya Volam (chanakyav0001) ,

Thank you very much for the detailed info. I am now able to authenticate successfully and it seems like Refresh Token is also captured. But when I used this Connected System in the Integration where I am trying to upload document, I am getting the error below.

Hi Chanakya Volam (chanakyav0001) ,

Thank you very much for the detailed info. I am now able to authenticate successfully and it seems like Refresh Token is also captured. But when I used this Connected System in the Integration where I am trying to upload document, I am getting the error below.

Hi Chanakya Volam 

I finally figured it out. I have included ?resource=https://mytenantname.sharepoint.com in https://login.microsoftonline.com/common/oauth2/authorize?resource=https://mytenantname.sharepoint.com(Authorization URL)and it worked like a charm. :)

Thank you very much!

Hi,

Great that you figured it out. I thought informed to include resource in URL even I use resource in the URL