Skip to main content

API: Filter formula when you have a linked ID

  • March 20, 2023
  • 2 replies
  • 86 views

Forum|alt.badge.img+6

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?

 

 

 

2 replies

ramonscardua
Forum|alt.badge.img+5
  • New Participant
  • March 21, 2023

First query all items, so you can filter them:

query.records.filter

Forum|alt.badge.img+6
  • Author
  • Known Participant
  • March 21, 2023

First query all items, so you can filter them:

query.records.filter

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?