GET /api/v1/insight/calculated-insights/(ci-name)
Use this API to query the calculated insights. Users can slice, dice, and filter by
selecting different dimensions, measures and filters.
Syntax
- HTTP method
- GET
- Availability
- Salesforce CDP v1.0, Salesforce v51.0
- Formats
- REST
- URI
- /api/v1/insights/calculated-insight/(ci-name)
Request Parameters
| Field Name | Field Type | Description |
|---|---|---|
| ci_name | string | Required. The Calculated Insight name. |
| dimensions | string | Comma separated list of dimensions to be projected. By default, this parameter includes all of the available dimensions. Example: GenderId__c |
| measures | string | Comma separated list of measures to be projected. By default, this parameter includes all of the available measures. Example: TotalSales__c |
| limit | int | The number of items to return. By default, the maximum number, 4999 items are returned. Example: 1000 |
| offset | int | Number of rows to skip before starting to return. Example: 100 |
| filters | string | This parameter is added to a select query to select results of only a specific type. Example: [GenderId__c=Male,FirstName__c=Angel] |
| orderby | string | Comman seperated values to sort the result-set in ascending or descending order. Example: GenderId__c ASC,Occupation__c DESC |
Examples
- Request
-
1http://{TSE}.360a.salesforce.com/api/v1/insights/calculated-insights/{ci-name} - Response
-
1{ 2 "data": [ 3 { 4 "GenderId__c": "F", 5 "Id__c": "05d01a06-0c61-3990-808d-2aa602dd3e7f", 6 "Occupation__c": "Staffing", 7 "FirstName__c": "Don" 8 }, 9 { 10 "GenderId__c": "M", 11 "Id__c": "11bcc846-1a80-3293-8cc4-3449835d8d4c", 12 "Occupation__c": "Operational", 13 "FirstName__c": "Don" 14 }, 15 { 16 "GenderId__c": "M", 17 "Id__c": "18213566-df86-34a8-97aa-2cb75b70ae3b", 18 "Occupation__c": "Organizational", 19 "FirstName__c": "Don" 20 } 21 ] 22}
HTTP Responses
| Response | Reason |
|---|---|
| 200 OK | Callback successfully verified |
| 400 Bad Request | Invalid request |
| 403 Forbidden | Failed to pass authorization. |
| 404 Not Found | Incorrect callback ID, verification key, or both. |
| 422 Unprocessable Entity | Attribute name used in fields/filter parameter does not exist. |
| 500 Server Error | Internal error |