Airtable Update Data Flow Template
Last updated
Last updated
This Data Flow template is made up of two Data Operations that allow app builders to update a record in Airtable.This is achieved by connecting with the Airtable integration, passing data to this Data Flow and then updating a record with such data.
In Connection Builder, Data Flow templates can be found with pre-populated sample data. However, to meet the requirements of their Journey, app builders should perform the necessary adjustments, such as adding other Data Ops.
Bear in mind that in order to use the Airtable API as a datasource, credentials must be set in Configuration Builder > Integrations to connect the corresponding account.
This Data Flow contains four parts:
The Start pane keeps track of the inputs required by the Data Flow.
fields Variable of type Any
Service: Airtable API
Method: PATCH - to update adding new data
URL: URL endpoint for the request
Allow non-compliant HTTP headers: box unchecked
Content-Type: “application/json”
Headers: HTTP Parameter
Body: passing “fields” and “id” as JSON objects to the requested body
Query Parameters: no parameter set
Form Parameters: no parameter set
Had paging?: box unchecked
Run Results: AirData Variable of type Any that is automatically created to hold the results of this Operation.
result
rawResult
request
Transform Expression: Airscript expression to merge records by ID in Airtable
Output Format: Variable
Type: Text
Run Results: transform output Variable of type Any that is automatically created to hold the result of this Operation.
The End step is where variables from the Data Flow can be used as an output.
Sample Return Value: transform of type Any
Allow app builders to update a record in Airtable.
