Queries a specific calculated insight in your Data 360 instance. This endpoint allows you to retrieve data with customizable dimensions, measures, filters, and time-based aggregations.
/api/v1/insight/calculated-insights/{ci-name}| Parameter | Type | Description |
|---|---|---|
| ci-name | string | Required. The unique identifier of the calculated insight. Example: Avg_Spends__cio |
| Parameter | Type | Description |
|---|---|---|
| dimensions | string | Comma-separated list of dimensions to include in the response. Default: all available dimensions. Example: GenderId__c,FirstName__c |
| measures | string | Comma-separated list of measures to include in the response. Default: all available measures. Example: TotalSales__c,AvgSpend__c |
| limit | integer | Maximum number of rows to return. Default: 4,999. Example: 1000 |
| offset | integer | Number of rows to skip before returning results. Example: 100 |
| filters | string | Filter criteria in the format [field=value]. Example: [GenderId__c=Male,FirstName__c=John] |
| orderby | string | Comma-separated list of fields to sort by, with optional direction (ASC/DESC). Example: GenderId__c ASC,Occupation__c DESC |
| timeGranularity | string | Time-based aggregation level. Available in API v53.0+. Values: HOUR, DAY, MONTH, QUARTER, YEAR |
The response includes:
data: Array of objects containing the requested dimensions and measuresdone: Boolean indicating if all results have been returned1GET https://{TSE}.360a.salesforce.com/api/v1/insights/calculated-insights/Avg_Spends__cio?dimensions=Id__c,FirstName__c&measures=Avg_Spend__c&limit=31{
2 "data": [
3 {
4 "Id__c": "05d01a06-0c61-3990-808d-2aa602dd3e7f",
5 "FirstName__c": "Don",
6 "Avg_Spend__c": 1335.15
7 },
8 {
9 "Id__c": "11bcc846-1a80-3293-8cc4-3449835d8d4c",
10 "FirstName__c": "Wensei",
11 "Avg_Spend__c": 942.67
12 },
13 {
14 "Id__c": "18213566-df86-34a8-97aa-2cb75b70ae3b",
15 "FirstName__c": "Ryan",
16 "Avg_Spend__c": 2886.5
17 }
18 ],
19 "done": true
20}
j