How to search a JSON response after converting collection

[StephanieStrydom]

Hi, I get a JSON response via API - a list of names with their details. I convert this response to a collection, which are collections in the collection. Any ideas on how I can search for a name without looping through the whole collection?

------------------------------
Stephanie Strydom
------------------------------

[salman_shaik]

Hi Athiban,

As you suggested i tested it and it's working fine. Now i found that it's a case sensitive. Let's say in the response content we may have Matchday in any format (All letters are capital/All small letters/Only first letter capital/Some other format) we don't have any control on it. So can we add something in our query it should make case insensitive and matches only with the exact characters.

Response Content: MATCHDAY

InStr([Response Content],"Matchday")<> 0

Result:False

------------------------------
Salman Shaik
------------------------------

[Athiban_Mahamathi]

Hi Salman,

You can convert the input string to Lower or Upper and perform InStr operation. You can try as mentioned below.

InStr(Lower([Input]),"matchday") > 0

------------------------------
Athiban Mahamathi - https://www.linkedin.com/in/athiban-mahamathi-544a008b/
Technical Consultant,
SimplifyNext,
Singapore
------------------------------