Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Filter by linked table data

Topic Labels: API
11447 10
cancel
Showing results for 
Search instead for 
Did you mean: 
sull
6 - Interface Innovator
6 - Interface Innovator

I am trying to do a curl command where I filter results from a linked table that has multiple linked records… I have the record ID for the linked table record. Tried some encoded filterbyformula variations but get zero results.

linked field name is “sections”. I tried this most recently:

filterByFormula=FIND(%22rec0nTsg5N5p1i5Pv%22%2C+%7Bsections%7D)

Thanks for help.

10 Replies 10

I noticed that OR () does not work when there is more than one linked record.
It only returns data when there is only 1 record linked.
This leads me to think that the OR () comparison is taking into account an entire string of this field, as presented to the user, example: id1, id2, id3.
So, in this case, it will only return data if my search is exactly like this {field} = “id1, id2, id3” and this is neither practical nor functional.
Detail, I would not like to make 2 requests.
Any light?