I’m having a difficult time figuring something out with Zapier. Here’s my flow and what I’m trying to accomplish. This is all contained in a single Zap.
- I have a Zapier catch WebHook that captures data from my vendor’s website – this works
- That data is processed as a new row in a table in our SQL Server DB – this portion works without my trigger (see item 3 below)
- I need to update that new row’s data in our SQL Server with additional data before passing the new row’s data to WooSender via Zapier. – Not working
- The data is sent to WooSender for their processing. - works
Here is what I have tried but to no avail. I created an after-insert trigger in our SQL server that gathers and updates this new record created from the Zapier WebHook contents adding the rest of the data I need to pass to WooSender. (i.e. time zone based on a zip code, WooSender campaign information, etc. The trigger is causing the action in Zapier to fail.