Airtable query (GET) filter with json (non relational) data

Topic Labels: ImportingExporting
1235 3
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I am making a GET request to an airtable collection (the data has the form of a list of jsons).

I am trying to add a filter according to the documentation but because my data is not relational but json-like, I can’t access the fields inside the records.

With an example:

The simple GET output:

    "results": [
            "id": "12345",
            "date": "2022-04-14T05:14:16.000Z",
            "info": {
                "username": "random1" }, 
            "id": "123456",
            "date": "2022-04-13T15:14:16.000Z",
            "info": {
                "username": "random2" }]

I would like to filter the date and/or usernames, doing something like:{results}{date}>“2022-04-13”


3 Replies 3

Welcome to the Airtable community!

If you are accessing the REST API, I recommend using the documentation at It is much more complete. To filter the results from the REST API, the value for filterByFormula needs to be a valid Airtable formula (url encoded). This works best if you build the formula first in an Airtable formula field. The query you include in your example does not look like a valid Airtable formula.

Also, the results that you show in your post do not look like the results of the public REST API for Airtable.

Thanks kuovonne.

About the query, I wrote it as an example, I am trying to get a valid one.

About the results, they are definitely what I get when I query Airtable, so maybe I am not doing the query right, my URL is: f"{AIRTABLE_BASE_ID}/{TABLE}" and I am doing a simple GET.

5 - Automation Enthusiast
5 - Automation Enthusiast

Could you provide an example of what the results of the public REST API look like?