Run an Alteryx Workflow with the run command tool

Hi,

I hope you are good.

Is it possible to launch a saved alteryx workflow in a other one workflow ?

I'm trying to centralize all my workflows in one by giving the paths of my workflows in the run command tool but i'm struggling, it look like the tool need an input path and output.

I can't use any package, only the alteryx designer version.

I build this and the tool need a input/output but the workflow executed have his input and his output so i don't understand.

Thanks in advance !!

image.png

Alteryx Editions

Accepted answers

All comments

Qiu

@Samyy
Try to search Chain Apps.

Samyy

Hi,

Thx for your com, idk if it's exactly that, it's more like the user have multiple choice for starting multiplie workflows and he need to choose which one he will start but there are not dependant each of them, there are not in a row.

For example thats the interface of start (more for centralized everything) :

image.png

alexnajm

How about looking at the runner tools as part of your app to activate certain containers that would run those workflows? Runner Tool

If you don't have that tool, you can download the cReW macros: Chaos Reigns Within: Alteryx CReW Macros

Samyy

Hi,

Thx for your answer but as i said i can't download any packages/macros because i have some stricts restrictions

flying008

Hi, @Samyy

Workflows can be run via the command line using the AlteryxEngineCmd.exe. The AlteryxEngineCmd.exe is located in the Alteryx root directory and requires an Engine API license to use.

Example functions:

AlteryxEngineCmd.exe MyWorkflow.yxmd

Samyy

Hi,

Thanks for your advice, but it's not what im trying to do, i just want a centralized workflow which many options of workflows that i want to run and for example it allows a user to launch multiple workflows with one click

Gaurav_Dhama_

If you are using just the designer, then what you can ideally do is keep all the possible workflows saved in a folder. Now what you would do is, create a chained app, what this app will do is take input from user and trigger another app called App2.

Now here is the trick, in your chained app, first flow use blob input to pick the workflow that user selected, then use blob output to replace App2 with this workflow (make sure it is renamed to App2). What will essentially happen is that the Chained App will just trigger App2, but in background you have replaced what App2 is.

Give it a go, I had done this POC few years back in version 2021 or 2022 and it had worked fine.

Let me know if that is not clear.

Please note this will not work on Gallery.

abacon

@Samyy If you are running them on gallery, would the Server APIs work? You could build an app that allows the users to choose which workflows to run, based on that selection, it could add the workflow IDs to an API call that triggers all the workflows within the body of the code. The Post /v3/workflows/{workflowId}/jobs call would do that and you just have to pass the Workflows IDs into the API Server tool.

https://marketplace.alteryx.com/en-US/apps/418052/server-api-tool

This is how I would go about it and it wouldn't need the run command tool or cmd line execution.

Bacon

Gaurav_Dhama_

Challenge with that is how will the user pass on the parameters.

If there are 10 apps that users can select from, 10 apps worth questions must somehow be present in the main app that is triggering the API.

I think what can actually work is if you can make the apps inputs free and run off of templates.

then templates can be passed as parameter to the next app via api.

Do you have any other thoughts about it?

apathetichell

@Gaurav_Dhama_ and @abacon are both correct and have done a great job here pointing out strategies to get this to work --- and issues with it on server. This is a pain point I've had with Alteryx.

You could make a live datasource (database) mapping workflows and input parameters and have:

app 1---> choose workflow. search for parameters

app 2-> provide interface screen to user ---> build payload. call api.

app 3-> run workflow via api.

Samyy

Thanks for your replies, i can not work in gallery unfortunately so i tried the alternative with the mix of chained app and blob tool but I can't get it to work, I don't quite understand how the output blob can execute a workflow and how to replace the workflow which will be executed...

Gaurav_Dhama_

Here you go, run App1.

App1 will allow you to select from two other apps that you want to run, and it will trigger the one selected.

Dynamic Chained App.zip

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703