REST API - Search Field

[khopper]

I have been reviewing the REST API Documentation (https://www.espocrm.com/documentation/development/api/) to try and search a custom Entity "MDB" by field "BTN"

I can't figure this out:

• where - (array) filters;

Basically what I want to do is search entity MDB field BTN for XXXXX and return result if exist.

http://localhost/espocrm/api/v1/MDB?where=btn=9545556666

[khopper]

Found answer here: https://forum.espocrm.com/forum/deve...-filter-in-api

http://localhost/api/v1/entitynamehere?where[0][type]=equals&where[0][field]=fieldnamehere&where[0][value]=valuehere

Documentation could use some TLC. I would have never guessed the above is what I needed to do for a simple query.

[WMEspo]

This is definitely helpful, but does anyone know how to add multiple searches in one query?

[wulthur]

For searching multiple values I use
http://localhost/api/v1/entitynamehere?where[0][type]=like&where[0][field]=fieldnamehere&where[0][value]=%value1%value2%

It seems that the keyword for [type] is 'like' or 'textFilter'

Sadly it works only in the correct order. Gladly it seems to work case-insensitive.

For instance, if you have an account with name Doe, John you will get only a result if you use

http://localhost/api/v1/Account?where[0][type]=like&where[0][field]=name&where[0][value]=%doe%john%
http://localhost/api/v1/Account?where[0][type]=textFilter&where[0][field]=name&where[0][value]=%DO%joH%

But if you try
http://localhost/api/v1/Account?where[0][type]=like&where[0][field]=name&where[0][value]=%john%doe%
you will get no results.

[oscarbm92]

As it says in the documentation the where clause is an array so for multiple values i do:

http://localhost/api/v1/Account?where[0][type]=like&where[0][field]=name&where[0][value]=%doe%john%&where[1][type]=equals&where[1][field]=field&where[1][value]=value

So simplified in JSON it would be something like::

"where": [
   {
      "type": "like",
      "field": "name",
      "value": "%doe%john%"
   },
   {
      "type": "equals",
      "field": "field",
      "value": "value"
   }
]

So, same string changing the array index... 1, 2, N...

[oscarbm92]

Also if you want more complex conditions you can see:

https://github.com/espocrm/documentation/blob/master/docs/development/api-search-params.md

And:

https://forum.espocrm.com/forum/developer-help/57309-api-rest-where-condition-using-or

This can give you some clues that can help you implementing what you want