airtable: Create or Update Record – Appmixer connector library

Basic Information

Name

appmixer.airtable.records.CreateOrUpdateRecord

Label

Create or Update Record

Version

1.0.0

Visibility

Public

Description

Creates or updates a single record in a table.

Properties

Field	Type	Description
Base ID	select	-
Table ID	select	-
Merge Fields	multiselect	Select fields which will be used to update by. If the selected field value filled here matches value already presented on Airtable, the record will be updated with filled fields, otherwise a new record will be created. Maximum: 3 fields.

Input Ports

in

Dynamic fields loaded from /component/appmixer/airtable/records/ListTables?outPort=out

Output Ports

out

Dynamic variables loaded from /component/appmixer/airtable/records/ListTables?outPort=out

Full Metadata

#metadata-viewer { display: none; }{ "name": "appmixer.airtable.records.CreateOrUpdateRecord", "author": "Zbyněk Peluněk <zbynek.pelunek@client.io>", "label": "Create or Update Record", "description": "Creates or updates a single record in a table.", "private": false, "version": "1.0.0", "auth": { "service": "appmixer:airtable", "scope": [ "data.records:write" ] }, "quota": { "manager": "appmixer:airtable", "resources": "messages.send", "scope": { "userId": "{{userId}}" } }, "properties": { "schema": { "type": "object", "properties": { "baseId": { "type": "string" }, "tableId": { "type": "string" }, "fieldsToMergeOn": {} }, "required": [ "baseId", "tableId", "fieldsToMergeOn" ] }, "inspector": { "inputs": { "baseId": { "type": "select", "label": "Base ID", "index": 1, "source": { "url": "/component/appmixer/airtable/records/ListBases?outPort=out", "data": { "messages": { "in/isSource": true }, "transform": "./ListBases#toSelectArray" } } }, "tableId": { "type": "select", "label": "Table ID", "index": 2, "source": { "url": "/component/appmixer/airtable/records/ListTables?outPort=out", "data": { "messages": { "in/baseId": "properties/baseId", "in/isSource": true }, "transform": "./ListTables#toSelectArray" } } }, "fieldsToMergeOn": { "type": "multiselect", "label": "Merge Fields", "tooltip": "Select fields which will be used to update by. If the selected field value filled here matches value already presented on Airtable, the record will be updated with filled fields, otherwise a new record will be created. Maximum: 3 fields.", "index": 3, "source": { "url": "/component/appmixer/airtable/records/ListTables?outPort=out", "data": { "properties": { "tableId": "properties/tableId", "selectedTableFieldsOutput": true, "returnType": "inPorts" }, "messages": { "in/baseId": "properties/baseId" }, "transform": "./transformers#transformFieldsToMergeOnFields" } } } } } }, "inPorts": [ { "name": "in", "source": { "url": "/component/appmixer/airtable/records/ListTables?outPort=out", "data": { "properties": { "tableId": "properties/tableId", "selectedTableFieldsOutput": true, "addFields": [ "recordId" ], "requiredFields": "properties/fieldsToMergeOn", "returnType": "inPorts" }, "messages": { "in/baseId": "properties/baseId" }, "transform": "./transformers#transformFieldsToInspector" } } } ], "outPorts": [ { "name": "out", "source": { "url": "/component/appmixer/airtable/records/ListTables?outPort=out", "data": { "properties": { "tableId": "properties/tableId", "selectedTableFieldsOutput": true, "returnType": "outPorts", "addFields": [ "action" ] }, "messages": { "in/baseId": "properties/baseId" }, "transform": "./transformers#transformFieldsToOutput" } } } ], "icon": "data:image/svg+xml;base64,PCFET0NUWVBFIHN2ZyBQVUJMSUMgIi0vL1czQy8vRFREIFNWRyAxLjEvL0VOIiAiaHR0cDovL3d3dy53My5vcmcvR3JhcGhpY3MvU1ZHLzEuMS9EVEQvc3ZnMTEuZHRkIj4KDTwhLS0gVXBsb2FkZWQgdG86IFNWRyBSZXBvLCB3d3cuc3ZncmVwby5jb20sIFRyYW5zZm9ybWVkIGJ5OiBTVkcgUmVwbyBNaXhlciBUb29scyAtLT4KPHN2ZyB3aWR0aD0iNjRweCIgaGVpZ2h0PSI2NHB4IiB2aWV3Qm94PSIwIC0yMC41IDI1NiAyNTYiIHZlcnNpb249IjEuMSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiB4bWxuczp4bGluaz0iaHR0cDovL3d3dy53My5vcmcvMTk5OS94bGluayIgcHJlc2VydmVBc3BlY3RSYXRpbz0ieE1pZFlNaWQiIGZpbGw9IiMwMDAwMDAiPgoNPGcgaWQ9IlNWR1JlcG9fYmdDYXJyaWVyIiBzdHJva2Utd2lkdGg9IjAiLz4KDTxnIGlkPSJTVkdSZXBvX3RyYWNlckNhcnJpZXIiIHN0cm9rZS1saW5lY2FwPSJyb3VuZCIgc3Ryb2tlLWxpbmVqb2luPSJyb3VuZCIvPgoNPGcgaWQ9IlNWR1JlcG9faWNvbkNhcnJpZXIiPiA8Zz4gPHBhdGggZD0iTTExNC4yNTg3MywyLjcwMTAxNjk1IEwxOC44NjA0MDIzLDQyLjE3NTYzODQgQzEzLjU1NTI3MjMsNDQuMzcxMTYzOCAxMy42MTAyMzI4LDUxLjkwNjUzMTEgMTguOTQ4NjI4Miw1NC4wMjI1MDg1IEwxMTQuNzQ2MTQyLDkyLjAxMTc1MTQgQzEyMy4xNjM3NjksOTUuMzQ5ODc1NyAxMzIuNTM3NDE5LDk1LjM0OTg3NTcgMTQwLjk1MzYsOTIuMDExNzUxNCBMMjM2Ljc1MjU2LDU0LjAyMjUwODUgQzI0Mi4wODk1MSw1MS45MDY1MzExIDI0Mi4xNDU5MTYsNDQuMzcxMTYzOCAyMzYuODM5MzQsNDIuMTc1NjM4NCBMMTQxLjQ0MjQ1OSwyLjcwMTAxNjk1IEMxMzIuNzM4NDU5LC0wLjkwMDMzODk4MyAxMjIuOTYxMjg0LC0wLjkwMDMzODk4MyAxMTQuMjU4NzMsMi43MDEwMTY5NSIgZmlsbD0iI0ZGQkYwMCI+IDwvcGF0aD4gPHBhdGggZD0iTTEzNi4zNDkwNzEsMTEyLjc1Njg2MyBMMTM2LjM0OTA3MSwyMDcuNjU5MTAxIEMxMzYuMzQ5MDcxLDIxMi4xNzMwODkgMTQwLjkwMDY2NCwyMTUuMjYzODkyIDE0NS4wOTY0NjEsMjEzLjYwMDYxNSBMMjUxLjg0NDEyMiwxNzIuMTY2MjE5IEMyNTQuMjgxMTg0LDE3MS4yMDAwNzIgMjU1Ljg3OTM3NiwxNjguODQ1NDUxIDI1NS44NzkzNzYsMTY2LjIyNDcwNSBMMjU1Ljg3OTM3Niw3MS4zMjI0Njc4IEMyNTUuODc5Mzc2LDY2LjgwODQ3OTEgMjUxLjMyNzc4Myw2My43MTc2NzY4IDI0Ny4xMzE5ODYsNjUuMzgwOTUzNyBMMTQwLjM4NDMyNSwxMDYuODE1MzQ5IEMxMzcuOTQ4NzEsMTA3Ljc4MTQ5NiAxMzYuMzQ5MDcxLDExMC4xMzYxMTggMTM2LjM0OTA3MSwxMTIuNzU2ODYzIiBmaWxsPSIjMjZCNUY4Ij4gPC9wYXRoPiA8cGF0aCBkPSJNMTExLjQyMjc3MSwxMTcuNjUzNTUgTDc5Ljc0MjQwOSwxMzIuOTQ5OTEyIEw3Ni41MjU3NzYzLDEzNC41MDQ3MTQgTDkuNjUwNDc2ODQsMTY2LjU0ODEwNCBDNS40MTEyOTA0LDE2OC41OTMyMTEgMC4wMDA1Nzg1MzEwNzMsMTY1LjUwMzg1NSAwLjAwMDU3ODUzMTA3MywxNjAuNzk0NjEyIEwwLjAwMDU3ODUzMTA3Myw3MS43MjEwNzU3IEMwLjAwMDU3ODUzMTA3Myw3MC4wMTczMDE3IDAuODc0MTYwNDUyLDY4LjU0NjM4NjQgMi4wNDU2ODU4OCw2Ny40Mzg0OTk0IEMyLjUzNDU0NDYzLDY2Ljk0ODE5NDQgMy4wODg0ODgxNCw2Ni41NDQ2Njg5IDMuNjY0MTI2NTUsNjYuMjI1MDMwNSBDNS4yNjIzMTg2NCw2NS4yNjYxMTUzIDcuNTQxNzMxMDcsNjUuMDEwMTE1MyA5LjQ3OTgxMDE3LDY1Ljc3NjY2ODkgTDExMC44OTA1MjIsMTA1Ljk1NzA5OCBDMTE2LjA0NTIzNCwxMDguMDAyMjA2IDExNi40NTAyMDYsMTE1LjIyNTE2NiAxMTEuNDIyNzcxLDExNy42NTM1NSIgZmlsbD0iI0VEMzA0OSI+IDwvcGF0aD4gPHBhdGggZD0iTTExMS40MjI3NzEsMTE3LjY1MzU1IEw3OS43NDI0MDksMTMyLjk0OTkxMiBMMi4wNDU2ODU4OCw2Ny40Mzg0OTk0IEMyLjUzNDU0NDYzLDY2Ljk0ODE5NDQgMy4wODg0ODgxNCw2Ni41NDQ2Njg5IDMuNjY0MTI2NTUsNjYuMjI1MDMwNSBDNS4yNjIzMTg2NCw2NS4yNjYxMTUzIDcuNTQxNzMxMDcsNjUuMDEwMTE1MyA5LjQ3OTgxMDE3LDY1Ljc3NjY2ODkgTDExMC44OTA1MjIsMTA1Ljk1NzA5OCBDMTE2LjA0NTIzNCwxMDguMDAyMjA2IDExNi40NTAyMDYsMTE1LjIyNTE2NiAxMTEuNDIyNzcxLDExNy42NTM1NSIgZmlsbC1vcGFjaXR5PSIwLjI1IiBmaWxsPSIjMDAwMDAwIj4gPC9wYXRoPiA8L2c+IDwvZz4KDTwvc3ZnPg==" }