Hi there, I was wondering what’s the best seatable workaround in n8n to search a table for an existing record and creating a record if it not exists or update the existing one. With no code experience I have trouble realising this in n8n. Airtable has a node which is called upsert a record. Are there any seatable plans for a comparable node?
1 Like
I took the liberty of correcting the name of the action in the Airtable node.
On Monday I will add a new action “create or update a row” to the SeaTable n8n community node.
2 Likes
Awesome, thanks! Would be nice if this would also support doing it with bulk data. e.g. 100 rows with one request.
perfect. Thank you!
You mean, if the “matching criteria matches” multiple lines, all should be updated?
This will be the case.
Currently the new action looks like this:
More details on Monday.
Looks good 
With batch I meant that when there are e.g. 100 input items that there are not 100 requests being sent to the server but only one, to decrease the execution time.
I am sorry to disappoint you, but like almost every other node, we will not support Run Once for All Items.
Would it be possible to add an upsert API endpoint with that functionality? then in n8n we could just use the HTTP node. With the update rows endpoint sending multiple rows is already possible.
Version 2.2.0 of the SeaTable n8n Community Node has been released, introducing support for an upsert action.
1 Like
This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.
