Qrew LegendThe upsert may not contain duplicate keys within the upsert set. So yes, those values do not already exists, but that is irrelevant for an upsert. The issue is that the set of record you are trying to upsert has duplicates.
if that is unavoidable, then change your upsert process to just upsert one record at a time. Like:
Prepare a bulk upsert
add upsert row
Commit upsert.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Thanks, Mark. Here is how it is set up now.
Qrew LegendRight, so you could change that to have inside the for each loop three steps.
Prepare a bulk upsert
Add row
Commit
Assuming that the cost of the problem is that the JSON data feed has duplicates within it.
