Chained Workflows

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.

Gallery

Best Practices

Accepted answers

All comments

fmvizcaino

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

elaenscetric

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

ArtApa

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

elaenscetric

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

dougperez

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)

fmvizcaino

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

davidhe

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703