Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Extract ID workflow from alteryx server

5 - Atom

Hello guys,


We pretend to trigger our workflows using the API and get the ID one by one isn't the best way.


There's any way to extract all workflows name's and id's using the server database? Anyone has tried this? Which tables can have this data?


The API doesn't have this info, so I guess I could get it easier from de Mongo.


Thanks a lot.

17 - Castor
17 - Castor

Hey @_fegodoy ,


You can do both ways. 

1. MongoDB: Appinfos collection inside the AlteryxGallery database. The workflowID is the sourceappID and keep in mind that you will need to do some cleaning, because there you also have access to deleted assets.


2. Gallery APIs (easier option): You have this endpoint in all server versions. /admin/v2/workflows/all



Here is the documentation page of the public gallery APIs. This is an older version, but you have the endpoints there.



Fernando Vizcaino


5 - Atom

It works using the API, thanks a lot @fmvizcaino :)