AirData Request

Overview

The AirData Request Operation provides a mechanism to Read/Write/Update/Delete to and from AirData.

Use Cases

  • To save information requested from a Web Flow in the Data Builder.

    • Insert a users’ personal information in a CUSTOMER object.

  • To update information requested from a Web Flow’s inputs in the Data Builder.

    • Update feedback from users in a CSAT object.

  • To query data that is currently in an AirData object.

    • Requesting a list of countries from AirData.

Data Operation Properties

App Object

Dropdown of App Objects, created in Data Builder, to perform the AirData request on.

Payload

Type

Defines the type of action the AirData Request will perform:

  • INSERT: to insert a new record to an app object. Allows the ability to control the error if there is a conflict with a constraint set on the AirData App object.

  • PUT: updates the app object if the __id matches, otherwise will insert a new record.

  • PATCH: updates an app object if it the __id matches, otherwise will return an error.

  • DELETE: to delete a record from an app object given an __id

  • QUERY: queries data from an app object

On conflict

Specifies an action that happens when there is a constraint set on the AirData App Object:

Error: if the object inserted doesn’t meet the criteria of the constraint and this is set to 'error', when run, it will result in an error.

Existing: if the object inserted does not meet the criteria of the constraint and this is set to 'existing', when run, the data operation will run as successful but it won’t insert any rows.

Objects to insert or update (when Payload Type is INSERT)

The App Object as an array to be inserted/updated into AirData.

There are two methods to pass data as an object.

  • Method 1: Create the object as an input variable in the Data Flow.

  • Method 2: Construct the object as a JSON payload.

Objects to delete (when Payload Type is DELETE)

To designate a column – that is, an App Object instance – to Delete from Airdata, it must be referred to by its unique __id.

Objects to insert or update (when payload type is PUT)

The value of the App Object to be updated into AirData.

Enter the field to be modified followed by the new value and then refer to the row by its unique __id.

Objects to insert or update (when using Related App Objects)

The App Object to be updated in AirData with the __id of the Related App Object.

To update a Related App Object , create a variable of the App Object to be updated and pass the id of the Related App Object:

Run Results

A Variable is automatically created to hold the results of this Operation. This will be an object describing the result of the operation, as well as the __id of the objects inserted/modified, depending on the request type.

Last updated