Airtable integration

Find or Create Record

Perform Find or Create Record through Airtable.

View as Markdown

airtable_find_or_create_record

writeairtable

Inputs

base_id
expressionrequired
Base Id
Required literal value or workflow expression.
table
expressionrequired
Table
Required literal value or workflow expression.
match_fields
jsonrequired
Match Fields
Required JSON value.
create_fields
json
Create Fields
Optional JSON value.
typecast
boolean
Typecast
Optional true-or-false value.
Default: false

Outputs

createdCreated
match_countMatch Count
match_record_idsMatch Record Ids
record_idRecord Id
recordRecord
fieldsFields
successSuccess
errorError
error_typeError Type
status_codeStatus Code

Output schema completeness: best_effort_declared

Safety

External effect: write
Confirmation recommended: No
Retry safe: No
Dry run supported: No

Schemas

These schemas are first-pass authoring guidance. Runtime validation remains authoritative.

Input schema

{
  "type": "object",
  "required": [
    "base_id",
    "table",
    "match_fields"
  ],
  "properties": {
    "table": {
      "description": "Required literal value or workflow expression.",
      "x-workflow-field-type": "expression"
    },
    "base_id": {
      "description": "Required literal value or workflow expression.",
      "x-workflow-field-type": "expression"
    },
    "typecast": {
      "type": "boolean",
      "default": false,
      "description": "Optional true-or-false value.",
      "x-workflow-field-type": "boolean"
    },
    "match_fields": {
      "description": "Required JSON value.",
      "x-workflow-field-type": "json"
    },
    "create_fields": {
      "description": "Optional JSON value.",
      "x-workflow-field-type": "json"
    }
  },
  "additionalProperties": false
}

Output schema

{
  "type": "object",
  "properties": {
    "error": {},
    "fields": {},
    "record": {},
    "created": {},
    "success": {},
    "record_id": {},
    "error_type": {},
    "match_count": {},
    "status_code": {},
    "match_record_ids": {}
  },
  "additionalProperties": true
}

View all Airtable actions