Question

Only trigger when specific SQL column is updated and see its old value

  • 27 July 2021
  • 1 reply
  • 9 views

Userlevel 1

I am looking to create a new zap that triggers when ever a row is updated in SQL Server.

Then I need a filter out only rows where a specific column has been updated.

I’m not sure how to use the Filter step to find out what column has changed.

Then the next challenge I have is that is it possible to get both the old value and the new value?

It looks like zapier hashes the row, but I cant find any examples on how to do this.

Thanks!

Steve

 

 


1 reply

Userlevel 6
Badge +6

Hi @mestevelove 

You should be able to specify to trigger on certain columns using the following option as shown:

As of my current understanding, I don’t think you can just get the old value from Zapier. For that, you need to set up your SQL server to store the old value to a separate column as soon as it updates. This can be a complicated configuration.

Reply