Can you have a unique field that additional data overwirtes it

Need help Database
1

Hi,

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.

Thanks!
Shimon

2

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?

3

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

1 Like
4

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

5

probably doesn’t matter either way