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
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
------------------------------
"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
------------------------------