appmixer.airtable.records.ListRecords
List Records
1.0.4
Public
| Field | Type | Description |
|---|---|---|
| Base ID | select | - |
| Table ID | select | - |
| Field | Type | Description |
|---|---|---|
| Fields | multiselect | Fields to retrieve. Only data for fields which are in this list will be included in the result. If you don't need every field, you can use this parameter to reduce the amount of data transferred. |
| Filter by formula | textarea | A formula used to filter records. The formula will be evaluated for each record, and if the result is not 0, false, "", NaN, [], or #Error! the record will be included in the response. We recommend testing your formula in the Formula field UI before using it in your API request. See more in the filterByFormula API docs. |
| Sort | text | A list of sort objects that specifies how the records will be ordered. Each sort object must have a field key specifying the name of the field to sort on, and an optional direction key that is either asc or desc. The default direction is asc. Example: [{"field": "Feature", "direction": "desc"}]. See more in the sort API docs. |
| View | text | The name or ID of a view in the table. If set, only the records in that view will be returned. The records will be sorted according to the order of the view unless the sort parameter is included, which overrides that order. Fields hidden in this view will be returned in the results. To only return a subset of fields, use the fields parameter. |
| Record Metadata | toggle | An optional field that, if specified, includes commentCount on each record returned. |
| Output Type | select | Choose whether you want to receive the result set as one complete list, or one item at a time or stream the items to a file. For large datasets, streaming the rows to a file is the most efficient method. |
Dynamic variables loaded from /component/appmixer/airtable/records/ListTables?outPort=out
| Field | Type | Description |
|---|---|---|
| No fields defined for this port | ||