Search Results

After executing a SearchRequest, the API returns a structured response that includes:

The SQL statement used ( search_SQL_Statement )
Column-to-index mappings ( fieldMapping )
The result data rows ( results )

Response Structure

SQL Statement

Shows the SQL generated by your search request for transparency and debugging.

Field Mapping

Maps column names to their index positions in the results array.

Results

Each row in results corresponds to a single record, with values ordered according to the fieldMapping.

Example Response

Copy

Copied

{
  "search_SQL_Statement": "SELECT ...",
  "fieldMapping": [
    { "tableName": "Members", "columnName": "First_Name", "columnIndex": 0 }
  ],
  "results": [
    ["Jane"],
    ["John"]
  ]
}

This structure enables efficient parsing and presentation of results on the front end while supporting a wide variety of dynamic queries.