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

[abhi943]

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]

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:

1. Analytical app
   1. File path/file as a parameter
   2. Adapt your workflow to change the input tool path based on the parameter
2. Macro to be included in all 200 workflows
   1. This macro should have as an input the file path to be used
   2. Use the Gallery APIs to call the analytical app
      1. 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
      2. 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/...
      3. 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

[abhi943]

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]

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/...

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/alter...

Best,

Fernando Vizcaino