Help

Searching for a string value within an column with array of strings

Topic Labels: API
7015 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jason_Burke
4 - Data Explorer
4 - Data Explorer

I have a table with a column which can 0 or more string values. I’m trying to search for all records that contain a certain string value in its that column

I’m using the following in my request URL but never getting any records (this value does exist within the array of values in some of the rows)

filterByFormula=SEARCH("rec6CS1RqOjcYLwXf", ARRAYJOIN(Industries))

Am I doing something wrong?

1 Reply 1

Hi @Jason_Burke - I think the problem here is that you are literally searching for the string “rec6CS1RqOjcYLwXf” in the ARRAYJOIN value, but, I assume, you want to search for a field value associated with record “rec6CS1RqOjcYLwXf”.

(I’m also assuming that your ARRAYJOIN is something like this:

Screenshot 2020-05-13 at 14.55.43
)

To make it work your formula should read something like:

filterByFormula=SEARCH("Retail", ARRAYJOIN(Industries))

or if the search term is dynamic, then do something like:

let searchTerm = [Get the dynamic value here from a record, table, etc]
filterByFormula=SEARCH(searchTerm, ARRAYJOIN(Industries))

JB