topic Re: Chained Workflows in Alteryx Server Discussions

Chained Workflows

elaenscetric — Mon, 21 Feb 2022 07:47:02 GMT

Hi All - We're having 3 workflows and scheduled like 1st workflow was triggered at particular time in Gallery and it will trigger 2nd workflow via Alteryx Service command line event. Except first workflow the other 2 workflows will run as Ondisk jobs but recently We're facing many issue with this approach. Is there anyway to schedule all 3 workflows in Gallery in chained manner like once first completed successfully 2nd workflow should run & once 2nd workflow completed successfully 3rd workflow should run.

Re: Chained Workflows

fmvizcaino — Mon, 21 Feb 2022 15:44:57 GMT

Hi @elaenscetric ,

You can use something we call a chained app.

https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120

https://www.youtube.com/watch?v=h4NhAwUPpW0

Best,

Fernando Vizcaino

Re: Chained Workflows

elaenscetric — Mon, 21 Feb 2022 16:20:21 GMT

We don't need app. Need to know alternate approach for workflows.

Re: Chained Workflows

ArtApa — Sat, 05 Mar 2022 20:00:34 GMT

Hi @elaenscetric - There are a couple of ideas that you may try:

- New Runner tool: https://help.alteryx.com/20214/designer/runner-tool

- Alteryx Server APIs: https://help.alteryx.com/developer-help/server-api-overview

Re: Chained Workflows

elaenscetric — Mon, 14 Mar 2022 09:46:39 GMT

@ArtApa Do you have any reference solution to call Alteryx server API in automated way. Like one workflow completed successfully , then it should trigger another workflow.

Re: Chained Workflows

dougperez — Mon, 14 Mar 2022 12:22:49 GMT

Hello @elaenscetric

I have done a few api server integrations, see this code from some of my tests:

from alteryx_gallery_api_v3_compatible import *
import pandas as pd
from pandas import DataFrame
import requests

client_key = ""
client_secret = ""
workflowname = ''

gallery_url = '/gallery/api/v1'

con = Gallery(gallery_url, client_key, client_secret)
subs = con.subscription()
subs2 = subs[1]
df = DataFrame(subs2)
df = df.loc[df['fileName'] == workflowname]
df = df['id'].to_string(header=False, index=False)
execwork = con.execute_workflow(df)
print(execwork)

Re: Chained Workflows

fmvizcaino — Mon, 14 Mar 2022 13:34:13 GMT

Hey @elaenscetric ,

You cannot use the server APIs to run workflows, only analytical apps. You will need to transform all of your workflows to analytical apps, then you will be able to run them.

@patrick_digan has developed a macro that can help you do this task.

https://community.alteryx.com/t5/Engine-Works/Using-the-Alteryx-API-from-Alteryx/ba-p/318565

Best,

Fernando Vizcaino

Re: Chained Workflows

davidhe — Mon, 13 Jun 2022 20:36:46 GMT

@ArtApa so the runner tool appears to only provide the status of the workflow upon completion, how does it trigger a subsequent workflow?