Update or Insert Records via the API using a custom unique merge field
C
Caleb Cook
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.
Nate Montgomery @ SmartSuite
Merged in a post:
Import to existing app using custom ID field
A
Anders Hansen
When rows in Excel and CSV files already have uniq IDs, it would be great with the ability to use that field as validation (EX: IF exists do nothing or update, else create) Right now title and auto number is available, in my case title is not uniq and auto number is SS generated.
Y
YES Integrations
Hey, you could batch insert and configure a merge records automation to trigger on new records
Jon Darbyshire
Hey Caleb Cook, thanks for your feedback! I have a few more questions for you:
- Can you provide more details on how you envision the 'fieldToMergeOn' key working within our system?
- What specific data are you pulling from the API multiple times a day and how would this feature improve your workflow?
- Could you elaborate on the 'ugly' record issue when merging on the Primary Title? How does this impact your use of the data?