Extract ID workflow from alteryx server

[_fegodoy]

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.

[fmvizcaino · Accepted solution]

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.

https://help.alteryx.com/20221/server/alteryxgallery-mongodb-schema

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.

https://gallery.alteryx.com/api-docs/#admin

Best,

Fernando Vizcaino

[_fegodoy]

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