Power Automate connector for downloading Webform data?

Question

We have a user with 7 webforms that they regularly need to download the CSV field data for. Unfortunately, there is a bug in Adobe Sign where if the webform has a large number of agreements it fails to download the data. So we are using an API to do this via PowerShell. I would like to automate this to export the data to a SharePoint List for each webform.

The Power Automate Adobe Sign connector has various actions, including "Get a list of all webforms", which succefully returns an array of webforms for a user. However, I do not see an action to get the CSV data for the agreements signed via a webform.

The API has the following endpoint which we use in our PowerShell script:

https://secure.na1.adobesign.com/api/rest/v6/widgets/$WebFormID/formData

Is there an equivalent action I am missing on the Power Automate connector? If not, is the best way to loop through the webforms using the HTTP premium action?

atsmusz_as_dsEng · Answer

Hi Matt,Yes, your second assumption is correct.  The best way to do this is to use the API.  The "out-of-box" connector covers the most commonly used functions, but does not include all possible actions with the API.  More complex scenarios, like the one you are working through, sometimes require the HTTP action.  I'd suggest using the search endpoint to get all agreements with that web-form ID as the parent, looping through each using the formData endpoint to get the form data as a CSV or JSON string, and then writing the data to your SharePoint list.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded