Update a record in an Airtable table

Update fields in an existing record by its ID. Only specified fields will be updated (PATCH operation).

yaml
type: "io.kestra.plugin.airtable.records.Update"

Update task status

yaml
id: update_task_status
namespace: company.airtable

tasks:
  - id: update_task
    type: io.kestra.plugin.airtable.records.Update
    baseId: "{{ secret('AIRTABLE_BASE_ID') }}"
    tableId: "Tasks"
    recordId: "recXXXXXXXXXXXXXX"
    apiKey: "{{ secret('AIRTABLE_PERSONAL_ACCESS_TOKEN') }}"
    fields:
      "Status": "In Progress"
      "Progress": 50
      "Last Updated": "{{ now() }}"
    typecast: true

Update customer information

yaml
id: update_customer
namespace: company.airtable

tasks:
  - id: update_customer_info
    type: io.kestra.plugin.airtable.records.Update
    baseId: "{{ secret('AIRTABLE_BASE_ID') }}"
    tableId: "Customers"
    recordId: "{{ inputs.customer_record_id }}"
    apiKey: "{{ secret('AIRTABLE_PERSONAL_ACCESS_TOKEN') }}"
    fields:
      "Email": "{{ inputs.new_email }}"
      "Phone": "{{ inputs.new_phone }}"
      "Last Contact": "{{ now() | date('yyyy-MM-dd') }}"

Update with conditional data

yaml
id: conditional_update
namespace: company.airtable

tasks:
  - id: update_conditionally
    type: io.kestra.plugin.airtable.records.Update
    baseId: "{{ secret('AIRTABLE_BASE_ID') }}"
    tableId: "Orders"
    recordId: "{{ inputs.order_id }}"
    apiKey: "{{ secret('AIRTABLE_PERSONAL_ACCESS_TOKEN') }}"
    fields:
      "Status": "{{ inputs.status }}"
      "Completed Date": "{{ inputs.status == 'Completed' ? now() : null }}"
      "Notes": "Updated via Kestra workflow"
Properties

API key

Airtable API key for authentication

Airtable base ID

The ID of the Airtable base (starts with 'app')

Fields to update

Map of field names to new values. Only these fields will be updated.

Record ID

The ID of the record to update (starts with 'rec')

Table ID or name

The ID or name of the table within the base

Default false

Typecast

Enable automatic data conversion from string values

Updated record

The updated Airtable record with id, createdTime, and all fields (including updated ones)

Record ID

The ID of the updated record