Retrieve Data

This operation returns aggregated data by executing an ad hoc query. The body of the request is a SQL-like query composed of SELECT, FROM, WHERE, and grouping and sorting clauses.

Example query

The following example query retrieves the first 100 tuples (a finite ordered list of elements) of full name, job, organization, and hire date for employees defined as Apprentice within a particular Hyperfind instance.

{
 "select": [
     { "key": "EMP_COMMON_FULL_NAME"},
     { "key": "EMP_COMMON_PRIMARY_JOB"},
     { "key": "EMP_COMMON_PRIMARY_ORG"},
     { "key": "PEOPLE_HIRE_DATE"}],
 "from": {
     "view": "EMP",
     "employeeSet": {
          "hyperfind": {
               "id": "1"
          },
          "dateRange": {
               "symbolicPeriod": {
                    "id": 5
               }
          }
     }
 },
 "where": [
     {
          "key": "EMP_COMMON_PRIMARY_JOB",
          "operator": "STARTS_WITH",
          "values": [
               "Apprentice"
          ]
     }
 ],
 "count": 100
}