none
Using SharePoint Workflow Call WebService on External List RRS feed

  • Question

  • Good day looking for some help. 

    I have a SP Document Lib , with a workflow attached.  The workflow has an AppStep that calls Https Webservice to get data from external List. I keep getting a Forbidden result code when I execute the call HTTP Webservice. I have and Idea that is might be linked to my headers or it not allowed.

    I have done the usually workflow with elevated permissions setup, but no luck. 

    Obviously works fine if I point it to a normal sharepoint list 

    Thanks for the help

    Saturday, April 22, 2017 4:53 PM

All replies

  • Hi xy15973,

    Please find here the reference URL as below,

    https://blog.appliedis.com/2014/10/09/sharepoint-designer-2013-workflow-working-with-web-services/


    Hope this help.

    Vote - if you find this helpful

    Marked as Answer - if you see this reply being an answer to the question of the thread


    Regards,

    Amjad Khan

    Blog: https://amjadk.com

    Saturday, April 22, 2017 5:35 PM
  • Thanks for your response ... I had a look and added both the cookie (rtFa and FedAuth) and Authorization (Set to blank) values. Still no joy ... There must be a MS limitation in accessing external list via WF Webservice. 
    Monday, April 24, 2017 3:06 PM
  • Hi,

    Please make sure get the data from external list using REST API works in SharePoint UI(jQuery Ajax with REST API in a content editor web part).

    Did you follow the steps as the article below?

    https://msdn.microsoft.com/en-us/library/office/jj822159.aspx?f=255&MSPPError=-2147217396

    Try to use the following XML code in Permissions Request XML.

    <AppPermissionRequests>
    	<AppPermissionRequest Scope="http://sharepoint/content/sitecollection/web" Right="Write"/>
    	<AppPermissionRequest Scope="http://sharepoint/bcs/connection" Right="Read" />
    </AppPermissionRequests>

    Or as a workaround, we can create a custom web service to get the data from external list, then call the web service from the workflow.

    Best Regards,

    Dennis


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Wednesday, April 26, 2017 3:27 AM
    Moderator
  • Thanks Dennis 

    Yes i have worked through the article , but no joy. I will add your XML and see if this does the trick. What i did find is when I place a WebService call to a custom list ( normal Sp list) within the App Step, I also get the forbidden error, but when I moved it outside of the App step it worked fine. 

    O was using a MS Flow to check if there was a new item added and then update a internal list ,but it would seem that the external list works in a funny what. My flow just ran continually as if it was receiving new item notifications all the time... so that killed that idea 

    thanks 

    Wednesday, April 26, 2017 7:30 AM