Query Calculated Insights

The Calculated Insights API provides a powerful way to query and analyze data from Data 360 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.

Key Features 
  • 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

API Limits 
  • Maximum return limit: 4,999 rows per query
  • Pagination support via limit and offset parameters
  • Comprehensive error handling with detailed response codes

Metadata Endpoints 

Query Endpoints 
  • 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

Additional Resources 

Data 360 REST API Reference
Query Data in Data 360
Authenticate with the Data Cloud Rest API
Retrieve Metadata
Query Data Graph Data
Query Customer Profile Information with Profile API
Query Data using Query API
Query Unified Record ID
Query Calculated Insights
Get Calculated Insight Data
Get All Calculated Insights Metadata
Get Calculated Insight Metadata
Query Status Codes
Data 360 SQL Reference

DID THIS ARTICLE SOLVE YOUR ISSUE?
Let us know so we can improve!