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

Question

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.

Collection-Workflows_Info_latest.yxmd

fmvizcaino · Answer

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

Aparanjith_DSG · Answer

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).

Output_Result.PNG

fmvizcaino · Answer

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-api-v3

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

Best,

Fernando Vizcaino