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
------------------------------
https://developer.quickbase.com/operation/upsert
This absolutely did the trick - wasn't that hard to format. Now I just have to look as to where it has to be used.
Thank you!
------------------------------
Geoff Barrenger
------------------------------