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
Best answer by robschmidtBest answer by robschmidt
Hi
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.
+9Hi
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
