Create Task on Dataflow Output by Row

Hi! If this isn't the right forum to post this, please let me know.
TL;DR: I'm trying to automate alerts/tasks from the output of a dataflow such that each row in the output gets its own task instead of the entire updated dataset getting one bulk "dataset is updated, here you go" task. Two failed attempts are detailed below.
I've created a discrepancy report such that the output of a DataFlow are only errant rows that need to be addressed by a person. I'd like to automate creating a task for each row in the output dataset to track how each item is dealt with.
- Create an alert (with Task action attached) to make an alert whenever a row is added to the dataset. The issue here is that it creates one row for all of the added rows (e.g. Client1: <discrepancy>, Client2: <discrepancy>... all on the same task)
- Attempt to create a recursive DataFlow with defined & mutually exclusive continue/exit conditions that are re-assessed after each iteration of a few DataFlows. Description is below in case I'm writing this incorrectly, but it appears that Domo really doesn't like recursion the way I'm trying to implement it.
Current Recursive DataFlow
On each iteration, a single non-processed row (identified by hash function in another DataFlow, these will always be unique) is added to a staging table, and an alert + task is driven off of the single-row staging table. The hash is logged to a master hash list against which all future iterations are checked. The exit condition is when there are no rows to process, and the continuation condition is when there are non-processed hashes.
Comments
-
task automation.
usually you'd use that in the context Domo's writeback connector offering. or at least... that's the dream they sell ?
a writeback connector is essentially a tile that runs at the end of magic etl that usually just ... sends data from Domo to another system via API.
in your case, instead of just pushing a JSON array, it sounds like you'd want to loop over each row in the output dataset and call a POST request to some task API.
For example
https://developer.domo.com/docs/projectsandtasks/projects-tasks-api-reference#Create%20a%20task
for each row in your output dataset send a post request to
POST https://api.domo.com/v1/projects/{PROJECT_ID}/lists/{LIST_ID}/tasks
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 813 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive