Advanced Search

Request

POST /{api_name}

Parameters:

• skip;
• limit;
• minExtraKeys;
• positionType;
• maxTimestamp;
• minTimestamp;
• fullSchema, set to 1 to make the response return a full schema for each record
• aq: string, JSON search request.

aq should be a valid JSON object, with following sections:

• logic: logic to be placed between top level predicates. Can be either AND or OR;
• criterions: array of search conditions. Each criterion consists of:
  • column: API column to search (name should be retrieved from Columns description API). For injected data sets, value of this field should be combined from names of injected models and the column name itself, in order from the most top-level to the deepest, separated by ->;
  • logic: logic to be placed between predicates;
  • values: list of values and operators, represented as JSON object, with values themselves as keys and operators to apply as values.

Note that skip parameter only affects search queries with top-level logic operator AND. Those with OR will ignore skip parameter and will always treat it as 0.

Sample aq:

{ "aq": { "logic": "AND", "criterions": [ { "column": "ColumnA", "logic": "OR", "values": { "123": ">", "543": "<=", "1": "=" } }, { "column": "Inject1->Inject2->ColumnB", "logic": "AND", "values": { "ThisIsNotAValidHash": "!=", "8ab82": "*=*" } } ] } }