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
MarkShnier__You
Qrew Legend
Qrew LegendAre 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
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Hi, Thanks for the quick reply. 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. 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. There is no way to know (unless DoQuery first? ) if there had been a file before with the same name. Is the only solution to query first, and if no response AddRecord, but if there is then EditRecord? Seems cumbersome...
------------------------------
Geoff Barrenger
------------------------------
------------------------------
Geoff Barrenger
------------------------------
- MarkShnier__YouIn Pipelines hey have an "Upsert". (ie update or add like a saved table to table import can do) I don't knbow much about the New Restful APIs, if hey have any new Upsert type API.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------