Get a single record from an Airtable table

Retrieve a specific record by its ID from an Airtable table with optional field selection.

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

Examples

Get a specific task record

yaml
id: get_airtable_task
namespace: company.airtable

tasks:
  - id: get_task
    type: io.kestra.plugin.airtable.records.Get
    baseId: "{{ secret('AIRTABLE_BASE_ID') }}"
    tableId: "Tasks"
    recordId: "recXXXXXXXXXXXXXX"
    apiKey: "{{ secret('AIRTABLE_PERSONAL_ACCESS_TOKEN') }}"
    fields: ["Task Name", "Status", "Priority", "Due Date"]

Get a customer record with all fields

yaml
id: get_customer
namespace: company.airtable

inputs:
  - id: customer_id
    type: STRING
    required: true

tasks:
  - id: get_customer_record
    type: io.kestra.plugin.airtable.records.Get
    baseId: "{{ secret('AIRTABLE_BASE_ID') }}"
    tableId: "Customers"
    recordId: "{{ inputs.customer_id }}"
    apiKey: "{{ secret('AIRTABLE_PERSONAL_ACCESS_TOKEN') }}"

Properties

apiKey *string

API key

Airtable API key for authentication

baseId *string

Airtable base ID

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

recordId *string

Record ID

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

tableId *string

Table ID or name

The ID or name of the table within the base

fields array

SubType string

Fields

List of field names to retrieve. If not specified, all fields are returned.

Outputs

record object

Retrieved record

The Airtable record with id, createdTime, and fields