API API_AddRecord - with Update
Hello, Is it possible to use the API_AddRecord with updates? Occasionally there are already historical records with the key field (unique) field, and those commands fail. The other option it seem...
Forum Discussion
Hi
Glad to hear you've got a solution that works now.
An alternative approach you could use is the upsert functionality in the newerJSON API
https://developer.quickbase.com/operation/upsert
What's really useful is the fact that this can be called from a quickbase webhook (example screenshot below).
For bulk record upserts outside of Quickbase, in the past I've used the excellent Qunect ODBC Connector which has upsert capability.
https://www.qunect.com/
Cheers
David
------------------------------
dmlaycock2000 dmlaycock2000
------------------------------
Glad to hear you've got a solution that works now.
An alternative approach you could use is the upsert functionality in the newerJSON API
https://developer.quickbase.com/operation/upsert
What's really useful is the fact that this can be called from a quickbase webhook (example screenshot below).
For bulk record upserts outside of Quickbase, in the past I've used the excellent Qunect ODBC Connector which has upsert capability.
https://www.qunect.com/
Cheers
David
------------------------------
dmlaycock2000 dmlaycock2000
------------------------------