updateCalculatedInsight

PATCH {{baseUrl}}/ssot/calculated-insights/:apiName

Update a calculated insight in Data Cloud.

Available Version: 57.0

Root XML tag: <cdpCalculatedInsightInput>

Request Body

{"displayName"=>"dev1__demo_draft_ci_6__cio", "apiName"=>"dev1__demo_draft_ci_6__cio", "definitionType"=>"CalculatedMetric", "expression"=>"SELECT count(ssot__Individual__dlm.ssot__DataSourceId__c) as dev1__m1__c, ssot__Individual__dlm.ssot__Id__c as dev1__d1__c FROM ssot__Individual__dlm WHERE ssot__Individual__dlm.ssot__InternalOrganizationId__c= 'test name' GROUP BY dev1__d1__c", "draft"=>true, "createdFromPackage"=>false, "dataSpaceName"=>"", "description"=>"", "packagedCalculatedInsightApiName"=>""}

HEADERS

KeyDatatypeRequiredDescription
Content-Typestring

RESPONSES

status: OK

{&quot;apiName&quot;:&quot;\u003cstring\u003e&quot;,&quot;calculatedInsightStatus&quot;:&quot;\u003cstring\u003e&quot;,&quot;creationType&quot;:&quot;\u003cstring\u003e&quot;,&quot;dataSpace&quot;:&quot;\u003cstring\u003e&quot;,&quot;definitionStatus&quot;:&quot;\u003cstring\u003e&quot;,&quot;definitionType&quot;:&quot;\u003cstring\u003e&quot;,&quot;description&quot;:&quot;\u003cstring\u003e&quot;,&quot;dimensions&quot;:[{&quot;apiName&quot;:&quot;\u003cstring\u003e&quot;,&quot;creationType&quot;:&quot;\u003cstring\u003e&quot;,&quot;dataSource&quot;:{&quot;sourceApiName&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;},&quot;dataType&quot;:&quot;\u003cstring\u003e&quot;,&quot;dateGranularity&quot;:&quot;\u003cstring\u003e&quot;,&quot;displayName&quot;:&quot;\u003cstring\u003e&quot;,&quot;fieldRole&quot;:&quot;\u003cstring\u003e&quot;,&quot;formula&quot;:&quot;\u003cstring\u003e&quot;},{&quot;apiName&quot;:&quot;\u003cstring\u003e&quot;,&quot;creationType&quot;:&quot;\u003cstring\u003e&quot;,&quot;dataSource&quot;:{&quot;sourceApiName&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;},&quot;dataType&quot;:&quot;\u003cstring\u003e&quot;,&quot;dateGranularity&quot;:&quot;\u003cstring\u003e&quot;,&quot;displayName&quot;:&quot;\u003cstring\u003e&quot;,&quot;fieldRole&quot;:&quot;\u003cstring\u003e&quot;,&quot;formula&quot;:&quot;\u003cstring\u003e&quot;}],&quot;displayName&quot;:&quot;\u003cstring\u003e&quot;,&quot;expression&quot;:&quot;\u003cstring\u003e&quot;,&quot;isEnabled&quot;:&quot;\u003cboolean\u003e&quot;,&quot;lastCalcInsightStatusDateTime&quot;:&quot;\u003cstring\u003e&quot;,&quot;lastCalcInsightStatusErrorCode&quot;:&quot;\u003cstring\u003e&quot;,&quot;lastRunDateTime&quot;:&quot;\u003cstring\u003e&quot;,&quot;lastRunStatus&quot;:&quot;\u003cstring\u003e&quot;,&quot;lastRunStatusDateTime&quot;:&quot;\u003cstring\u003e&quot;,&quot;lastRunStatusErrorCode&quot;:&quot;\u003cstring\u003e&quot;,&quot;measures&quot;:[{&quot;apiName&quot;:&quot;\u003cstring\u003e&quot;,&quot;creationType&quot;:&quot;\u003cstring\u003e&quot;,&quot;dataSource&quot;:{&quot;sourceApiName&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;},&quot;dataType&quot;:&quot;\u003cstring\u003e&quot;,&quot;displayName&quot;:&quot;\u003cstring\u003e&quot;,&quot;fieldAggregationType&quot;:&quot;\u003cstring\u003e&quot;,&quot;fieldRole&quot;:&quot;\u003cstring\u003e&quot;,&quot;formula&quot;:&quot;\u003cstring\u003e&quot;},{&quot;apiName&quot;:&quot;\u003cstring\u003e&quot;,&quot;creationType&quot;:&quot;\u003cstring\u003e&quot;,&quot;dataSource&quot;:{&quot;sourceApiName&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;},&quot;dataType&quot;:&quot;\u003cstring\u003e&quot;,&quot;displayName&quot;:&quot;\u003cstring\u003e&quot;,&quot;fieldAggregationType&quot;:&quot;\u003cstring\u003e&quot;,&quot;fieldRole&quot;:&quot;\u003cstring\u003e&quot;,&quot;formula&quot;:&quot;\u003cstring\u003e&quot;}]}