Hi All, I am trying to integrate Appian with Sharepoint 2013 with App

sariqs over 8 years ago

Hi All,

I am trying to integrate Appian with Sharepoint 2013 with Appian Connector functions only. In our setup we are using Sharepoint online office 365. I would like to understand if its possible to integrate Appian with Sharepoint 2013 online, if yes than what authentication mechanism to use.

Right now I have configured Third party credentials in Appian as shown in image attached. The credentials is one of my account which I am using to access the Sharepoint 2013 online. Second image shows the error I am getting while invoking a!shpInvoke connector function which clearly indicates that its not able to authenticate Appian request correctly. I dont have any knowledge on Sharepoint, please let me know what is required to be done in this case.

Discussion posts and replies are publicly visible

Parents

0 venkats533 over 8 years ago

this is an error given by sharepoint - couple of points.
1. usePerUserCredentials value should be true to use the secure credentials store
2. your uri may need to be prefixed with <your site>/<your collections>/_api/....
3. here you are using a "GET", so fine, but you can not use rule expression for "POST" methods, "POST" methods works only with bind().
try the following syntax to get list of files from a specific folder
a!shpInvoke(
scsExternalSystemKey: cons!SHAREPOINT_EXTERNAL_SYSTEM_KEY,
usePerUserCredentials: true,
hostname: cons!SHAREPOINT_HOSTNAME,
port: 443,
timeout: 1000,
retries: 2,
path: "<your site>/<your collections>/_api/Web/getfolderbyserverrelativeurl('" & local!folderName & "')/Files?$select=Name,ServerRelativeUrl,Level,Length",
httpMethod:
"GET",
parameters: null
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 venkats533 over 8 years ago

this is an error given by sharepoint - couple of points.
1. usePerUserCredentials value should be true to use the secure credentials store
2. your uri may need to be prefixed with <your site>/<your collections>/_api/....
3. here you are using a "GET", so fine, but you can not use rule expression for "POST" methods, "POST" methods works only with bind().
try the following syntax to get list of files from a specific folder
a!shpInvoke(
scsExternalSystemKey: cons!SHAREPOINT_EXTERNAL_SYSTEM_KEY,
usePerUserCredentials: true,
hostname: cons!SHAREPOINT_HOSTNAME,
port: 443,
timeout: 1000,
retries: 2,
path: "<your site>/<your collections>/_api/Web/getfolderbyserverrelativeurl('" & local!folderName & "')/Files?$select=Name,ServerRelativeUrl,Level,Length",
httpMethod:
"GET",
parameters: null
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data