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:
https://api.airtable.com/v0/myBase/myTable?filterByFormula={results}{date}>“2022-04-13”
Thanks!