Forum Discussion
MarkShnier__You
Qrew Legend
5 years agoAre 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
------------------------------
GeoffBarrenger
5 years agoQrew Captain
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__You5 years ago
Qrew Legend
In 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
------------------------------