Forum Discussion

Qrew Member

4 years ago

REST API upsert to QB is not updating records with upsert: inserts instead of updates.

I'm using the Upsert action with the REST API to update a QB table with a SQL table as the source and QB as the destination. The upsert works BUT is always just adding rows - it does not only up...

APIs and custom code

EvanMartinez

Quickbase Staff

4 years ago

Hi Barbara,

To Sean's question above are you either importing the key field (Default is the Record ID# field in QB) for the records you have coming in or have you set a merge key in your API call? Otherwise it is going to create new records since it doesn't have a consistent key it is looking for to merge with.

------------------------------
Evan Martinez
Community Marketing Manager
Quickbase
------------------------------