topic Alteryx Gallery - Export list of workflows in Alteryx Server Discussions

Alteryx Gallery - Export list of workflows

AJKENDALL95 — Thu, 12 Dec 2019 15:13:17 GMT

Hi All,

I'm a gallery admin and I want to export a list of workflows that are saved within the gallery, is this possible?

Re: Alteryx Gallery - Export list of workflows

WilliamR — Thu, 12 Dec 2019 15:25:20 GMT

Hello,

you can use the AlteryxServer Usage Report Macro to get the list (the standard output is .pdf but you can change it if you want).

Download it in the download area, if you want a link, please give us the version.

https://help.alteryx.com/server/current/admin/ServerUsageReport.htm

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Alteryx Gallery - Export list of workflows

Chandler_Bing — Thu, 12 Dec 2019 15:25:40 GMT

hi @AJKENDALL95

You can query the MongoDB to get the result.

Develop a workflow and hit the app infos collection in the MongoDB and you will get the list of workflows on the gallery.

Thanks

Re: Alteryx Gallery - Export list of workflows

JosephSerpis — Thu, 12 Dec 2019 15:31:17 GMT

I've done this two ways the first was logging onto the server where the private gallery is hosted and customizing the Alteryx server usage report and using the Mongo Input tool. The other way I've done it using the gallery admin API to get that data.

The following link written by @patrick_digan is very helpful if you are not familiar with the gallery API.

Re: Alteryx Gallery - Export list of workflows

Link86 — Fri, 19 Mar 2021 17:43:18 GMT

When using the build workflow method, I am getting a list that has double the workflows (filtered with endswith ".yxmd") than what is actually appearing in Gallery. Is there another field I should be filtering on? I have tried the Is Deleted field. However, that was not helpful as there were items listed as deleted = true but still appeared in my gallery. I am unable to use the other method in this thread.

Re: Alteryx Gallery - Export list of workflows

esoden — Thu, 13 May 2021 22:26:42 GMT

We developed a tool to augment Alteryx called Workflow Admin Manager. It allows you to do tons of reporting, analysis, searching, and updating of workflows. You can find all workflows hitting a certain database, drop a report of all workflows by database, search and export all workflows with a mileage calculation, etc.

You can even mass update your workflows. For example: Change all hardcoded 2020 filters to 2021. Or all mileage calculation to the new mileage expense amount. (Better yet...find them and show your users how to make them dynamic... 🙂

Tons of information, videos, etc. here: https://capitalizeconsulting.com/workflow-admin-manager/

Re: Alteryx Gallery - Export list of workflows

ks009673 — Fri, 29 Aug 2025 06:27:37 GMT

Hi

I want to export list of workflows from Alteryx Prod gallery with the help of Mongo DB input. Need your guidance