API call to get Workflow Dependencies for all workflows on the Gallery

Question

Hi, is there an API call or any other way to get a list of all server inputs used across all Workflows that are saved on the Gallery? The information provided in the Workflow Dependencies under Options > Advanced Options would be very useful for me and my team.  We will be needing to change all the inputs that are currently pointed to a specific server in the near future so I'm just trying to get ahead of it.

Thanks

craigja · Answer

I sort of got it working - what I did was download the workflows from the server via the API, I saved them with a .ZIP extension, then used the zip app on my machine to bulk unzip them all to a folder.  Next, I used the input data tool, inside a basic macro (as I got that standard error when bringing in csv files where the number or type of fields doesnt match) with the below settings, this brings every line in from the xml that is the workflow, then its just a case of looking at the text for the connection string you want

BonusCup · Answer

@craigja would it be possible to share your macro and how you extracted your workflows?  This would be a great time saver.  I'll also be looking into pulling the full select statement.

Thanks

fmvizcaino · Answer

Hi @craigja ,

The XML parse won`t capture everything you need at once. You can probably serialize the XML parse tools to identify everything you need, but it won`t be easy.

I`d say the best route is to use Regex. You will have to capture the Input and Output tools.

The highlighted areas are your guides to use in regex.

I pasted the workflow XML and built an example with Regex for you. You might be able to do something simpler by only searching for the string <Query> but I`m not sure other tools don`t have the same.

https://regex101.com/r/uRhHGO/1

Best,

Fernando Vizcaino