Help identifying workflow dependencies using server API outputs

[wshube]

My team and I are trying to develop some documentation of our workflows, and we'd like to get a view of all the dependencies we have. We were thinking of using the output log of the server API to develop a table that would look like this (or something similar):

Workflow name	Dependency type (input/output/macro...)	Dependency name (table name, macro name...)	Dependency location
Example workflow 1	Input	SQL.example_input_table	SQL server
Example workflow 1	Macro	Workflow 1 macro	File share
etc

Does anyone have any tips for doing this? I assume it's a bunch of regex but figured I'd ask around before we start reinventing the wheel.

[ArtApa · Accepted solution]

HI @wshube - There is a product called Alteryx Connect, which does this and more very well: