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

Question

I'm using the Upsert action&nbsp; with the REST API to update a QB table with a SQL table as the source and QB as the destination.&nbsp;The upsert works BUT is always just adding rows&nbsp; - it does not only updating.&nbsp; Do you have to supply the fields to look at for the update to take place, or a key?&nbsp;My first run inserted 98 records, good.&nbsp; I updated a status field in QB newly added record from 'Terminated' to 'Active'.&nbsp; &nbsp;Re-ran my SSIS package and it didn't update back to Terminated, but inserted a new row... for ALL 98 records.&nbsp; &nbsp;I now have all duplicate rows.Appreciate your input.------------------------------Barbara A.------------------------------------------------------------Barbara Alvarez------------------------------

seanboat-moore · Answer

Have you set a merge field in the code?------------------------------Sean Boat-MooreManager SMB DevelopmentProject Management Office and Quality Control NCR Corporation sean.boat-moore@ncr.com  |  ncr.com------------------------------

evanmartinez · Answer

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 MartinezCommunity Marketing ManagerQuickbase------------------------------

Forum Discussion

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

2 Replies