REST API Search "IN" clause

Nuraly Zhanbyrbayev · 2021-10-04T11:42:45+00:00

There was an error rendering this rich post.

Hello,

I want to search a keyword among ~500 documents (the list of the documents is dynamic).

I would like to know the syntax for API query looks like:

I have next query, but apparently it is not functional:

Content-Type: application/x-www-form-urlencoded

OTCSTICKET: TOKEN

where=hazardous [QLREGION "OTName"] in ("STN-00-Z30-E-SP-0019", "STN-00-Z32-I-SP-0006")

&limit=10

&extra=false

&select={"id"}

Please help with IN clause.

Find more posts tagged with

Hi Greg,

Thanks a lot for the link.

I tried the following syntax for REST API search POST request and it seems to work:

Content-Type: application/x-www-form-urlencoded

OTCSTICKET: token

where= my keyword (OTName:(name1|name2|name3|...|name500))

&limit=10000

&extra=false

&select={"id"}