getProfileQueryDataModelObjectAndCalculatedInsightWithSearchKey
GET {{baseUrl}}/ssot/profile/:dataModelName/:dataModelName/:id/calculated-insights/:ciName?batchSize=<integer>&dimensions=<string>&fields=<string>&filters=<string>&measures=<string>&offset=<integer>&orderby=<string>&searchKey=<string>&timeGranularity=<string>
Query a Profile data model object and a Calculated Insight object using filters and a search key in Data Cloud.
Available Version: 52.0
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
batchSize | string | Number of items to return. Values are from 1-4,999. If unspecified, the default value is 100. |
Available Version: 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.
Available Version: 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, Id__c is returned.
Available Version: 52.0
|
| filters | string | | Comma-separated list of equality expressions within square brackets, for example, [FirstName__c=DON].
Available Version: 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.
Available Version: 52.0
|
| offset | string | | Number of rows to skip before returning results. If unspecified, no rows are skipped.
Available Version: 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.
Available Version: 52.0
|
| searchKey | string | | If a field other than the primary key is used, name of the key field, for example, FirstName__c. Parameter is required for secondary key.
Available Version: 52.0
|
| timeGranularity | string | | Time range for the measures. Values are: HOUR, DAY, MONTH, QUARTER, or YEAR.
If unspecified, no time range is applied.
Available Version: 54.0 |
RESPONSES
status: OK
{"done":"\u003cboolean\u003e","endTime":"\u003cstring\u003e","metadata":{"//":"\u003cobject\u003e"},"queryId":"\u003cstring\u003e","rowCount":"\u003cinteger\u003e","startTime":"\u003cstring\u003e"}