Newer Version Available

This content describes an older version of this product. View Latest

Salesforce CDP Profile Query, Data Model Object and Calculated Insight Object with Search Key

Query a Salesforce CDP Profile data model object and a Calculated Insight object using filters and a search key.
Resource
1/ssot/profile/dataModelName/id/calculated-insights/calculatedInsightName
The id parameter is the value of the primary or secondary key field.
Available version
52.0
Requires Chatter
No
HTTP methods
GET
Request parameters for GET
Parameter Name Type Description Required or Optional Available Version
batchSize Integer Number of items to return. Values are from 1–4,999. If unspecified, the default value is 100. Optional 52.0
dimensions String Comma-separated list of up to 10 dimensions, such as GenderId__c, to project. If unspecified, this parameter includes all of the available dimensions. Optional 52.0
fields String Comma-separated list of up to 50 field names that you want to include in the result, for example, Id__c,FirstName__c,​GenderId__c,Occupation__c. If unspecified, an arbitrary set of fields is returned. Optional 52.0
filters String Comma-separated list of equality expressions within square brackets, for example, [FirstName__c=DON]. Optional 52.0
measures String Comma-separated list of up to 5 measures, such as TotalSales__c, to project. If unspecified, this parameter includes all of the available measures. Optional 52.0
offset Integer Number of rows to skip before returning results. If unspecified, no rows are skipped. Optional 52.0
orderby String Sort order for the result set, such as GenderId__c ASC,​Occupation__c DESC. If unspecified, items are returned in the order they are retrieved. Optional 52.0
searchKey String If a field other than the primary key is used, name of the key field, for example, FirstName__c. Required for secondary key 52.0
timeGranularity String Time range for the measures. Values are:
  • HOUR
  • DAY
  • MONTH
  • QUARTER
  • YEAR
If unspecified, no time range is applied.
Optional 54.0
Response body for GET
Salesforce CDP Query Output