Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

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

Extract ID workflow from alteryx server

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

2 REPLIES 2
fmvizcaino
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.

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

fmvizcaino_0-1658849920658.png

 

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
5 - Atom

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