Set up a workflow to run automatically when one process is completed.

[Atmaja]

I have a server A and server B. When the data is received it will process data at server A and store the data in database at Server B for Alteryx to process further.
I want my Alteryx workflow to kick off automatically at server B as soon as my data processing is completed at server A and successfully written to server B
can anybody help on how this can be achieved?  Thank you!!

[Felipe_Ribeir0]

Hi @Atmaja 

Take a look at this recent topic, you will probably find the answer here:

Automation dependency on another workflow run - Alteryx Community

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.

[Atmaja]

Thank you for your quick response. Is there any way it can be achieved as Event based Trigger? Data Processing on Server A should Automatically trigger Alteryx workflow on server B

[koppenhe]

You can try to have server A launch a bat file to call the workflow. Some documentation was previously referenced here: https://help.alteryx.com/20221/designer/run-workflows-command-line

[danilang]

Hi @Atmaja 

You can use the Gallery API to programmatically launch a workflow on a server from an external machine.  The details are here. You do have to be careful when calling this.  For instance the Alteryx server does not filter requests to execute a job based on whether the job is currently running or not.  So if you add the api call to an on-update trigger in SQL and 1000 records get updated, you will queue the workflow 1000 times.   

Dan 

[Atmaja]

Hi Dan, Thanks for your input. I'm new to Alteryx and I am not aware of the Gallery API. Does it mean we have to set up a trigger on table to call this API?

[danilang]

Hi @Atmaja 

Yes.  If you're using SQL, an after update trigger would work well, if you ensure that you only call the API once if inserting multiple rows.

Dan