Question

Unable to fetch new/updated rows from SQL to Salesforce

  • 22 December 2022
  • 2 replies
  • 38 views

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.

 


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +8

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?

Userlevel 7
Badge +8

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!