API: Filter formula when you have a linked ID

[Jed_Davidow]

I have a table I need to search through and pull records from.

That table has a column that is linked to another table.  I have that link ID.  It's set to a single link (not multiple items).

Here's the item from a list that I have retrieved.  I have the Travelers.id:

{
  "id":"recj6XBlCeO4Dk19z",
  "createdTime":"2023-03-15T02:04:52.000Z",
  "fields":{
    "stepName":"Start",
    "stepNum":1,
    "ID":"StandardBuild_1",
    "Travelers.id":["recswe1cU6X4b4XVY"],
    "travelers.PN":["FRM-0000REV01"],
    "Travelers.name":["StandardBuild"]
  }
}

So I want to filter the result by the Travelers.id, but I cannot figure out how to format it.

I tried to create a new column that used ARRAYJOIN to format that ID array into a string... but that actually formats the Traveler.name and not the item ID.

Any ideas?

[ramonscardua]

First query all items, so you can filter them:

query.records.filter

[Jed_Davidow]

I'm sorry, I don't understand what query.records.filter is.

I'm looking to use the filterByFormula to have the server filter the records for me.

What is this query records formula?