topic List of workflows in Alteryx Gallery using a particular DB in Alteryx Server Discussions

List of workflows in Alteryx Gallery using a particular DB

Tomas_Vyskocil — Tue, 11 May 2021 10:46:36 GMT

Hi,

I would like to ask if there's any way to get a list of workflows with particular AWS db name inside of them.

I tried to use the Alteryx API service with GET/admin/v1/workflows, but that doesn't look like it's looking inside of the workflow.

Thank you,

Tomas

Re: List of workflows in Alteryx Gallery using a particular DB

dougperez — Tue, 11 May 2021 16:53:41 GMT

I used the API Gallery Phyton library to do the requests, have you tried?

https://community.alteryx.com/t5/Dev-Space/Python-library-for-Alteryx-Gallery-API/td-p/191018

Re: List of workflows in Alteryx Gallery using a particular DB

esoden — Thu, 13 May 2021 22:04:24 GMT

Hey Tomas,

You should take a look at Workflow Admin Manager. It allows you to query your server for data sources, queries, column names, formulas, filters, etc. It also allows you to mass update them.

Show me all workflows using AWS_DEV. Now update them to AWS_PROD.

https://capitalizeconsulting.com/workflow-admin-manager/

Let us know if you want to discuss your situation specifically. We have built a ton of functionality to help with larger deployments.

ericsoden@capitalizeconsulting.com

Re: List of workflows in Alteryx Gallery using a particular DB

TheOC — Thu, 13 May 2021 22:20:00 GMT

hey @esoden

Is this a free solution?

Cheers,
TheOC

Re: List of workflows in Alteryx Gallery using a particular DB

esoden — Thu, 13 May 2021 22:34:40 GMT

It's not free but it is amazing and worth the cost of entry!

So far we have 3,758 hours of development and product management dedicated to building it out. We also have 2.5 people on it full time. Hopefully in a few years we'll break even! 🙂