Airtable Update

Airtable Update

Certified

Patch fields on an Airtable record

Partially updates a record identified by recordId; only provided fields are patched. Typecast is off by default; enable to coerce string inputs to Airtable types.

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

Reference (ref) of the pluginDefaults to apply to this task.

Defaultfalse

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

More Plugins in this Category

Stripe
Stripe

Tasks that interact with Stripe customers, payments, balances, and webhooks.

Business

15 tasks

1 blueprints

Klaviyo
Klaviyo

Tasks that interact with Klaviyo campaign APIs.

AIBusiness

7 tasks

3 blueprints