Connecting already uploaded workflows to another new workflow in alteryx server.

Question

I have around 200 existing workflows, and I want to connect it to another workflow. When the any of the 200 workflow is run, the output should be the input of the new workflow i will be uploading. 
Possible solutions are:
Chaining the Apps and using run command to execute another workflow.

Is there a way where I do not need to open each and every 200 workflow to chain them? can it be done in the server setting itself?

fmvizcaino · Answer

Hi @abhi943 ,

Not sure I understood what you meant by 'this' so I will take a guess.

If you are looking for a way not to change the workflows and trigger them somehow, you could create a Python script that runs every 5 seconds, checking if there are new jobs for a specific workflow. Not ideal since you would be checking 200 workflows every 5 seconds, but you can. https://help.alteryx.com/current/en/server/api-overview/alteryx-server-api-v3/server-api-v3-objects/workflow-endpoints.html##

Another option is to connect to Alteryx`s back end and check for new jobs similarly to my previous suggestion. You have a collection called AS_queue that registers all the executions.

https://help.alteryx.com/20223/en/server/configure/mongodb-management/mongodb-schema-reference/alteryxservice-mongodb-schema.html##

Best,

Fernando Vizcaino

abhi943 · Answer

Hi @fmvizcaino ,
Thank you for the response.
I do have a question, Can we run a python script or usi API to acheive this? or any other workaround?. That would be really helpful

fmvizcaino · Answer

Hi @abhi943 ,

Very interesting use case! It would be nice to have something like this in Alteryx, but unfortunately, we don`t have it. 🙁

Run command or the crew macros would work for local workflows, not the ones published onto the Gallery.

If you want to run Gallery workflows, I suggest creating a macro that uses the Gallery APIs to call this workflow. Here is how a envision this:

* Analytical app* File path/file as a parameter
* Adapt your workflow to change the input tool path based on the parameter

* Macro to be included in all 200 workflows* This macro should have as an input the file path to be used
* Use the Gallery APIs to call the analytical app* Fortunately, there are some macros available to simplify your development: https://community.alteryx.com/t5/Engine-Works/Introducing-the-Alteryx-Server-v3-API/ba-p/899228
* This endpoint should be used to trigger the app: https://help.alteryx.com/current/en/server/api-overview/alteryx-server-api-v3/server-api-v3-objects/workflow-endpoints.html#create-a-new-job
* The question parameter has to be used to send the file path to your analytical app.

Not sure if I was clear enough. Let me know if you have any questions.

Best,

Fernando Vizcaino