Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

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