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
------------------------------
- David, thank you posting that the Restful API's can be initiated with a webhook. Do you also have the syntax and setup to initiate them from a Pipeline?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Hi Mark,
Whilst I've played with pipelines, so far we've not become good friends.
)-:
The sort of stuff which pipelines ought to excel in, I tend to use Zapier for - primarily because of the maturity of it's UX / error handling (and I have the Zapier account anyway for other things and know the interface inside out).
D
------------------------------
dmlaycock2000 dmlaycock2000
------------------------------- Thx
If I get a chance or a need I will play with Pipelines to see if I can guess into the setup syntax.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
