The following are request and response examples for the most common Tableau Semantics Authoring Experience API calls.
Create Semantic Data Object with Fields
The following is an example of a request to create Semantic Data Objects with Fields.
<POST> /ssot/semantic/models/{{modelName}}/data-objects
{
"dataObjectName": "ssot__Account__dlm",
"dataObjectType": "DMO",
"description": null,
"label": "Name0601_do",
"semanticDimensions": [
{
"dataObjectFieldName": "ssot__Name__c",
"dataType": "Text",
"description": null,
"displayCategory": null,
"geoRole": null,
"isVisible": true,
"label": "name__c"
}
],
"semanticMeasurements": [
{
"aggregationType": null,
"dataObjectFieldName": "ssot__AnnualRevenueAmount__c",
"dataType": "Number",
"decimalPlace": null,
"description": null,
"directionality": null,
"displayCategory": null,
"isVisible": true,
"label": "age__c",
"shouldTreatNullsAsZeros": false,
"sortOrder": null
}
],
"shouldIncludeAllFields": false
}
The following is an example of a response to a create Semantic Data Objects with Fields request.
{
"apiName": "Name0601_do19",
"createdBy": "005SG000004gApdYAE",
"createdDate": "2024-02-11T14:52:41.000Z",
"dataObjectName": "ssot__Account__dlm",
"dataObjectType": "Dmo",
"description": null,
"filterLogic": null,
"filters": [],
"id": "4SMSG0000002E6v4AE",
"label": "Name0601_do",
"lastModifiedBy": "005SG000004gApdYAE",
"lastModifiedDate": "2024-02-11T14:52:41.000Z",
"logicalTableId": null,
"semanticDimensions": [
{
"apiName": "name_c",
"createdBy": "005SG000004gApdYAE",
"createdDate": "2024-02-11T14:52:42.000Z",
"dataObjectFieldName": "ssot__Name__c",
"dataType": "Text",
"description": null,
"displayCategory": null,
"geoRole": null,
"id": "18mSG0000000YhdYAE",
"isVisible": true,
"label": "name__c",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": null
}
],
"semanticDimensionsUrl": "/services/data/v61.0/ssot/semantic/models/model_28460923/data-objects/Name0601_do19/dimensions",
"semanticMeasurements": [
{
"aggregationType": "Sum",
"apiName": "age_c",
"createdBy": "005SG000004gApdYAE",
"createdDate": "2024-02-11T14:52:42.000Z",
"dataObjectFieldName": "ssot__AnnualRevenueAmount__c",
"dataType": "Number",
"decimalPlace": null,
"description": null,
"directionality": null,
"displayCategory": null,
"id": "18mSG0000000YheYAE",
"isAggregatable": true,
"isVisible": true,
"label": "age__c",
"lastModifiedBy": null,
"lastModifiedDate": null,
"shouldTreatNullsAsZeros": false,
"sortOrder": null
}
],
"semanticMeasurementsUrl": "/services/data/v61.0/ssot/semantic/models/model_28460923/data-objects/Name0601_do19/measurements",
"shouldIncludeAllFields": false
}
Create a Calculated Measurement
The following is an example of a request to create a Calculated Measurement:
<POST> /ssot/semantic/models/{{modelName}}/calculated-measurements
{
"label": "calcMeasurement",
"description": "calcl measurement",
"dataType": "NUMBER",
"decimalPlace": 3,
"expression": "(1 + 1) - 1",
"sortOrder": "Ascending",
"displayCategory": "DISCRETE",
"aggregationType": "SUM",
"directionality": "UP",
"shouldTreatNullsAsZeros": true,
"isVisible": true
}
The following is an example of a response to a create a Calculated Measurement request:
{
"aggregationType": "Sum",
"apiName": "calcMeasurement225",
"createdBy": "005SG000004gApdYAE",
"createdDate": "2024-02-11T14:54:38.000Z",
"dataType": "Number",
"decimalPlace": 3,
"description": "calcl measurement",
"directionality": "Up",
"displayCategory": "Discrete",
"expression": "(1 + 1) - 1",
"filterLogic": null,
"filters": [],
"id": "4SMSG0000002E8X4AU",
"isAggregatable": null,
"isVisible": true,
"label": "calcMeasurement",
"lastModifiedBy": "005SG000004gApdYAE",
"lastModifiedDate": "2024-02-11T14:54:38.000Z",
"shouldTreatNullsAsZeros": true,
"sortOrder": "Ascending",
"totalAggregationType": "Sum"
}
Create a Calculated Dimension
The following is an example of a request to create a Calculated Dimension
<POST> /ssot/semantic/models/{{modelName}}/calculated-dimensions
{
"label": "calcdim19",
"description": "this is first calcl dim",
"dataType": "Number",
"geoRole": "City",
"expression": "calcMeasurement225",
"sortOrder": "Ascending",
"displayCategory": "DISCRETE",
"isVisible": true
}
The following is an example of a response to a create a Calculated Dimension request:
{
"apiName": "calcdim1965",
"createdBy": "005SG000004gApdYAE",
"createdDate": "2024-02-11T15:04:00.000Z",
"dataType": "Number",
"description": "this is first calcl dim",
"displayCategory": "Discrete",
"expression": "calcMeasurement225",
"geoRole": "City",
"id": "4SMSG0000002ELR4A2",
"isVisible": true,
"label": "calcdim19",
"lastModifiedBy": "005SG000004gApdYAE",
"lastModifiedDate": "2024-02-11T15:04:00.000Z",
"sortOrder": "Ascending"
}
Create a full Semantic Model
The following is an example of a request to create a full Semantic Model with all its components:
<POST> /ssot/semantic/models
{
"apiName": "{{newModelName}}",
"label": "{{newModelName}}",
"description": "",
"app": "",
"categories": [],
"dataspace": "default",
"semanticDataObjects": [
{
"label": "Account",
"description": "",
"dataObjectName": "ssot__Account__dlm",
"dataObjectType": "Dmo",
"shouldIncludeAllFields": true,
"semanticDimensions": [
{
"dataObjectFieldName": "ssot__WebsiteAddr__c",
"label": "Website",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__Number__c",
"label": "Account Number",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__AccountTypeId__c",
"label": "Account Type",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__CreatedDate__c",
"label": "Created Date",
"description": "",
"dataType": "DateTime",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Continuous",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__Name__c",
"label": "Account Name",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__DataSourceObjectId__c",
"label": "Data Source Object",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__LastModifiedDate__c",
"label": "Last Modified Date",
"description": "",
"dataType": "DateTime",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Continuous",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__BillContactAddressId__c",
"label": "Bill Contact Address",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "KQ_Id__c",
"label": "Key Qualifier Account Id",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__AccountSource__c",
"label": "Account Source",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__Description__c",
"label": "Account Description",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__Id__c",
"label": "Account Id",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__DataSourceId__c",
"label": "Data Source",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
}
],
"semanticMeasurements": [
{
"dataObjectFieldName": "ssot__AnnualRevenueAmount__c",
"label": "Annual Revenue Amount",
"description": "",
"dataType": "Number",
"decimalPlace": 2,
"aggregationType": "None",
"sortOrder": "Ascending",
"displayCategory": "Continuous",
"directionality": "Up",
"isVisible": true,
"shouldTreatNullsAsZeros": false
}
]
},
{
"label": "Account Contact",
"description": "",
"dataObjectName": "ssot__AccountContact__dlm",
"dataObjectType": "Dmo",
"shouldIncludeAllFields": true,
"semanticDimensions": [
{
"dataObjectFieldName": "ssot__AssistantPhone__c",
"label": "Assistant Phone",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__Title__c",
"label": "Title",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__FirstName__c",
"label": "First Name",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__CreatedDate__c",
"label": "Created Date",
"description": "",
"dataType": "DateTime",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Continuous",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__MobilePhoneId__c",
"label": "Mobile Phone",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__DataSourceObjectId__c",
"label": "Data Source Object",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__BusinessPhoneId__c",
"label": "Business Phone",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "KQ_AccountId__c",
"label": "Key Qualifier Account",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__LastName__c",
"label": "Last Name",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__LastModifiedDate__c",
"label": "Last Modified Date",
"description": "",
"dataType": "DateTime",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Continuous",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__AccountId__c",
"label": "Account",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "KQ_Id__c",
"label": "Key Qualifier Account Contact Id",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__HomePhoneId__c",
"label": "Home Phone",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__DataSourceId__c",
"label": "Data Source",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__Id__c",
"label": "Account Contact Id",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
}
],
"semanticMeasurements": []
},
{
"label": "Lead",
"description": "",
"dataObjectName": "ssot__Lead__dlm",
"dataObjectType": "Dmo",
"shouldIncludeAllFields": true,
"semanticDimensions": [
{
"dataObjectFieldName": "ssot__LeadSourceId__c",
"label": "Lead Source",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__ConvertedDate__c",
"label": "Converted Date",
"description": "",
"dataType": "DateTime",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Continuous",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__DataSourceId__c",
"label": "Data Source",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__CreatedDate__c",
"label": "Created Date",
"description": "",
"dataType": "DateTime",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Continuous",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__Description__c",
"label": "Description",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__PhotoURL__c",
"label": "Photo URL",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__CountryId__c",
"label": "Country",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__Title__c",
"label": "Title",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "KQ_Id__c",
"label": "Key Qualifier Lead Id",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__City__c",
"label": "City",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__DataSourceObjectId__c",
"label": "Data Source Object",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__Website__c",
"label": "Website",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__Id__c",
"label": "Lead Id",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__IndustryId__c",
"label": "Industry",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__StateProvinceId__c",
"label": "State Province",
"description": "",
"dataType": "Text",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Discrete",
"isVisible": true
},
{
"dataObjectFieldName": "ssot__LastModifiedDate__c",
"label": "Last Modified Date",
"description": "",
"dataType": "DateTime",
"geoRole": "Country",
"sortOrder": "Ascending",
"displayCategory": "Continuous",
"isVisible": true
}
],
"semanticMeasurements": [
{
"dataObjectFieldName": "ssot__AnnualRevenue__c",
"label": "Annual Revenue",
"description": "",
"dataType": "Number",
"decimalPlace": 2,
"aggregationType": "None",
"sortOrder": "Ascending",
"displayCategory": "Continuous",
"directionality": "Up",
"isVisible": true,
"shouldTreatNullsAsZeros": false
}
]
}
],
"semanticRelationships": [],
"semanticCalculatedMeasurements": [],
"semanticCalculatedDimensions": [],
"semanticLogicalTables": []
}
The following is an example of a response to a create a Semantic Model request:
{
"apiName": "model_28455216",
"app": null,
"categories": [],
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:50.000Z",
"dataspace": "default",
"description": null,
"id": "2SMSG00000029on4AA",
"label": "model_28455216",
"lastModifiedBy": "005SG0000057HN8YAM",
"lastModifiedDate": "2024-02-07T13:36:50.000Z",
"semanticCalculatedDimensions": [],
"semanticCalculatedDimensionsUrl": "/services/data/v61.0/ssot/semantic/models/model_28455216/calculated-dimensions",
"semanticCalculatedMeasurements": [],
"semanticCalculatedMeasurementsUrl": "/services/data/v61.0/ssot/semantic/models/model_28455216/calculated-measurements",
"semanticDataObjects": [
{
"apiName": "Account61",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:50.000Z",
"dataObjectName": "ssot__Account__dlm",
"dataObjectType": "Dmo",
"description": null,
"filterLogic": null,
"filters": [],
"id": "4SMSG00000029oo4AA",
"label": "Account",
"lastModifiedBy": "005SG0000057HN8YAM",
"lastModifiedDate": "2024-02-07T13:36:50.000Z",
"logicalTableId": null,
"semanticDimensions": [
{
"apiName": "Account_Description10",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:51.000Z",
"dataObjectFieldName": "ssot__Description__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdHYAU",
"isVisible": true,
"label": "Account Description",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Account_Id11",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:52.000Z",
"dataObjectFieldName": "ssot__Id__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdIYAU",
"isVisible": true,
"label": "Account Id",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Account_Name9",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:51.000Z",
"dataObjectFieldName": "ssot__Name__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdBYAU",
"isVisible": true,
"label": "Account Name",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Account_Number10",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:50.000Z",
"dataObjectFieldName": "ssot__Number__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000Td8YAE",
"isVisible": true,
"label": "Account Number",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Account_Source10",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:51.000Z",
"dataObjectFieldName": "ssot__AccountSource__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdGYAU",
"isVisible": true,
"label": "Account Source",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Account_Type11",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:50.000Z",
"dataObjectFieldName": "ssot__AccountTypeId__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000Td9YAE",
"isVisible": true,
"label": "Account Type",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Bill_Contact_Address7",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:51.000Z",
"dataObjectFieldName": "ssot__BillContactAddressId__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdEYAU",
"isVisible": true,
"label": "Bill Contact Address",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Created_Date21",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:51.000Z",
"dataObjectFieldName": "ssot__CreatedDate__c",
"dataType": "DateTime",
"description": null,
"displayCategory": "Continuous",
"geoRole": "Country",
"id": "18mSG0000000TdAYAU",
"isVisible": true,
"label": "Created Date",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Data_Source22",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:52.000Z",
"dataObjectFieldName": "ssot__DataSourceId__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdJYAU",
"isVisible": true,
"label": "Data Source",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Data_Source_Object22",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:51.000Z",
"dataObjectFieldName": "ssot__DataSourceObjectId__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdCYAU",
"isVisible": true,
"label": "Data Source Object",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Key_Qualifier_Account_Id11",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:51.000Z",
"dataObjectFieldName": "KQ_Id__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdFYAU",
"isVisible": true,
"label": "Key Qualifier Account Id",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Last_Modified_Date21",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:51.000Z",
"dataObjectFieldName": "ssot__LastModifiedDate__c",
"dataType": "DateTime",
"description": null,
"displayCategory": "Continuous",
"geoRole": "Country",
"id": "18mSG0000000TdDYAU",
"isVisible": true,
"label": "Last Modified Date",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Website14",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:50.000Z",
"dataObjectFieldName": "ssot__WebsiteAddr__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000Td7YAE",
"isVisible": true,
"label": "Website",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
}
],
"semanticDimensionsUrl": "/services/data/v61.0/ssot/semantic/models/model_28455216/data-objects/Account61/dimensions",
"semanticMeasurements": [
{
"aggregationType": "None",
"apiName": "Annual_Revenue_Amount7",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:52.000Z",
"dataObjectFieldName": "ssot__AnnualRevenueAmount__c",
"dataType": "Number",
"decimalPlace": 2,
"description": null,
"directionality": "Up",
"displayCategory": "Continuous",
"id": "18mSG0000000TdKYAU",
"isAggregatable": true,
"isVisible": true,
"label": "Annual Revenue Amount",
"lastModifiedBy": null,
"lastModifiedDate": null,
"shouldTreatNullsAsZeros": false,
"sortOrder": "Ascending"
}
],
"semanticMeasurementsUrl": "/services/data/v61.0/ssot/semantic/models/model_28455216/data-objects/Account61/measurements",
"shouldIncludeAllFields": true
},
{
"apiName": "Account_Contact5",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:54.000Z",
"dataObjectName": "ssot__AccountContact__dlm",
"dataObjectType": "Dmo",
"description": null,
"filterLogic": null,
"filters": [],
"id": "4SMSG00000029or4AA",
"label": "Account Contact",
"lastModifiedBy": "005SG0000057HN8YAM",
"lastModifiedDate": "2024-02-07T13:36:54.000Z",
"logicalTableId": null,
"semanticDimensions": [
{
"apiName": "Account3",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:55.000Z",
"dataObjectFieldName": "ssot__AccountId__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdVYAU",
"isVisible": true,
"label": "Account",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Account_Contact_Id3",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:55.000Z",
"dataObjectFieldName": "ssot__Id__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdZYAU",
"isVisible": true,
"label": "Account Contact Id",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Assistant_Phone3",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:54.000Z",
"dataObjectFieldName": "ssot__AssistantPhone__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdLYAU",
"isVisible": true,
"label": "Assistant Phone",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Business_Phone3",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:55.000Z",
"dataObjectFieldName": "ssot__BusinessPhoneId__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdRYAU",
"isVisible": true,
"label": "Business Phone",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Created_Date22",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:54.000Z",
"dataObjectFieldName": "ssot__CreatedDate__c",
"dataType": "DateTime",
"description": null,
"displayCategory": "Continuous",
"geoRole": "Country",
"id": "18mSG0000000TdOYAU",
"isVisible": true,
"label": "Created Date",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Data_Source23",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:55.000Z",
"dataObjectFieldName": "ssot__DataSourceId__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdYYAU",
"isVisible": true,
"label": "Data Source",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Data_Source_Object23",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:54.000Z",
"dataObjectFieldName": "ssot__DataSourceObjectId__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdQYAU",
"isVisible": true,
"label": "Data Source Object",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "First_Name3",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:54.000Z",
"dataObjectFieldName": "ssot__FirstName__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdNYAU",
"isVisible": true,
"label": "First Name",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Home_Phone3",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:55.000Z",
"dataObjectFieldName": "ssot__HomePhoneId__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdXYAU",
"isVisible": true,
"label": "Home Phone",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Key_Qualifier_Account3",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:55.000Z",
"dataObjectFieldName": "KQ_AccountId__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdSYAU",
"isVisible": true,
"label": "Key Qualifier Account",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Key_Qualifier_Account_Contact_Id3",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:55.000Z",
"dataObjectFieldName": "KQ_Id__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdWYAU",
"isVisible": true,
"label": "Key Qualifier Account Contact Id",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Last_Modified_Date22",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:55.000Z",
"dataObjectFieldName": "ssot__LastModifiedDate__c",
"dataType": "DateTime",
"description": null,
"displayCategory": "Continuous",
"geoRole": "Country",
"id": "18mSG0000000TdUYAU",
"isVisible": true,
"label": "Last Modified Date",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Last_Name3",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:55.000Z",
"dataObjectFieldName": "ssot__LastName__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdTYAU",
"isVisible": true,
"label": "Last Name",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Mobile_Phone3",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:54.000Z",
"dataObjectFieldName": "ssot__MobilePhoneId__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdPYAU",
"isVisible": true,
"label": "Mobile Phone",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Title8",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:54.000Z",
"dataObjectFieldName": "ssot__Title__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdMYAU",
"isVisible": true,
"label": "Title",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
}
],
"semanticDimensionsUrl": "/services/data/v61.0/ssot/semantic/models/model_28455216/data-objects/Account_Contact5/dimensions",
"semanticMeasurements": [],
"semanticMeasurementsUrl": "/services/data/v61.0/ssot/semantic/models/model_28455216/data-objects/Account_Contact5/measurements",
"shouldIncludeAllFields": true
},
{
"apiName": "Lead5",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:57.000Z",
"dataObjectName": "ssot__Lead__dlm",
"dataObjectType": "Dmo",
"description": null,
"filterLogic": null,
"filters": [],
"id": "4SMSG00000029ou4AA",
"label": "Lead",
"lastModifiedBy": "005SG0000057HN8YAM",
"lastModifiedDate": "2024-02-07T13:36:57.000Z",
"logicalTableId": null,
"semanticDimensions": [
{
"apiName": "City4",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:58.000Z",
"dataObjectFieldName": "ssot__City__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdjYAE",
"isVisible": true,
"label": "City",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Converted_Date4",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:57.000Z",
"dataObjectFieldName": "ssot__ConvertedDate__c",
"dataType": "DateTime",
"description": null,
"displayCategory": "Continuous",
"geoRole": "Country",
"id": "18mSG0000000TdbYAE",
"isVisible": true,
"label": "Converted Date",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Country4",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:58.000Z",
"dataObjectFieldName": "ssot__CountryId__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdgYAE",
"isVisible": true,
"label": "Country",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Created_Date23",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:58.000Z",
"dataObjectFieldName": "ssot__CreatedDate__c",
"dataType": "DateTime",
"description": null,
"displayCategory": "Continuous",
"geoRole": "Country",
"id": "18mSG0000000TddYAE",
"isVisible": true,
"label": "Created Date",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Data_Source24",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:58.000Z",
"dataObjectFieldName": "ssot__DataSourceId__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdcYAE",
"isVisible": true,
"label": "Data Source",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Data_Source_Object24",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:58.000Z",
"dataObjectFieldName": "ssot__DataSourceObjectId__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdkYAE",
"isVisible": true,
"label": "Data Source Object",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Description7",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:58.000Z",
"dataObjectFieldName": "ssot__Description__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdeYAE",
"isVisible": true,
"label": "Description",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Industry4",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:59.000Z",
"dataObjectFieldName": "ssot__IndustryId__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdnYAE",
"isVisible": true,
"label": "Industry",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Key_Qualifier_Lead_Id4",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:58.000Z",
"dataObjectFieldName": "KQ_Id__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdiYAE",
"isVisible": true,
"label": "Key Qualifier Lead Id",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Last_Modified_Date23",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:59.000Z",
"dataObjectFieldName": "ssot__LastModifiedDate__c",
"dataType": "DateTime",
"description": null,
"displayCategory": "Continuous",
"geoRole": "Country",
"id": "18mSG0000000TdpYAE",
"isVisible": true,
"label": "Last Modified Date",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Lead_Id4",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:59.000Z",
"dataObjectFieldName": "ssot__Id__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdmYAE",
"isVisible": true,
"label": "Lead Id",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Lead_Source7",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:57.000Z",
"dataObjectFieldName": "ssot__LeadSourceId__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdaYAE",
"isVisible": true,
"label": "Lead Source",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Photo_URL4",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:58.000Z",
"dataObjectFieldName": "ssot__PhotoURL__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdfYAE",
"isVisible": true,
"label": "Photo URL",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "State_Province4",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:59.000Z",
"dataObjectFieldName": "ssot__StateProvinceId__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdoYAE",
"isVisible": true,
"label": "State Province",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Title9",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:58.000Z",
"dataObjectFieldName": "ssot__Title__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdhYAE",
"isVisible": true,
"label": "Title",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
},
{
"apiName": "Website15",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:59.000Z",
"dataObjectFieldName": "ssot__Website__c",
"dataType": "Text",
"description": null,
"displayCategory": "Discrete",
"geoRole": "Country",
"id": "18mSG0000000TdlYAE",
"isVisible": true,
"label": "Website",
"lastModifiedBy": null,
"lastModifiedDate": null,
"sortOrder": "Ascending"
}
],
"semanticDimensionsUrl": "/services/data/v61.0/ssot/semantic/models/model_28455216/data-objects/Lead5/dimensions",
"semanticMeasurements": [
{
"aggregationType": "None",
"apiName": "Annual_Revenue4",
"createdBy": "005SG0000057HN8YAM",
"createdDate": "2024-02-07T13:36:59.000Z",
"dataObjectFieldName": "ssot__AnnualRevenue__c",
"dataType": "Number",
"decimalPlace": 2,
"description": null,
"directionality": "Up",
"displayCategory": "Continuous",
"id": "18mSG0000000TdqYAE",
"isAggregatable": true,
"isVisible": true,
"label": "Annual Revenue",
"lastModifiedBy": null,
"lastModifiedDate": null,
"shouldTreatNullsAsZeros": false,
"sortOrder": "Ascending"
}
],
"semanticMeasurementsUrl": "/services/data/v61.0/ssot/semantic/models/model_28455216/data-objects/Lead5/measurements",
"shouldIncludeAllFields": true
}
],
"semanticDataObjectsUrl": "/services/data/v61.0/ssot/semantic/models/model_28455216/data-objects",
"semanticLogicalTables": [],
"semanticParameters": [],
"semanticParametersUrl": "/services/data/v61.0/ssot/semantic/models/model_28455216/parameters",
"semanticRelationships": [],
"semanticRelationshipsUrl": "/services/data/v61.0/ssot/semantic/models/model_28455216/relationships"
}
Create a full Semantic Model with CustomSql Logical View
The following is an example of a request to create a full Semantic Model with Custom SQL Logical View:
<POST> /ssot/semantic/models
{
"apiName": "{{newModelName}}",
"label": "{{newModelName}}",
"type": "Standard",
"dataspace": "default",
"semanticCalculatedMeasurements": [],
"semanticLogicalViews": [
{
"apiName": "{{newModelName}}",
"customSQLV2": "select \"ssot__Id__c\" as \"Id\" from \"ssot__Account__dlm\"",
"filters": [],
"label": "{{newModelName}}",
"semanticDataObjects": [
{
"dataObjectName": "Dummy",
"dataObjectType": "CustomSQL",
"label": "{{newModelName}}",
"semanticDimensions": [
{
"dataObjectFieldName": "Id",
"dataType": "Text",
"displayCategory": "Discrete",
"label": "Account Id",
"semanticDataType": "None"
}
],
"semanticMeasurements": [],
"shouldIncludeAllFields": false
}
],
"referenceIntegritySemanticDataObjects": [
{
"apiName": "{{newModelName}}",
"dataObjectName": "ssot__Account__dlm",
"dataObjectType": "Dmo",
"label": "Account",
"semanticDimensions": [
{
"apiName": "{{newModelName}}",
"dataObjectFieldName": "ssot__Id__c",
"dataType": "Text",
"displayCategory": "Discrete",
"label": "DataSourceId",
"semanticDataType": "None"
}
],
"semanticMeasurements": [],
"shouldIncludeAllFields": false
}
],
"semanticRelationships": [],
"semanticUnions": [],
"semanticViewTypeEnum": "CustomSQL"
}
],
"semanticDataObjects": []
}
The following is an example of a response to create a full Semantic Model request (with Custom SQL Logical View):
{
"agentEnabled":false,
"allowUnmapped":false,
"apiName":"model1223",
"categories":[
],
"createdBy":"005UA0000002xbuYAA",
"createdDate":"2026-04-12T10:28:58.000Z",
"currency":{
"useOrgDefault":true
},
"dataspace":"default",
"fieldsOverrides":[
],
"hasUnmapped":false,
"id":"2SMUA000000ds294AA",
"isAiDrafted":false,
"isPartialSdm":false,
"label":"model1223",
"lastModifiedBy":"005UA0000002xbuYAA",
"lastModifiedDate":"2026-04-12T10:28:58.000Z",
"lockedActions":{
},
"semanticCalculatedDimensions":[
],
"semanticCalculatedDimensionsUrl":"/services/data/v66.0/ssot/semantic/models/model1223/calculated-dimensions",
"semanticCalculatedMeasurements":[
],
"semanticCalculatedMeasurementsUrl":"/services/data/v66.0/ssot/semantic/models/model1223/calculated-measurements",
"semanticDataObjects":[
],
"semanticDataObjectsUrl":"/services/data/v66.0/ssot/semantic/models/model1223/data-objects",
"semanticDimensionHierarchies":[
],
"semanticGroupings":[
],
"semanticGroupingsUrl":"/services/data/v66.0/ssot/semantic/models/model1223/groupings",
"semanticLogicalViews":[
{
"apiName":"customSQL_lv_example",
"createdBy":"005UA0000002xbuYAA",
"createdDate":"2026-04-12T10:28:59.000Z",
"customSQLV2":"select "ssot__Id__c" as "Id" from "ssot__Account__dlm"",
"filters":[
],
"id":"1DOUA000000i0Yz4AI",
"isQueryable":"Queryable",
"label":"customSQL lv example",
"lastModifiedBy":"005UA0000002xbuYAA",
"lastModifiedDate":"2026-04-12T10:28:59.000Z",
"overriddenProperties":[
],
"referenceIntegritySemanticDataObjects":[
{
"apiName":"account11",
"createdBy":"005UA0000002xbuYAA",
"createdDate":"2026-04-12T10:28:59.000Z",
"customSqlIdentifier":"ssot__Account__dlm",
"dataObjectName":"ssot__Account__dlm",
"dataObjectType":"Dmo",
"filters":[
],
"id":"1DOUA000000i0Z14AI",
"isQueryable":"Queryable",
"label":"Account",
"lastModifiedBy":"005UA0000002xbuYAA",
"lastModifiedDate":"2026-04-12T10:28:59.000Z",
"logicalViewId":"1DOUA000000i0Yz4AI",
"overriddenProperties":[
],
"semanticDimensions":[
{
"apiName":"Id112",
"createdBy":"005UA0000002xbuYAA",
"createdDate":"2026-04-12T10:29:00.000Z",
"customSqlIdentifier":"ssot__Id__c",
"dataObjectFieldName":"ssot__Id__c",
"dataType":"Text",
"displayCategory":"Discrete",
"id":"18mUA000000WIBWYA4",
"isQueryable":"Queryable",
"isVisible":true,
"label":"DataSourceId",
"overriddenProperties":[
],
"semanticDataType":"None",
"storageDataType":"Text"
}
],
"semanticDimensionsUrl":"/services/data/v66.0/ssot/semantic/models/model1223/data-objects/account11/dimensions",
"semanticMeasurements":[
],
"semanticMeasurementsUrl":"/services/data/v66.0/ssot/semantic/models/model1223/data-objects/account11/measurements",
"shouldIncludeAllFields":false,
"tableType":"Standard"
}
],
"semanticDataObjects":[
{
"apiName":"Account3",
"createdBy":"005UA0000002xbuYAA",
"createdDate":"2026-04-12T10:28:59.000Z",
"dataObjectName":"Dummy",
"dataObjectType":"CustomSQL",
"filters":[
],
"id":"1DOUA000000i0Z04AI",
"isQueryable":"Queryable",
"label":"Account",
"lastModifiedBy":"005UA0000002xbuYAA",
"lastModifiedDate":"2026-04-12T10:28:59.000Z",
"logicalViewId":"1DOUA000000i0Yz4AI",
"overriddenProperties":[
],
"semanticDimensions":[
{
"apiName":"Account_Id",
"createdBy":"005UA0000002xbuYAA",
"createdDate":"2026-04-12T10:29:00.000Z",
"dataObjectFieldName":"Id",
"dataType":"Text",
"displayCategory":"Discrete",
"id":"18mUA000000WIBVYA4",
"isQueryable":"Queryable",
"isVisible":true,
"label":"Account Id",
"overriddenProperties":[
],
"semanticDataType":"None"
}
],
"semanticDimensionsUrl":"/services/data/v66.0/ssot/semantic/models/model1223/data-objects/Account3/dimensions",
"semanticMeasurements":[
],
"semanticMeasurementsUrl":"/services/data/v66.0/ssot/semantic/models/model1223/data-objects/Account3/measurements",
"shouldIncludeAllFields":false,
"tableType":"Standard"
}
],
"semanticRelationships":[
],
"semanticUnions":[
],
"semanticViewTypeEnum":"CustomSQL",
"tableType":"Standard"
}
],
"semanticMetrics":[
],
"semanticModelFilters":[
],
"semanticModelInfo":{
"definitionsCount":3,
"maxDefinitionCount":5000,
"modelHierarchyDepth":1
},
"semanticParameters":[
],
"semanticParametersUrl":"/services/data/v66.0/ssot/semantic/models/model1223/parameters",
"semanticRelationships":[
],
"semanticRelationshipsUrl":"/services/data/v66.0/ssot/semantic/models/model1223/relationships",
"sourceCreation":"Other"
}