I'd love a way to "upsert" records from the API merging using a custom unique field.
For example... I have data that I pull a few times a day from an API. Currently I use Airtable to store the data but I'd love to bring it over to SS. With Airtable, I'm able to make a "batch upsert" query and pass along 10 records at a time, with a "fieldToMergeOn" key. I pass along a custom UUID field, and it either creates a new record or updates the existing.
It doesn't appear that SmartSuite currently has this ability in the API? Even just merging on the Primary Title of the record would be fine, but the only bummer there is then it makes the record ugly when displayed since it's just a random UUID instead of a "pretty" title. Best case scenario would be to add the ability to select a custom unique field to use to merge or create on.