Check to see if MS SQL Record exists before committing new record

Questions & Answers
,
1

I want to check my existing MS SQL Server table for a registration id from a webhook payload before it makes a new entry for what would be a duplicate registration.

I planned to use a MS SQL Module in the route to check to see if the incoming regstrantid is already in a record. If not create a new record. If the registrantid is already in the system, it would be ignored.

image
image761×874 68.7 KB

TIA

3

Hello @Stevishere,

I’ve read through your post and it seems like you have a plan in place. Do you have a specific question or is there a particular issue you’re facing?

Glenn - Callinetic

2 Likes
4

I am unclear how to use a router? or filter? for this to occur.