API API_AddRecord - with Update

Question

Hello,&nbsp;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.&nbsp; The other option it seems is to use API_ImportFromCSV but that will require a fairly large rewrite.&nbsp; If the API_AddRecord command has a "merge with" or "update" modifier that would be fantastic.&nbsp; Any ideas?------------------------------Geoff Barrenger------------------------------

nathanhawe · Answer

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

markshnier__you · Answer

Are you launching this API off a child record? Or can this record be a child so it can know if the Parent exists? If so, your URL formula can have an IF statement to switch to API_EditRecord if the Parent Record Exists.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

geoffbarrenger · Answer

Hi, Thanks for the quick reply.&nbsp; No, it is launching from an Applescript doing an audit on a list of files in specific folders and creating records of the files and metadata in the files.&nbsp; Occasionally though, there will have been a previous file with the same name (unavoidable), and in this case - the key field value would stay the same, but the other fields will be updated with the new metadata.&nbsp; There is no way to know (unless DoQuery first? ) if there had been a file before with the same name.&nbsp; Is the only solution to query first, and if no response AddRecord, but if there is then EditRecord?&nbsp; Seems cumbersome...------------------------------Geoff Barrenger------------------------------

markshnier__you · Answer

In Pipelines hey have an "Upsert".&nbsp; (ie update or add like a saved table to table import can do)&nbsp; &nbsp; &nbsp;I don't knbow much about the New Restful APIs, if hey have any new Upsert type API.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

geoffbarrenger · Answer

"Upsert" might be good!&nbsp; &nbsp;I hadn't seen this yet... will have a read through and see if I can format what I need in this way.&nbsp; 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.&nbsp; If anyone else has any other suggestions please send, otherwise thank you Nathan and Mark------------------------------Geoff Barrenger------------------------------

Forum Discussion

API API_AddRecord - with Update

Related Content

API_AddRecord Alternative URL Redirect

Nesting API Button Help (Add record and update another)

Updating $$ amounts

API_AddRecord Then Redirec To Dashboard

Question about Last updated by