Forum Discussion
NathanHawe
5 years agoQrew Cadet
I'm pretty sure that's not possible with the API_AddRecord call. I've always had to use API_ImportFromCSV or otherwise separate my calls into API_AddRecord and API_EditRecord to perform a mix of adds and updates. The new RESTful API has an upsert that will do exactly what you need but if converting to API_ImportFromCSV is too big of a lift, switching to the the new API may also be undesirable. That all depends on your use case so it's probably worth a look: https://developer.quickbase.com/operation/upsert.
------------------------------
Nathan Hawe
------------------------------
------------------------------
Nathan Hawe
------------------------------
GeoffBarrenger
5 years agoQrew Captain
"Upsert" might be good! I hadn't seen this yet... will have a read through and see if I can format what I need in this way. The API_ImportFromCSV has some benefits - it's one call for more data instead of doing little calls - but individual calls will be more of a "real time update" which is what we're trying to accomplish. If anyone else has any other suggestions please send, otherwise thank you Nathan and Mark
------------------------------
Geoff Barrenger
------------------------------
------------------------------
Geoff Barrenger
------------------------------