Retrieving a list type data view

Endpoint:POST /data_views/{data_view_ID}

The endpoint supports the following use cases:

Request schema:

Getting data with pagination:

Getting data without pagination:

• maxResultsToFetch refers to maximum results to fetch when the data is not paginated. The default and maximum value is 5000.
• A request that includes both maxResultsToFetch and pageNumber/pageSize generates a validation error.
• query is optional. If you do not specify it, the parameter is executed as a regular data view.
• dataViewParameters is optional if the data view doesn't have mandatory parameters.

Query elements:

• select:

  

  

• sortBy:

  

  

  • Optional. If you do not specify the element, the query retrieves default data.
  • The default values are sortType: ASC and sortOrder: order of fields.
  • Sorting works for individual fields and aggregated values that are specified in aggregations.
  • If you do not specify a value for aggregations, the fields that you specify in sortBy are added to select and the query fetches the data for those fields.
  • If you specify a value for aggregations, only that value and the fields in select are used for sorting.
• paging:

  

  

  

  

  • Optional. If you do not specify it, the query applies the value of maxResultsToFetch.
  • If pageSize is greater than 5000, the system runs a validation check.
  • The default values are pageNumber: 1 and pageSize: 100.
  • You can specify either maxResultsToFetch or pageNumber/pageSize.
• filter:

  

  

  • In lhs, you can specify any relevant scalar field.
  • In rhs, you can specify the following elements:
    • field – property reference
    • value – string literal
    • values – list of values
  • The following operations are supported:
    • boolean: IS_TRUE, IS_FALSE, IS_NULL, IS_NOT_NULL, EQ, NEQ.
    • string: EQ, NEQ, IN, NOT_IN, IS_NULL, IS_NOT_NULL, STARTS_WITH, NOT_STARTS_WITH, ENDS_WITH, NOT_ENDS_WITH, CONTAINS, NOT_CONTAINS.
    • number, date: EQ, NEQ, IN, NOT_IN, GT, GTE, LT, LTE, ISNULL, ISNOTNULL.
  • All comparators are case-sensitive.
  • To apply filtering that is not case-sensitive to text-based fields, set ignoreCase to true.
  • Date and time fields should follow the RFC-3339 standard.
  • Specifying rhs as any of the following comparators is incorrect and the call ignores it:
    • IS_TRUE
    • IS_FALSE
    • IS_NULL
    • IS_NOT_NULL
  • The IN and NOT_IN comparators identify a list of values (they apply to values).
  • logic supports the AND and OR comparators. The default value is AND.

    The expression supports parentheses, for example: (F1 AND F2) OR (F3 AND F4).

Response schema:

• The response returns the values of pageNumber and pageSize if they are included in paging.
• For queryable data views without pagination or non-queryable data views, the response includes resultCount and hasMoreResults (only for data views sourced by report definitions, if more results exist).
• The response ignores fields specified in the report definition that sources the data view.
• The filters specified in the query are applied in addition to the existing filters in the report definition.

Request schema:

• maxResultsToFetch is optional. The default and maximum value is 5000.
• dataViewParameters is optional if the data view doesn't have mandatory parameters.
• select, sortBy, and filter are optional.
• If you specify only aggregations but not select, the call returns all aggregated data without grouping.

Query elements:

aggregations:

• The following operations are supported: COUNT, MAX, MIN, DISTINCT_COUNT. For number data types, also: SUM, AVG.
• summaryFunction names are case-sensitive in the query.
• AverageAge is a unique name for the aggregation which the response returns with the aggregated value.
• To aggregate data, you specify the list of fields and a function for the summary.
• Filtering is not supported on aggregation fields.

Response schema:

Request schema:

Query element:

distinctResultsOnly:

• Set to “true” to return distinct set of results only.
• Cannot be specified with aggregation.
• You can specify either maxResultsToFetch or pageNumber/pageSize.

Request schema:

• Only list-type data views are supported.
• The request retrieves the data from a specific data view.
• The request includes only data view parameters.
• Data queries and pagination are not supported.

Response schema:

hasMoreResults returns a value only if the data view is sourced by a report definition.

Retrieving the count of total results for a specified criteria

Endpoint:POST /data_views/{data_view_ID}/count

Request schema:

distinctResultsOnly and filter are optional.

Response schema:

• The maximum value for resultCount is 5000 for queryable data views.
• hasMoreResults returns value only if the data view is sourced by a report definition.

Retrieving data view metadata which includes data view parameters and list of queryable fields

Endpoint:GET /data_views/{data_view_ID}/metadata

The endpoint supports both queryable and non-queryable data views.

Response schema:

• source returns additional metadata that is related to the data source. For example, local-type picklist fields, prompt lists, source data views, field values, and user reference fields.
• The response returns a HATEOAS link for data view/field value picklists and user reference fields. The link references the /data_views/{data_view_ID} endpoint.

Retrieving a list of data objects

Endpoint:GET /data_objects

The available values for the type query parameter are case and data.

Response schema:

• Without the query parameter, the response returns all data objects. If you specify the parameter, the response returns only data objects that are related to data types or case types. However, for case types, the response returns dataObjectID as empty.
• The response returns a HATEOAS link for the default data view metadata.

Data model

The following table categorizes query elements in the Pega-API-DataExploration class:

The following diagram illustrates the data model (the highlighted elements are inherited):