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.

Service limit

A service limit constrains the number of employees, the number of days, and the number of employees multiplied by the number of days that can be processed in a single request.

• The Number of Employees cannot exceed 500.

• The Number of Days cannot exceed 365.

• The Number of Employees multiplied by the Number of Days cannot exceed 10,000.

Refer to the Limits topic for more information.

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
}