Retrieving workflow xml from Gallery

We were wondering if it was possible to retrieve the workflows that are saved on the Gallery.

The reason for this is that there is a handy xml parser tool that allows you to parse the xml of an Alteryx workflow to give you tool details such as:

Input tool - [database where the data is coming from]

Formula tool - [what formulas are used]

Output tool - [database where the data is going]

The workflows that are saved on the Gallery however are stored in the MongoDB, but I assume that to download or run a workflow from the Gallery that there is a method of retrieving the workflow from the Mongo and converting it to its original form.

Does someone know the tool or method that is used to do this so that we might replicate it to pull off all of our workflows on the gallery and then analyse them using the above mentioned xml parser?

Many Thanks in advance.

Oli

Workflow

Gallery

Accepted answers

BenMoss

Hi!

Just to add something her; we have developed a workflow that pulls down and saves all assets to a share drive, the workflow is attached and uses the API that @danilang is outlining.

Something to note is that assets may download as .yxzp files because when published the user checked the option to include assets, therefor you will need to create a script which unpackages each of these (well at least we do).

We then use the conditional runner tool (part of the CReW macro pack) to then run a workflow which pulls all files out of the direcory and scans the XML for comment boxes.

I've also attached the script (I've had to change the extension to .txt rather than .bat because I could not attach that) that we trigger once the workflow is ran to unzip the files using the events tab.

Get and Store Workflows.yxzp

7Zip Extract All.txt

All comments

danilang

Hi @obridgeman

Check out @patrick_digan's great solution here

Dan

obridgeman

Hi Dan,

Thanks for the link I had a look into it but maybe I am just terrible at reading the instructions given but I can't get the macro to work!

I replace the URL and Endpoint in the Macro and provide my admin key and secret but I get a 401 authorisation error.

Does the username have to be included in the URL?

In the meantime (as I haven't really used API before) I have set about making a Log Parser for Alteryx Engine Logs which we will use to read the logs and spit out the SQL tables involved and if they were read from or written to.

Useful for us as it will let us know where data is coming from and going to through Alteryx.

I'd like to use the xmls though!!

Thanks,

Oli

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703