Make Alteryx App run automatically when different users upload Input Files to Gallery

I want to build an Alteryx App on Alteryx Gallery that is dependent on 5 input files which are managed by 5 people. I want the Alteryx App to run automatically only when the 5 Input files have been uploaded to Gallery by the 5 people managing the files.

Please how can I design an app that will work in this automated way?

Gallery

Output

Schedule

Server

Apps

Dynamic Processing

Chained App

Run As

Accepted answers

All comments

gabrielvilella

You can do this, but it's not pretty. There is the option to schedule the workflow for a certain time and the workflow will just keep running waiting for all the files, you can use this tool here: https://github.com/bobpeers/Alteryx_SDK_EventTrigger

NOTE: The workflow keep running indefinitely until the file is there, occupying a slot on the queue if you have it set to run multiple jobs at the same time. Depending on the amount of time it keeps waiting, the setting in System Settings might also kill the job because it is running for too long.

Another idea is that if you can have an external application constantly looking for the files, when they are ready it triggers the Server API call to queue the workflow for execution. This is the ideal scenario.

vibes360

Thank you for your reply @gabrielvilella . What external API can we use to trigger the Server API call to queue the workflow for execution?

gabrielvilella

This one: /v1/workflows/{appId}/jobs

vibes360

Happy new year @gabrielvilella Thanks. I used the Event Trigger Tool in my workflow for a file. Please which of the attributes of the tool can I use to know when a new change has been made to a file. I have attached a screenshots of the attributes of the Event Trigger Tool

gabrielvilella

That tool will just trigger if a file gets added to a folder. It does not check if there are changes within the file. To do this, you'd need to build a workflow that checks for those changes.

vibes360

@gabrielvilella Since my goal is to write to a database. How should I configure the Tool/ workflow that when it is run, if there are no changes to the file ,the workflow does not write to the database but when there is a change to the file it writes to a database?

gabrielvilella

Read the two files, transpose the data if needed, join, compare the fields, filter when there is a change, update the database if true.

vibes360

Okay, I get your explanation. Thanks

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703