Skip to main content

HEy All I’m trying to create a CURL API request that Searches for records that are {WEEK} = “24” AND{PAGE} contains “22”.


My PAGE field is a look up so it might have more than one page number in it.


If PAGE has one one record in it I can use


filterByFormula=AND(%7BWEEK%7D%3D%2224%22%2C%7BPAGE%7D%3D%2222%22)

I think I need to use SEARCH or FIND but I cant work out the syntax.


Thanks in aadvance

Just for future reference, mostly mine when I search for this again!!


AND({Week}="24",FIND("19",ARRAYJOIN({Shot Number})),FIND("22",ARRAYJOIN({PAGE})))

Reply