Need to pull all the output locations for all the workflows from Mongo DB

[Aparanjith_DSG]

Hi,

I need to pull a report which should have information about all the workflows and all the output locations for those workflows within the collections.

I am trying to input it from the MongoDB by using AppInfos but that does not have any information about the output locations for the workflows.

[fmvizcaino]

Hi @Aparanjith_DSG ,

The inputs and outputs are inside the workflows only. Luckily, workflows are XML files and somewhat easy to parse. 

I suggest using the Gallery APIs to download all workflows and then parse each workflow XML for its outputs.

https://help.alteryx.com/current/en/server/api-overview/alteryx-server-api-v3.html#alteryx-server-ap...

Here is a macro that does part of the XML parsing.

 

Best,

Fernando Vizcaino

[Aparanjith_DSG]

But this macro is only giving the information about how many Output tools are present (it's only giving the count), I am looking for the actual path where the output is being generated (a NAS path or a table name).

[fmvizcaino]

Hey @Aparanjith_DSG ,

That is exactly why I mentioned "part of the XML parsing". 😁 You would need to adapt this macro to your needs.

Best,

Fernando Vizcaino