Can you have a unique field that additional data overwirtes it


I am saving data from an API into a table. I want only the newest data to be saved while all the data that was already in the database and carries a unique ID of sorts to be either skipped or updated.

Is that possible?

Hope my explanation makes sense.


I figured that I can just do a search for that Id and only do the workflow if that search count is 0.

But is that the best way?

that works, you can also do a search:first item is empty

1 Like

Thanks for the suggestion. Do you know which one is more efficient?
search:count is 0
search:first item is empty

probably doesn’t matter either way