Hello!
I am looking for some improvements to a workflow I have. What I need is to read all the workflows on the Gallery as csv/text files, then add a filter tool to pick up "something". Something can be "output" table. Or it can be a field name in a formula, and input file name or maybe just metadata of the file.
So far I have a working solution using the Alteryx Gallery API. I am able to collect a list of all workflows that are on the Gallery. For each file, I then make an API call (GET /v1/{appId}/package/ )to get the workflow itself stored as a BLOB. I then output this as a appId.ZIP. Next I use a dynamic input to read the workflow inside the zip file and I can filter out the records I am looking for.
But this takes 16 seconds per workflow and we have some hundred workflows, and I need to store the files.
Can I read the BLOB content as string or convert it to string within the workflow without storing it as a ZIP?