Has anyone been able to POST data from SharePoint into Appian? We have a use case where we need to get status data from SharePoint into Appian workflow and SharePoint needs to push this data to Appian via connected system. We already have a connected system performing a GET and POST from Appian to SharePoint but we are tying to see if the other way round can be achieved without Appian making GET calls .
Discussion posts and replies are publicly visible
Hello,
It sounds like what you want to do is create a web API in Appian, and then expose that to your Sharepoint.
https://docs.appian.com/suite/help/20.3/Designing_Web_APIs.html
Yes I have created that as well but how will SharePoint post data to appian? I have exposed the site via API but I don't see any option for SharePoint to post the data would Microsoft Flow work ?
You will probably get better information on that from a sharepoint/microsoft forum, as calling Appian should be like any other web service. Doing a quick search shows that it looks possible that sharepoint workflows can call a web service, like the one you said you made already.
https://docs.microsoft.com/en-us/sharepoint/dev/solution-guidance/call-web-services-from-sharepoint-workflows
Thanks i was able to post data into Appian from SharePoint using the flow automation but now its fails when PATCH/PUT/Merge is used to update the same SharePoint site when the data in appian is changed. Tried using the connected system but keep getting
SharePoint returned a 400 HTTP error
SharePoint returned the following error code: -1, Microsoft.SharePoint.Client.InvalidClientQueryException The type SP.ListItemEntityCollection does not support HTTP PUT method.
If i use POST then i'm getting following error
SharePoint returned the following error code: -1, Microsoft.SharePoint.Client.InvalidClientQueryException A node of type 'StartArray' was read from the JSON reader when trying to read the start of an entry. A 'StartObject' node was expected.