List
List Airtable records with filters
List
List Airtable records with filters
yaml
type: io.kestra.plugin.airtable.records.ListExamples
yaml
id: list_airtable_tasks
namespace: company.airtable
tasks:
- id: get_high_priority_tasks
type: io.kestra.plugin.airtable.records.List
baseId: "{{ secret('AIRTABLE_BASE_ID') }}"
tableId: "Tasks"
apiKey: "{{ secret('AIRTABLE_PERSONAL_ACCESS_TOKEN') }}"
filterByFormula: "AND({Status} != 'Done', {Priority} = 'High')"
fields: ["Task Name", "Status", "Priority", "Due Date"]
maxRecords: 50
fetchType: FETCH
yaml
id: list_customers
namespace: company.airtable
tasks:
- id: get_customers
type: io.kestra.plugin.airtable.records.List
baseId: "{{ secret('AIRTABLE_BASE_ID') }}"
tableId: "Customers"
apiKey: "{{ secret('AIRTABLE_PERSONAL_ACCESS_TOKEN') }}"
view: "Active Customers"
fetchType: STORE
yaml
id: list_all_records
namespace: company.airtable
tasks:
- id: get_all_records
type: io.kestra.plugin.airtable.records.List
baseId: "{{ secret('AIRTABLE_BASE_ID') }}"
tableId: "Orders"
apiKey: "{{ secret('AIRTABLE_PERSONAL_ACCESS_TOKEN') }}"
maxRecords: 100
enableAutoPagination: true
fetchType: FETCH
Properties
apiKey *Requiredstring
baseId *Requiredstring
tableId *Requiredstring
enableAutoPagination booleanstring
Default
falsefetchType string
Default
FETCHPossible Values
STOREFETCHFETCH_ONENONEfields array
SubTypestring
filterByFormula string
maxRecords integerstring
view string
Outputs
row object
rows array
SubTypeobject
size integer
uri string
Format
uri