Filtering data from an AirData request

I want to query an Airdata table for a particular value and unsure how to reference the query results.

I’m using an Airdata Request with a QUERY type but unsure what to put in the filter box.

FROM item in collection WHERE item.email=email_input SELECT Item

collection isn’t the right keyword but not sure what to substitute here.

2 Likes

Hi @dinesh,

When querying data in AirData using the QUERY operation, you have to use specific syntax to create your query. This can be found in the doc AirData Querying Capabilities.

For example, if you wanted to find all the records that match a specific email address (i.e. ismaen@airkit.com) you would have to do the following:

Example Data:
2022-01-18_14-57-31

Query:

{ "email": { "eq": "ismaen@airkit.com" } }

This would result in only records where the email column is equal to “ismaen@airkit.com

3 Likes