Forum Discussion

SteveLaurel's avatar
SteveLaurel
Qrew Cadet
2 years ago

Pipeline error - Duplicate Key - does not exist

I am getting errors on a few pipelines saying it can't add to the table due to duplicate key values; however, these values do not exist in the table. QB support is basically saying this is what somet...
SteveLaurel's avatar
SteveLaurel
Qrew Cadet
2 years ago

Thanks, Mark.  Here is how it is set up now.



------------------------------
Steve Laurel
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 years ago

Right, 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. 



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------