You are viewing limited content. For full access, please sign in.

Question

Workflow monitor SQL table for new rows added

Workflow Version 10

Updated September 30, 2019

asked on June 26, 2019

I have a SQL database which brings in IP monitored issues. E.g. device issue picked up through the IP.

What i am trying to do, it to monitor the table in the SQL database, see when there is a row added and pull the details from the row into a now process form. I get the workflow to push data into a form BUT, i don't know how to get the workflow to pick up when a new row is added? i will possibly confirm it with a error id column which gives each new line a unique and sequential id.

Can someone guide me please?

Thanks in advance!

0 0

Replies

replied on September 30, 2019 • Show version history

I don't know about monitoring for new rows. But I have a workflow that runs on a scheduled basis (every hour) and queries the database for rows that are missing a check value. Any found and processes and then updated to list the check value, so that it isn't caught next hour. Works well for my needs.

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked June 26, 2019
Updated September 30, 2019
128 views