[API] Formula filter for linked records not returning any results


#1

I have the base https://airtable.com/shrk4QtqMfI5yJdYr with two tables: Posts and Categories; The Posts table has one column which is a link to Categories and another which is a lookup on Categories.

The data is as follows:

{
    "records": [
        {
            "id": "rec0Wx3tdBsuBjHrV",
            "fields": {
                "Name": "Post 1",
                "Categories": [
                    "rec7PDGo7c2GP9wu2"
                ],
                "Category names": [
                    "Category 1"
                ]
            },
            "createdTime": "2018-11-22T20:24:15.000Z"
        },
        {
            "id": "rec334VYelorur9Ix",
            "fields": {
                "Name": "Post 3"
            },
            "createdTime": "2018-11-22T20:24:15.000Z"
        },
        {
            "id": "recIJhElGuUrFdvVn",
            "fields": {
                "Name": "Post 2",
                "Categories": [
                    "rec7PDGo7c2GP9wu2",
                    "reccMvdKsHB36MN3A"
                ],
                "Category names": [
                    "Category 1",
                    "Category 2"
                ]
            },
            "createdTime": "2018-11-22T20:24:15.000Z"
        }
    ]
}

The following request returns only record rec0Wx3tdBsuBjHrV (it should return rec0Wx3tdBsuBjHrV and recIJhElGuUrFdvVn since both have “Category 1”):

https://api.airtable.com/v0/appLEqjgwtfud3r86/Posts?filterByFormula={Category names}='Category 1'

And this request returns no results at all:

https://api.airtable.com/v0/appLEqjgwtfud3r86/Posts?filterByFormula={Categories}='rec0Wx3tdBsuBjHrV'

Although it clearly should return at least one.