Skip to main content

Hi, I’ve created a Zap which will trigger whenever a row got added or updated in SQL table. The table contains set of rows with same primary key which is unique for the set of rows. I’ve used that column as primary_key and I’m using Date field as Order By. As mentioned by Zapier team, I need to use a unique Id as primary key and Date/Time field for Order By fields. Is there any way I can use my existing columns for this requirement.

Attached the screenshot for reference.

 

Hi @Bharath Y 

 

If the primary key field you mentioned “dim_company” is Unique and “qtr_ending_date” is a Date/Time field in SQL, this should work. Is something not working in this setup?


Hi @Bharath Y, just wanted to follow up from last week. Is there an error in your setup as Moh inquired above? Did you still need any help, let us know!