Indexing and full text search

Search Service

Store and search JSON records. The Search API provides indexing and full text search. Search for a word or phrase in a particular field of a record. Combine multiple with either AND or OR boolean operators to create complex queries.

Query Language

The search API supports a simple query language to let you get to your data quickly without having to learn a complicated language.

The most basic query looks like this

key == 'value'

where you specify a key and a value to find. For example you might want to look for every customer with first name of John

first_name == 'John'

String values support single or double quotes.

Values can also be numbers

age == 37

or booleans

verified == true

You can search on fields that are nested in the record using dot (.) as a separator

address.city == 'London'

The API also supports wildcard * matching to enable scenarios like autocomplete.

first_name == 'Joh*'

In addition to equality == the API support greater than or equals >= and less than or equals <= operators

age >= 37
age <= 37

Simple queries can be combined with logical and

first_name == "John" AND age <= 37

or logical or

first_name == "John" OR first_name == "Jane"

If combining and and or operations you will need to use parentheses to explicitly define precedence

(first_name == "John" OR first_name == "Jane") AND age <= 37