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
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
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! 🙂