Best answer

Ordering SQL source data by Ascending

Hi All, first post so go easy one me :)

I have several Zaps up and running perfectly from SQL to Salesforce, and have a good uinderstanding of how to set up a Zap etc.

My question is, can I change the ORDER BY in the trigger to work in Ascending order rather than Descending?

Best answer by Troy Tessalone

Article: https://docs.microsoft.com/en-us/sql/t-sql/queries/select-order-by-clause-transact-sql?view=sql-server-ver15

My trigger of New/Updated Row isn't picking up any of my updates

You'll need to specify ORDER BY by a date/time field such as date_updated or last_modified.

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

+14

Article: https://docs.microsoft.com/en-us/sql/t-sql/queries/select-order-by-clause-transact-sql?view=sql-server-ver15

You'll need to specify ORDER BY by a date/time field such as date_updated or last_modified.

⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor