Re:Introducing Multi-Step Zaps: An Easier Way to Build Power...
by mikeknoop on Monday February 01, 2016 @03:10PM
(#11015002)
Some APIs do support "upsert" functionality which is basically what you suggested. It's not very popular though and Zapier previously had to support the lowest-common-denominator which is plain creates.
Now that we officially support Search actions, we can do a lot more cool things.
One of my biggest pain points was the lack of ability to determine if a record already exists before choosing to use an Update or Create action. (You'd think a service's API would treat Update the same as Create if no matching record is found, but that's not always the case.) So I've had to err on the side of caution and always use a Create action, thus filling the CRM (or whatever) with many many duplicates.
The search feature looks like it will handle this. Will be implementing shortly.