How to search all workflows for specific comnnections

Question

I have installed the API tools and have downloaded all my workflows, I now want to be able to search through these for specific connection strings.  Is there an easy way to do this?  At the moment, all workflows are downloaded as ZIP files, I then use Python to extract the workflow from the zip and change the extension to XML but Im not sure how to parse the complete XML to look for specific strings

ArnaldoSandoval · Answer

Hi @craigja

You may also try this tool Finder, here is its link FINDER 3.0 - Search all your workflows contents for keywords, tools, inputs, outputs etc

You can customise this tool for your needs.

hth

Arnaldo

EdP · Answer

See the following article for a great workflow that automates the process of searching all Server workflows for a specific DB connection (using OAuth2 available in 2021.4+):

https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Search-Gallery-Workflows-for-Connections-Files-Queries-Tools-and/ta-p/1098230

JosephSerpis · Answer

If you parse the xml of the workflows as a CSV in a Input Data tool with a delimteter of 
 you get the xml in one field across many lines so that should help you search the xml to search for the connection.