Query Calculated Insights

The Calculated Insights API provides a powerful way to query and analyze data from Data Cloud Calculated Insights objects. This API allows you to retrieve metadata about available insights and query the insights with selected SQL dimensions and measures, including optional filters and time-based aggregations.

  • Metadata Access: Retrieve information about available calculated insights, including dimensions, measures, and relationships
  • Flexible Querying: Query insights with customizable dimensions, measures, and filters
  • Pagination Support: Handle large datasets with limit and offset parameters
  • Time-based Analysis: Aggregate data by different time granularities (HOUR, DAY, MONTH, QUARTER, YEAR)
  • Sorting Capabilities: Order results using multiple fields in ascending or descending order
  • Maximum return limit: 4,999 rows per query
  • Pagination support via limit and offset parameters
  • Comprehensive error handling with detailed response codes
  • GET /api/v1/insight/calculated-insights/{ci-name}
    • Query a specific calculated insight with customizable parameters
    • Supports filtering, sorting, pagination, and time-based aggregation
    • Returns actual data values based on specified dimensions and measures