Request and Response Examples
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
1{
2 "dataObjectName": "ssot__Account__dlm",
3 "dataObjectType": "DMO",
4 "description": null,
5 "label": "Name0601_do",
6 "semanticDimensions": [
7 {
8 "dataObjectFieldName": "ssot__Name__c",
9 "dataType": "Text",
10 "description": null,
11 "displayCategory": null,
12 "geoRole": null,
13 "isVisible": true,
14 "label": "name__c"
15 }
16 ],
17 "semanticMeasurements": [
18 {
19 "aggregationType": null,
20 "dataObjectFieldName": "ssot__AnnualRevenueAmount__c",
21 "dataType": "Number",
22 "decimalPlace": null,
23 "description": null,
24 "directionality": null,
25 "displayCategory": null,
26 "isVisible": true,
27 "label": "age__c",
28 "shouldTreatNullsAsZeros": false,
29 "sortOrder": null
30 }
31 ],
32 "shouldIncludeAllFields": false
33 }The following is an example of a response to a create Semantic Data Objects with Fields request.
1{
2 "apiName": "Name0601_do19",
3 "createdBy": "005SG000004gApdYAE",
4 "createdDate": "2024-02-11T14:52:41.000Z",
5 "dataObjectName": "ssot__Account__dlm",
6 "dataObjectType": "Dmo",
7 "description": null,
8 "filterLogic": null,
9 "filters": [],
10 "id": "4SMSG0000002E6v4AE",
11 "label": "Name0601_do",
12 "lastModifiedBy": "005SG000004gApdYAE",
13 "lastModifiedDate": "2024-02-11T14:52:41.000Z",
14 "logicalTableId": null,
15 "semanticDimensions": [
16 {
17 "apiName": "name_c",
18 "createdBy": "005SG000004gApdYAE",
19 "createdDate": "2024-02-11T14:52:42.000Z",
20 "dataObjectFieldName": "ssot__Name__c",
21 "dataType": "Text",
22 "description": null,
23 "displayCategory": null,
24 "geoRole": null,
25 "id": "18mSG0000000YhdYAE",
26 "isVisible": true,
27 "label": "name__c",
28 "lastModifiedBy": null,
29 "lastModifiedDate": null,
30 "sortOrder": null
31 }
32 ],
33 "semanticDimensionsUrl": "/services/data/v61.0/ssot/semantic/models/model_28460923/data-objects/Name0601_do19/dimensions",
34 "semanticMeasurements": [
35 {
36 "aggregationType": "Sum",
37 "apiName": "age_c",
38 "createdBy": "005SG000004gApdYAE",
39 "createdDate": "2024-02-11T14:52:42.000Z",
40 "dataObjectFieldName": "ssot__AnnualRevenueAmount__c",
41 "dataType": "Number",
42 "decimalPlace": null,
43 "description": null,
44 "directionality": null,
45 "displayCategory": null,
46 "id": "18mSG0000000YheYAE",
47 "isAggregatable": true,
48 "isVisible": true,
49 "label": "age__c",
50 "lastModifiedBy": null,
51 "lastModifiedDate": null,
52 "shouldTreatNullsAsZeros": false,
53 "sortOrder": null
54 }
55 ],
56 "semanticMeasurementsUrl": "/services/data/v61.0/ssot/semantic/models/model_28460923/data-objects/Name0601_do19/measurements",
57 "shouldIncludeAllFields": false
58}Create a Calculated Measurement
The following is an example of a request to create a Calculated Measurement:
<POST> /ssot/semantic/models/{{modelName}}/calculated-measurements
1{
2 "label": "calcMeasurement",
3 "description": "calcl measurement",
4 "dataType": "NUMBER",
5 "decimalPlace": 3,
6 "expression": "(1 + 1) - 1",
7 "sortOrder": "Ascending",
8 "displayCategory": "DISCRETE",
9 "aggregationType": "SUM",
10 "directionality": "UP",
11 "shouldTreatNullsAsZeros": true,
12 "isVisible": true
13}The following is an example of a response to a create a Calculated Measurement request:
1{
2 "aggregationType": "Sum",
3 "apiName": "calcMeasurement225",
4 "createdBy": "005SG000004gApdYAE",
5 "createdDate": "2024-02-11T14:54:38.000Z",
6 "dataType": "Number",
7 "decimalPlace": 3,
8 "description": "calcl measurement",
9 "directionality": "Up",
10 "displayCategory": "Discrete",
11 "expression": "(1 + 1) - 1",
12 "filterLogic": null,
13 "filters": [],
14 "id": "4SMSG0000002E8X4AU",
15 "isAggregatable": null,
16 "isVisible": true,
17 "label": "calcMeasurement",
18 "lastModifiedBy": "005SG000004gApdYAE",
19 "lastModifiedDate": "2024-02-11T14:54:38.000Z",
20 "shouldTreatNullsAsZeros": true,
21 "sortOrder": "Ascending",
22 "totalAggregationType": "Sum"
23}Create a Calculated Dimension
The following is an example of a request to create a Calculated Dimension
<POST> /ssot/semantic/models/{{modelName}}/calculated-dimensions
1{
2 "label": "calcdim19",
3 "description": "this is first calcl dim",
4 "dataType": "Number",
5 "geoRole": "City",
6 "expression": "calcMeasurement225",
7 "sortOrder": "Ascending",
8 "displayCategory": "DISCRETE",
9 "isVisible": true
10}The following is an example of a response to a create a Calculated Dimension request:
1{
2 "apiName": "calcdim1965",
3 "createdBy": "005SG000004gApdYAE",
4 "createdDate": "2024-02-11T15:04:00.000Z",
5 "dataType": "Number",
6 "description": "this is first calcl dim",
7 "displayCategory": "Discrete",
8 "expression": "calcMeasurement225",
9 "geoRole": "City",
10 "id": "4SMSG0000002ELR4A2",
11 "isVisible": true,
12 "label": "calcdim19",
13 "lastModifiedBy": "005SG000004gApdYAE",
14 "lastModifiedDate": "2024-02-11T15:04:00.000Z",
15 "sortOrder": "Ascending"
16}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
1{
2 "apiName": "{{newModelName}}",
3 "label": "{{newModelName}}",
4 "description": "",
5 "app": "",
6 "categories": [],
7 "dataspace": "default",
8 "semanticDataObjects": [
9 {
10 "label": "Account",
11 "description": "",
12 "dataObjectName": "ssot__Account__dlm",
13 "dataObjectType": "Dmo",
14 "shouldIncludeAllFields": true,
15 "semanticDimensions": [
16 {
17 "dataObjectFieldName": "ssot__WebsiteAddr__c",
18 "label": "Website",
19 "description": "",
20 "dataType": "Text",
21 "geoRole": "Country",
22 "sortOrder": "Ascending",
23 "displayCategory": "Discrete",
24 "isVisible": true
25 },
26 {
27 "dataObjectFieldName": "ssot__Number__c",
28 "label": "Account Number",
29 "description": "",
30 "dataType": "Text",
31 "geoRole": "Country",
32 "sortOrder": "Ascending",
33 "displayCategory": "Discrete",
34 "isVisible": true
35 },
36 {
37 "dataObjectFieldName": "ssot__AccountTypeId__c",
38 "label": "Account Type",
39 "description": "",
40 "dataType": "Text",
41 "geoRole": "Country",
42 "sortOrder": "Ascending",
43 "displayCategory": "Discrete",
44 "isVisible": true
45 },
46 {
47 "dataObjectFieldName": "ssot__CreatedDate__c",
48 "label": "Created Date",
49 "description": "",
50 "dataType": "DateTime",
51 "geoRole": "Country",
52 "sortOrder": "Ascending",
53 "displayCategory": "Continuous",
54 "isVisible": true
55 },
56 {
57 "dataObjectFieldName": "ssot__Name__c",
58 "label": "Account Name",
59 "description": "",
60 "dataType": "Text",
61 "geoRole": "Country",
62 "sortOrder": "Ascending",
63 "displayCategory": "Discrete",
64 "isVisible": true
65 },
66 {
67 "dataObjectFieldName": "ssot__DataSourceObjectId__c",
68 "label": "Data Source Object",
69 "description": "",
70 "dataType": "Text",
71 "geoRole": "Country",
72 "sortOrder": "Ascending",
73 "displayCategory": "Discrete",
74 "isVisible": true
75 },
76 {
77 "dataObjectFieldName": "ssot__LastModifiedDate__c",
78 "label": "Last Modified Date",
79 "description": "",
80 "dataType": "DateTime",
81 "geoRole": "Country",
82 "sortOrder": "Ascending",
83 "displayCategory": "Continuous",
84 "isVisible": true
85 },
86 {
87 "dataObjectFieldName": "ssot__BillContactAddressId__c",
88 "label": "Bill Contact Address",
89 "description": "",
90 "dataType": "Text",
91 "geoRole": "Country",
92 "sortOrder": "Ascending",
93 "displayCategory": "Discrete",
94 "isVisible": true
95 },
96 {
97 "dataObjectFieldName": "KQ_Id__c",
98 "label": "Key Qualifier Account Id",
99 "description": "",
100 "dataType": "Text",
101 "geoRole": "Country",
102 "sortOrder": "Ascending",
103 "displayCategory": "Discrete",
104 "isVisible": true
105 },
106 {
107 "dataObjectFieldName": "ssot__AccountSource__c",
108 "label": "Account Source",
109 "description": "",
110 "dataType": "Text",
111 "geoRole": "Country",
112 "sortOrder": "Ascending",
113 "displayCategory": "Discrete",
114 "isVisible": true
115 },
116 {
117 "dataObjectFieldName": "ssot__Description__c",
118 "label": "Account Description",
119 "description": "",
120 "dataType": "Text",
121 "geoRole": "Country",
122 "sortOrder": "Ascending",
123 "displayCategory": "Discrete",
124 "isVisible": true
125 },
126 {
127 "dataObjectFieldName": "ssot__Id__c",
128 "label": "Account Id",
129 "description": "",
130 "dataType": "Text",
131 "geoRole": "Country",
132 "sortOrder": "Ascending",
133 "displayCategory": "Discrete",
134 "isVisible": true
135 },
136 {
137 "dataObjectFieldName": "ssot__DataSourceId__c",
138 "label": "Data Source",
139 "description": "",
140 "dataType": "Text",
141 "geoRole": "Country",
142 "sortOrder": "Ascending",
143 "displayCategory": "Discrete",
144 "isVisible": true
145 }
146 ],
147 "semanticMeasurements": [
148 {
149 "dataObjectFieldName": "ssot__AnnualRevenueAmount__c",
150 "label": "Annual Revenue Amount",
151 "description": "",
152 "dataType": "Number",
153 "decimalPlace": 2,
154 "aggregationType": "None",
155 "sortOrder": "Ascending",
156 "displayCategory": "Continuous",
157 "directionality": "Up",
158 "isVisible": true,
159 "shouldTreatNullsAsZeros": false
160 }
161 ]
162 },
163 {
164 "label": "Account Contact",
165 "description": "",
166 "dataObjectName": "ssot__AccountContact__dlm",
167 "dataObjectType": "Dmo",
168 "shouldIncludeAllFields": true,
169 "semanticDimensions": [
170 {
171 "dataObjectFieldName": "ssot__AssistantPhone__c",
172 "label": "Assistant Phone",
173 "description": "",
174 "dataType": "Text",
175 "geoRole": "Country",
176 "sortOrder": "Ascending",
177 "displayCategory": "Discrete",
178 "isVisible": true
179 },
180 {
181 "dataObjectFieldName": "ssot__Title__c",
182 "label": "Title",
183 "description": "",
184 "dataType": "Text",
185 "geoRole": "Country",
186 "sortOrder": "Ascending",
187 "displayCategory": "Discrete",
188 "isVisible": true
189 },
190 {
191 "dataObjectFieldName": "ssot__FirstName__c",
192 "label": "First Name",
193 "description": "",
194 "dataType": "Text",
195 "geoRole": "Country",
196 "sortOrder": "Ascending",
197 "displayCategory": "Discrete",
198 "isVisible": true
199 },
200 {
201 "dataObjectFieldName": "ssot__CreatedDate__c",
202 "label": "Created Date",
203 "description": "",
204 "dataType": "DateTime",
205 "geoRole": "Country",
206 "sortOrder": "Ascending",
207 "displayCategory": "Continuous",
208 "isVisible": true
209 },
210 {
211 "dataObjectFieldName": "ssot__MobilePhoneId__c",
212 "label": "Mobile Phone",
213 "description": "",
214 "dataType": "Text",
215 "geoRole": "Country",
216 "sortOrder": "Ascending",
217 "displayCategory": "Discrete",
218 "isVisible": true
219 },
220 {
221 "dataObjectFieldName": "ssot__DataSourceObjectId__c",
222 "label": "Data Source Object",
223 "description": "",
224 "dataType": "Text",
225 "geoRole": "Country",
226 "sortOrder": "Ascending",
227 "displayCategory": "Discrete",
228 "isVisible": true
229 },
230 {
231 "dataObjectFieldName": "ssot__BusinessPhoneId__c",
232 "label": "Business Phone",
233 "description": "",
234 "dataType": "Text",
235 "geoRole": "Country",
236 "sortOrder": "Ascending",
237 "displayCategory": "Discrete",
238 "isVisible": true
239 },
240 {
241 "dataObjectFieldName": "KQ_AccountId__c",
242 "label": "Key Qualifier Account",
243 "description": "",
244 "dataType": "Text",
245 "geoRole": "Country",
246 "sortOrder": "Ascending",
247 "displayCategory": "Discrete",
248 "isVisible": true
249 },
250 {
251 "dataObjectFieldName": "ssot__LastName__c",
252 "label": "Last Name",
253 "description": "",
254 "dataType": "Text",
255 "geoRole": "Country",
256 "sortOrder": "Ascending",
257 "displayCategory": "Discrete",
258 "isVisible": true
259 },
260 {
261 "dataObjectFieldName": "ssot__LastModifiedDate__c",
262 "label": "Last Modified Date",
263 "description": "",
264 "dataType": "DateTime",
265 "geoRole": "Country",
266 "sortOrder": "Ascending",
267 "displayCategory": "Continuous",
268 "isVisible": true
269 },
270 {
271 "dataObjectFieldName": "ssot__AccountId__c",
272 "label": "Account",
273 "description": "",
274 "dataType": "Text",
275 "geoRole": "Country",
276 "sortOrder": "Ascending",
277 "displayCategory": "Discrete",
278 "isVisible": true
279 },
280 {
281 "dataObjectFieldName": "KQ_Id__c",
282 "label": "Key Qualifier Account Contact Id",
283 "description": "",
284 "dataType": "Text",
285 "geoRole": "Country",
286 "sortOrder": "Ascending",
287 "displayCategory": "Discrete",
288 "isVisible": true
289 },
290 {
291 "dataObjectFieldName": "ssot__HomePhoneId__c",
292 "label": "Home Phone",
293 "description": "",
294 "dataType": "Text",
295 "geoRole": "Country",
296 "sortOrder": "Ascending",
297 "displayCategory": "Discrete",
298 "isVisible": true
299 },
300 {
301 "dataObjectFieldName": "ssot__DataSourceId__c",
302 "label": "Data Source",
303 "description": "",
304 "dataType": "Text",
305 "geoRole": "Country",
306 "sortOrder": "Ascending",
307 "displayCategory": "Discrete",
308 "isVisible": true
309 },
310 {
311 "dataObjectFieldName": "ssot__Id__c",
312 "label": "Account Contact Id",
313 "description": "",
314 "dataType": "Text",
315 "geoRole": "Country",
316 "sortOrder": "Ascending",
317 "displayCategory": "Discrete",
318 "isVisible": true
319 }
320 ],
321 "semanticMeasurements": []
322 },
323 {
324 "label": "Lead",
325 "description": "",
326 "dataObjectName": "ssot__Lead__dlm",
327 "dataObjectType": "Dmo",
328 "shouldIncludeAllFields": true,
329 "semanticDimensions": [
330 {
331 "dataObjectFieldName": "ssot__LeadSourceId__c",
332 "label": "Lead Source",
333 "description": "",
334 "dataType": "Text",
335 "geoRole": "Country",
336 "sortOrder": "Ascending",
337 "displayCategory": "Discrete",
338 "isVisible": true
339 },
340 {
341 "dataObjectFieldName": "ssot__ConvertedDate__c",
342 "label": "Converted Date",
343 "description": "",
344 "dataType": "DateTime",
345 "geoRole": "Country",
346 "sortOrder": "Ascending",
347 "displayCategory": "Continuous",
348 "isVisible": true
349 },
350 {
351 "dataObjectFieldName": "ssot__DataSourceId__c",
352 "label": "Data Source",
353 "description": "",
354 "dataType": "Text",
355 "geoRole": "Country",
356 "sortOrder": "Ascending",
357 "displayCategory": "Discrete",
358 "isVisible": true
359 },
360 {
361 "dataObjectFieldName": "ssot__CreatedDate__c",
362 "label": "Created Date",
363 "description": "",
364 "dataType": "DateTime",
365 "geoRole": "Country",
366 "sortOrder": "Ascending",
367 "displayCategory": "Continuous",
368 "isVisible": true
369 },
370 {
371 "dataObjectFieldName": "ssot__Description__c",
372 "label": "Description",
373 "description": "",
374 "dataType": "Text",
375 "geoRole": "Country",
376 "sortOrder": "Ascending",
377 "displayCategory": "Discrete",
378 "isVisible": true
379 },
380 {
381 "dataObjectFieldName": "ssot__PhotoURL__c",
382 "label": "Photo URL",
383 "description": "",
384 "dataType": "Text",
385 "geoRole": "Country",
386 "sortOrder": "Ascending",
387 "displayCategory": "Discrete",
388 "isVisible": true
389 },
390 {
391 "dataObjectFieldName": "ssot__CountryId__c",
392 "label": "Country",
393 "description": "",
394 "dataType": "Text",
395 "geoRole": "Country",
396 "sortOrder": "Ascending",
397 "displayCategory": "Discrete",
398 "isVisible": true
399 },
400 {
401 "dataObjectFieldName": "ssot__Title__c",
402 "label": "Title",
403 "description": "",
404 "dataType": "Text",
405 "geoRole": "Country",
406 "sortOrder": "Ascending",
407 "displayCategory": "Discrete",
408 "isVisible": true
409 },
410 {
411 "dataObjectFieldName": "KQ_Id__c",
412 "label": "Key Qualifier Lead Id",
413 "description": "",
414 "dataType": "Text",
415 "geoRole": "Country",
416 "sortOrder": "Ascending",
417 "displayCategory": "Discrete",
418 "isVisible": true
419 },
420 {
421 "dataObjectFieldName": "ssot__City__c",
422 "label": "City",
423 "description": "",
424 "dataType": "Text",
425 "geoRole": "Country",
426 "sortOrder": "Ascending",
427 "displayCategory": "Discrete",
428 "isVisible": true
429 },
430 {
431 "dataObjectFieldName": "ssot__DataSourceObjectId__c",
432 "label": "Data Source Object",
433 "description": "",
434 "dataType": "Text",
435 "geoRole": "Country",
436 "sortOrder": "Ascending",
437 "displayCategory": "Discrete",
438 "isVisible": true
439 },
440 {
441 "dataObjectFieldName": "ssot__Website__c",
442 "label": "Website",
443 "description": "",
444 "dataType": "Text",
445 "geoRole": "Country",
446 "sortOrder": "Ascending",
447 "displayCategory": "Discrete",
448 "isVisible": true
449 },
450 {
451 "dataObjectFieldName": "ssot__Id__c",
452 "label": "Lead Id",
453 "description": "",
454 "dataType": "Text",
455 "geoRole": "Country",
456 "sortOrder": "Ascending",
457 "displayCategory": "Discrete",
458 "isVisible": true
459 },
460 {
461 "dataObjectFieldName": "ssot__IndustryId__c",
462 "label": "Industry",
463 "description": "",
464 "dataType": "Text",
465 "geoRole": "Country",
466 "sortOrder": "Ascending",
467 "displayCategory": "Discrete",
468 "isVisible": true
469 },
470 {
471 "dataObjectFieldName": "ssot__StateProvinceId__c",
472 "label": "State Province",
473 "description": "",
474 "dataType": "Text",
475 "geoRole": "Country",
476 "sortOrder": "Ascending",
477 "displayCategory": "Discrete",
478 "isVisible": true
479 },
480 {
481 "dataObjectFieldName": "ssot__LastModifiedDate__c",
482 "label": "Last Modified Date",
483 "description": "",
484 "dataType": "DateTime",
485 "geoRole": "Country",
486 "sortOrder": "Ascending",
487 "displayCategory": "Continuous",
488 "isVisible": true
489 }
490 ],
491 "semanticMeasurements": [
492 {
493 "dataObjectFieldName": "ssot__AnnualRevenue__c",
494 "label": "Annual Revenue",
495 "description": "",
496 "dataType": "Number",
497 "decimalPlace": 2,
498 "aggregationType": "None",
499 "sortOrder": "Ascending",
500 "displayCategory": "Continuous",
501 "directionality": "Up",
502 "isVisible": true,
503 "shouldTreatNullsAsZeros": false
504 }
505 ]
506 }
507 ],
508 "semanticRelationships": [],
509 "semanticCalculatedMeasurements": [],
510 "semanticCalculatedDimensions": [],
511 "semanticLogicalTables": []
512}The following is an example of a response to a create a Semantic Model request:
1{
2 "apiName": "model_28455216",
3 "app": null,
4 "categories": [],
5 "createdBy": "005SG0000057HN8YAM",
6 "createdDate": "2024-02-07T13:36:50.000Z",
7 "dataspace": "default",
8 "description": null,
9 "id": "2SMSG00000029on4AA",
10 "label": "model_28455216",
11 "lastModifiedBy": "005SG0000057HN8YAM",
12 "lastModifiedDate": "2024-02-07T13:36:50.000Z",
13 "semanticCalculatedDimensions": [],
14 "semanticCalculatedDimensionsUrl": "/services/data/v61.0/ssot/semantic/models/model_28455216/calculated-dimensions",
15 "semanticCalculatedMeasurements": [],
16 "semanticCalculatedMeasurementsUrl": "/services/data/v61.0/ssot/semantic/models/model_28455216/calculated-measurements",
17 "semanticDataObjects": [
18 {
19 "apiName": "Account61",
20 "createdBy": "005SG0000057HN8YAM",
21 "createdDate": "2024-02-07T13:36:50.000Z",
22 "dataObjectName": "ssot__Account__dlm",
23 "dataObjectType": "Dmo",
24 "description": null,
25 "filterLogic": null,
26 "filters": [],
27 "id": "4SMSG00000029oo4AA",
28 "label": "Account",
29 "lastModifiedBy": "005SG0000057HN8YAM",
30 "lastModifiedDate": "2024-02-07T13:36:50.000Z",
31 "logicalTableId": null,
32 "semanticDimensions": [
33 {
34 "apiName": "Account_Description10",
35 "createdBy": "005SG0000057HN8YAM",
36 "createdDate": "2024-02-07T13:36:51.000Z",
37 "dataObjectFieldName": "ssot__Description__c",
38 "dataType": "Text",
39 "description": null,
40 "displayCategory": "Discrete",
41 "geoRole": "Country",
42 "id": "18mSG0000000TdHYAU",
43 "isVisible": true,
44 "label": "Account Description",
45 "lastModifiedBy": null,
46 "lastModifiedDate": null,
47 "sortOrder": "Ascending"
48 },
49 {
50 "apiName": "Account_Id11",
51 "createdBy": "005SG0000057HN8YAM",
52 "createdDate": "2024-02-07T13:36:52.000Z",
53 "dataObjectFieldName": "ssot__Id__c",
54 "dataType": "Text",
55 "description": null,
56 "displayCategory": "Discrete",
57 "geoRole": "Country",
58 "id": "18mSG0000000TdIYAU",
59 "isVisible": true,
60 "label": "Account Id",
61 "lastModifiedBy": null,
62 "lastModifiedDate": null,
63 "sortOrder": "Ascending"
64 },
65 {
66 "apiName": "Account_Name9",
67 "createdBy": "005SG0000057HN8YAM",
68 "createdDate": "2024-02-07T13:36:51.000Z",
69 "dataObjectFieldName": "ssot__Name__c",
70 "dataType": "Text",
71 "description": null,
72 "displayCategory": "Discrete",
73 "geoRole": "Country",
74 "id": "18mSG0000000TdBYAU",
75 "isVisible": true,
76 "label": "Account Name",
77 "lastModifiedBy": null,
78 "lastModifiedDate": null,
79 "sortOrder": "Ascending"
80 },
81 {
82 "apiName": "Account_Number10",
83 "createdBy": "005SG0000057HN8YAM",
84 "createdDate": "2024-02-07T13:36:50.000Z",
85 "dataObjectFieldName": "ssot__Number__c",
86 "dataType": "Text",
87 "description": null,
88 "displayCategory": "Discrete",
89 "geoRole": "Country",
90 "id": "18mSG0000000Td8YAE",
91 "isVisible": true,
92 "label": "Account Number",
93 "lastModifiedBy": null,
94 "lastModifiedDate": null,
95 "sortOrder": "Ascending"
96 },
97 {
98 "apiName": "Account_Source10",
99 "createdBy": "005SG0000057HN8YAM",
100 "createdDate": "2024-02-07T13:36:51.000Z",
101 "dataObjectFieldName": "ssot__AccountSource__c",
102 "dataType": "Text",
103 "description": null,
104 "displayCategory": "Discrete",
105 "geoRole": "Country",
106 "id": "18mSG0000000TdGYAU",
107 "isVisible": true,
108 "label": "Account Source",
109 "lastModifiedBy": null,
110 "lastModifiedDate": null,
111 "sortOrder": "Ascending"
112 },
113 {
114 "apiName": "Account_Type11",
115 "createdBy": "005SG0000057HN8YAM",
116 "createdDate": "2024-02-07T13:36:50.000Z",
117 "dataObjectFieldName": "ssot__AccountTypeId__c",
118 "dataType": "Text",
119 "description": null,
120 "displayCategory": "Discrete",
121 "geoRole": "Country",
122 "id": "18mSG0000000Td9YAE",
123 "isVisible": true,
124 "label": "Account Type",
125 "lastModifiedBy": null,
126 "lastModifiedDate": null,
127 "sortOrder": "Ascending"
128 },
129 {
130 "apiName": "Bill_Contact_Address7",
131 "createdBy": "005SG0000057HN8YAM",
132 "createdDate": "2024-02-07T13:36:51.000Z",
133 "dataObjectFieldName": "ssot__BillContactAddressId__c",
134 "dataType": "Text",
135 "description": null,
136 "displayCategory": "Discrete",
137 "geoRole": "Country",
138 "id": "18mSG0000000TdEYAU",
139 "isVisible": true,
140 "label": "Bill Contact Address",
141 "lastModifiedBy": null,
142 "lastModifiedDate": null,
143 "sortOrder": "Ascending"
144 },
145 {
146 "apiName": "Created_Date21",
147 "createdBy": "005SG0000057HN8YAM",
148 "createdDate": "2024-02-07T13:36:51.000Z",
149 "dataObjectFieldName": "ssot__CreatedDate__c",
150 "dataType": "DateTime",
151 "description": null,
152 "displayCategory": "Continuous",
153 "geoRole": "Country",
154 "id": "18mSG0000000TdAYAU",
155 "isVisible": true,
156 "label": "Created Date",
157 "lastModifiedBy": null,
158 "lastModifiedDate": null,
159 "sortOrder": "Ascending"
160 },
161 {
162 "apiName": "Data_Source22",
163 "createdBy": "005SG0000057HN8YAM",
164 "createdDate": "2024-02-07T13:36:52.000Z",
165 "dataObjectFieldName": "ssot__DataSourceId__c",
166 "dataType": "Text",
167 "description": null,
168 "displayCategory": "Discrete",
169 "geoRole": "Country",
170 "id": "18mSG0000000TdJYAU",
171 "isVisible": true,
172 "label": "Data Source",
173 "lastModifiedBy": null,
174 "lastModifiedDate": null,
175 "sortOrder": "Ascending"
176 },
177 {
178 "apiName": "Data_Source_Object22",
179 "createdBy": "005SG0000057HN8YAM",
180 "createdDate": "2024-02-07T13:36:51.000Z",
181 "dataObjectFieldName": "ssot__DataSourceObjectId__c",
182 "dataType": "Text",
183 "description": null,
184 "displayCategory": "Discrete",
185 "geoRole": "Country",
186 "id": "18mSG0000000TdCYAU",
187 "isVisible": true,
188 "label": "Data Source Object",
189 "lastModifiedBy": null,
190 "lastModifiedDate": null,
191 "sortOrder": "Ascending"
192 },
193 {
194 "apiName": "Key_Qualifier_Account_Id11",
195 "createdBy": "005SG0000057HN8YAM",
196 "createdDate": "2024-02-07T13:36:51.000Z",
197 "dataObjectFieldName": "KQ_Id__c",
198 "dataType": "Text",
199 "description": null,
200 "displayCategory": "Discrete",
201 "geoRole": "Country",
202 "id": "18mSG0000000TdFYAU",
203 "isVisible": true,
204 "label": "Key Qualifier Account Id",
205 "lastModifiedBy": null,
206 "lastModifiedDate": null,
207 "sortOrder": "Ascending"
208 },
209 {
210 "apiName": "Last_Modified_Date21",
211 "createdBy": "005SG0000057HN8YAM",
212 "createdDate": "2024-02-07T13:36:51.000Z",
213 "dataObjectFieldName": "ssot__LastModifiedDate__c",
214 "dataType": "DateTime",
215 "description": null,
216 "displayCategory": "Continuous",
217 "geoRole": "Country",
218 "id": "18mSG0000000TdDYAU",
219 "isVisible": true,
220 "label": "Last Modified Date",
221 "lastModifiedBy": null,
222 "lastModifiedDate": null,
223 "sortOrder": "Ascending"
224 },
225 {
226 "apiName": "Website14",
227 "createdBy": "005SG0000057HN8YAM",
228 "createdDate": "2024-02-07T13:36:50.000Z",
229 "dataObjectFieldName": "ssot__WebsiteAddr__c",
230 "dataType": "Text",
231 "description": null,
232 "displayCategory": "Discrete",
233 "geoRole": "Country",
234 "id": "18mSG0000000Td7YAE",
235 "isVisible": true,
236 "label": "Website",
237 "lastModifiedBy": null,
238 "lastModifiedDate": null,
239 "sortOrder": "Ascending"
240 }
241 ],
242 "semanticDimensionsUrl": "/services/data/v61.0/ssot/semantic/models/model_28455216/data-objects/Account61/dimensions",
243 "semanticMeasurements": [
244 {
245 "aggregationType": "None",
246 "apiName": "Annual_Revenue_Amount7",
247 "createdBy": "005SG0000057HN8YAM",
248 "createdDate": "2024-02-07T13:36:52.000Z",
249 "dataObjectFieldName": "ssot__AnnualRevenueAmount__c",
250 "dataType": "Number",
251 "decimalPlace": 2,
252 "description": null,
253 "directionality": "Up",
254 "displayCategory": "Continuous",
255 "id": "18mSG0000000TdKYAU",
256 "isAggregatable": true,
257 "isVisible": true,
258 "label": "Annual Revenue Amount",
259 "lastModifiedBy": null,
260 "lastModifiedDate": null,
261 "shouldTreatNullsAsZeros": false,
262 "sortOrder": "Ascending"
263 }
264 ],
265 "semanticMeasurementsUrl": "/services/data/v61.0/ssot/semantic/models/model_28455216/data-objects/Account61/measurements",
266 "shouldIncludeAllFields": true
267 },
268 {
269 "apiName": "Account_Contact5",
270 "createdBy": "005SG0000057HN8YAM",
271 "createdDate": "2024-02-07T13:36:54.000Z",
272 "dataObjectName": "ssot__AccountContact__dlm",
273 "dataObjectType": "Dmo",
274 "description": null,
275 "filterLogic": null,
276 "filters": [],
277 "id": "4SMSG00000029or4AA",
278 "label": "Account Contact",
279 "lastModifiedBy": "005SG0000057HN8YAM",
280 "lastModifiedDate": "2024-02-07T13:36:54.000Z",
281 "logicalTableId": null,
282 "semanticDimensions": [
283 {
284 "apiName": "Account3",
285 "createdBy": "005SG0000057HN8YAM",
286 "createdDate": "2024-02-07T13:36:55.000Z",
287 "dataObjectFieldName": "ssot__AccountId__c",
288 "dataType": "Text",
289 "description": null,
290 "displayCategory": "Discrete",
291 "geoRole": "Country",
292 "id": "18mSG0000000TdVYAU",
293 "isVisible": true,
294 "label": "Account",
295 "lastModifiedBy": null,
296 "lastModifiedDate": null,
297 "sortOrder": "Ascending"
298 },
299 {
300 "apiName": "Account_Contact_Id3",
301 "createdBy": "005SG0000057HN8YAM",
302 "createdDate": "2024-02-07T13:36:55.000Z",
303 "dataObjectFieldName": "ssot__Id__c",
304 "dataType": "Text",
305 "description": null,
306 "displayCategory": "Discrete",
307 "geoRole": "Country",
308 "id": "18mSG0000000TdZYAU",
309 "isVisible": true,
310 "label": "Account Contact Id",
311 "lastModifiedBy": null,
312 "lastModifiedDate": null,
313 "sortOrder": "Ascending"
314 },
315 {
316 "apiName": "Assistant_Phone3",
317 "createdBy": "005SG0000057HN8YAM",
318 "createdDate": "2024-02-07T13:36:54.000Z",
319 "dataObjectFieldName": "ssot__AssistantPhone__c",
320 "dataType": "Text",
321 "description": null,
322 "displayCategory": "Discrete",
323 "geoRole": "Country",
324 "id": "18mSG0000000TdLYAU",
325 "isVisible": true,
326 "label": "Assistant Phone",
327 "lastModifiedBy": null,
328 "lastModifiedDate": null,
329 "sortOrder": "Ascending"
330 },
331 {
332 "apiName": "Business_Phone3",
333 "createdBy": "005SG0000057HN8YAM",
334 "createdDate": "2024-02-07T13:36:55.000Z",
335 "dataObjectFieldName": "ssot__BusinessPhoneId__c",
336 "dataType": "Text",
337 "description": null,
338 "displayCategory": "Discrete",
339 "geoRole": "Country",
340 "id": "18mSG0000000TdRYAU",
341 "isVisible": true,
342 "label": "Business Phone",
343 "lastModifiedBy": null,
344 "lastModifiedDate": null,
345 "sortOrder": "Ascending"
346 },
347 {
348 "apiName": "Created_Date22",
349 "createdBy": "005SG0000057HN8YAM",
350 "createdDate": "2024-02-07T13:36:54.000Z",
351 "dataObjectFieldName": "ssot__CreatedDate__c",
352 "dataType": "DateTime",
353 "description": null,
354 "displayCategory": "Continuous",
355 "geoRole": "Country",
356 "id": "18mSG0000000TdOYAU",
357 "isVisible": true,
358 "label": "Created Date",
359 "lastModifiedBy": null,
360 "lastModifiedDate": null,
361 "sortOrder": "Ascending"
362 },
363 {
364 "apiName": "Data_Source23",
365 "createdBy": "005SG0000057HN8YAM",
366 "createdDate": "2024-02-07T13:36:55.000Z",
367 "dataObjectFieldName": "ssot__DataSourceId__c",
368 "dataType": "Text",
369 "description": null,
370 "displayCategory": "Discrete",
371 "geoRole": "Country",
372 "id": "18mSG0000000TdYYAU",
373 "isVisible": true,
374 "label": "Data Source",
375 "lastModifiedBy": null,
376 "lastModifiedDate": null,
377 "sortOrder": "Ascending"
378 },
379 {
380 "apiName": "Data_Source_Object23",
381 "createdBy": "005SG0000057HN8YAM",
382 "createdDate": "2024-02-07T13:36:54.000Z",
383 "dataObjectFieldName": "ssot__DataSourceObjectId__c",
384 "dataType": "Text",
385 "description": null,
386 "displayCategory": "Discrete",
387 "geoRole": "Country",
388 "id": "18mSG0000000TdQYAU",
389 "isVisible": true,
390 "label": "Data Source Object",
391 "lastModifiedBy": null,
392 "lastModifiedDate": null,
393 "sortOrder": "Ascending"
394 },
395 {
396 "apiName": "First_Name3",
397 "createdBy": "005SG0000057HN8YAM",
398 "createdDate": "2024-02-07T13:36:54.000Z",
399 "dataObjectFieldName": "ssot__FirstName__c",
400 "dataType": "Text",
401 "description": null,
402 "displayCategory": "Discrete",
403 "geoRole": "Country",
404 "id": "18mSG0000000TdNYAU",
405 "isVisible": true,
406 "label": "First Name",
407 "lastModifiedBy": null,
408 "lastModifiedDate": null,
409 "sortOrder": "Ascending"
410 },
411 {
412 "apiName": "Home_Phone3",
413 "createdBy": "005SG0000057HN8YAM",
414 "createdDate": "2024-02-07T13:36:55.000Z",
415 "dataObjectFieldName": "ssot__HomePhoneId__c",
416 "dataType": "Text",
417 "description": null,
418 "displayCategory": "Discrete",
419 "geoRole": "Country",
420 "id": "18mSG0000000TdXYAU",
421 "isVisible": true,
422 "label": "Home Phone",
423 "lastModifiedBy": null,
424 "lastModifiedDate": null,
425 "sortOrder": "Ascending"
426 },
427 {
428 "apiName": "Key_Qualifier_Account3",
429 "createdBy": "005SG0000057HN8YAM",
430 "createdDate": "2024-02-07T13:36:55.000Z",
431 "dataObjectFieldName": "KQ_AccountId__c",
432 "dataType": "Text",
433 "description": null,
434 "displayCategory": "Discrete",
435 "geoRole": "Country",
436 "id": "18mSG0000000TdSYAU",
437 "isVisible": true,
438 "label": "Key Qualifier Account",
439 "lastModifiedBy": null,
440 "lastModifiedDate": null,
441 "sortOrder": "Ascending"
442 },
443 {
444 "apiName": "Key_Qualifier_Account_Contact_Id3",
445 "createdBy": "005SG0000057HN8YAM",
446 "createdDate": "2024-02-07T13:36:55.000Z",
447 "dataObjectFieldName": "KQ_Id__c",
448 "dataType": "Text",
449 "description": null,
450 "displayCategory": "Discrete",
451 "geoRole": "Country",
452 "id": "18mSG0000000TdWYAU",
453 "isVisible": true,
454 "label": "Key Qualifier Account Contact Id",
455 "lastModifiedBy": null,
456 "lastModifiedDate": null,
457 "sortOrder": "Ascending"
458 },
459 {
460 "apiName": "Last_Modified_Date22",
461 "createdBy": "005SG0000057HN8YAM",
462 "createdDate": "2024-02-07T13:36:55.000Z",
463 "dataObjectFieldName": "ssot__LastModifiedDate__c",
464 "dataType": "DateTime",
465 "description": null,
466 "displayCategory": "Continuous",
467 "geoRole": "Country",
468 "id": "18mSG0000000TdUYAU",
469 "isVisible": true,
470 "label": "Last Modified Date",
471 "lastModifiedBy": null,
472 "lastModifiedDate": null,
473 "sortOrder": "Ascending"
474 },
475 {
476 "apiName": "Last_Name3",
477 "createdBy": "005SG0000057HN8YAM",
478 "createdDate": "2024-02-07T13:36:55.000Z",
479 "dataObjectFieldName": "ssot__LastName__c",
480 "dataType": "Text",
481 "description": null,
482 "displayCategory": "Discrete",
483 "geoRole": "Country",
484 "id": "18mSG0000000TdTYAU",
485 "isVisible": true,
486 "label": "Last Name",
487 "lastModifiedBy": null,
488 "lastModifiedDate": null,
489 "sortOrder": "Ascending"
490 },
491 {
492 "apiName": "Mobile_Phone3",
493 "createdBy": "005SG0000057HN8YAM",
494 "createdDate": "2024-02-07T13:36:54.000Z",
495 "dataObjectFieldName": "ssot__MobilePhoneId__c",
496 "dataType": "Text",
497 "description": null,
498 "displayCategory": "Discrete",
499 "geoRole": "Country",
500 "id": "18mSG0000000TdPYAU",
501 "isVisible": true,
502 "label": "Mobile Phone",
503 "lastModifiedBy": null,
504 "lastModifiedDate": null,
505 "sortOrder": "Ascending"
506 },
507 {
508 "apiName": "Title8",
509 "createdBy": "005SG0000057HN8YAM",
510 "createdDate": "2024-02-07T13:36:54.000Z",
511 "dataObjectFieldName": "ssot__Title__c",
512 "dataType": "Text",
513 "description": null,
514 "displayCategory": "Discrete",
515 "geoRole": "Country",
516 "id": "18mSG0000000TdMYAU",
517 "isVisible": true,
518 "label": "Title",
519 "lastModifiedBy": null,
520 "lastModifiedDate": null,
521 "sortOrder": "Ascending"
522 }
523 ],
524 "semanticDimensionsUrl": "/services/data/v61.0/ssot/semantic/models/model_28455216/data-objects/Account_Contact5/dimensions",
525 "semanticMeasurements": [],
526 "semanticMeasurementsUrl": "/services/data/v61.0/ssot/semantic/models/model_28455216/data-objects/Account_Contact5/measurements",
527 "shouldIncludeAllFields": true
528 },
529 {
530 "apiName": "Lead5",
531 "createdBy": "005SG0000057HN8YAM",
532 "createdDate": "2024-02-07T13:36:57.000Z",
533 "dataObjectName": "ssot__Lead__dlm",
534 "dataObjectType": "Dmo",
535 "description": null,
536 "filterLogic": null,
537 "filters": [],
538 "id": "4SMSG00000029ou4AA",
539 "label": "Lead",
540 "lastModifiedBy": "005SG0000057HN8YAM",
541 "lastModifiedDate": "2024-02-07T13:36:57.000Z",
542 "logicalTableId": null,
543 "semanticDimensions": [
544 {
545 "apiName": "City4",
546 "createdBy": "005SG0000057HN8YAM",
547 "createdDate": "2024-02-07T13:36:58.000Z",
548 "dataObjectFieldName": "ssot__City__c",
549 "dataType": "Text",
550 "description": null,
551 "displayCategory": "Discrete",
552 "geoRole": "Country",
553 "id": "18mSG0000000TdjYAE",
554 "isVisible": true,
555 "label": "City",
556 "lastModifiedBy": null,
557 "lastModifiedDate": null,
558 "sortOrder": "Ascending"
559 },
560 {
561 "apiName": "Converted_Date4",
562 "createdBy": "005SG0000057HN8YAM",
563 "createdDate": "2024-02-07T13:36:57.000Z",
564 "dataObjectFieldName": "ssot__ConvertedDate__c",
565 "dataType": "DateTime",
566 "description": null,
567 "displayCategory": "Continuous",
568 "geoRole": "Country",
569 "id": "18mSG0000000TdbYAE",
570 "isVisible": true,
571 "label": "Converted Date",
572 "lastModifiedBy": null,
573 "lastModifiedDate": null,
574 "sortOrder": "Ascending"
575 },
576 {
577 "apiName": "Country4",
578 "createdBy": "005SG0000057HN8YAM",
579 "createdDate": "2024-02-07T13:36:58.000Z",
580 "dataObjectFieldName": "ssot__CountryId__c",
581 "dataType": "Text",
582 "description": null,
583 "displayCategory": "Discrete",
584 "geoRole": "Country",
585 "id": "18mSG0000000TdgYAE",
586 "isVisible": true,
587 "label": "Country",
588 "lastModifiedBy": null,
589 "lastModifiedDate": null,
590 "sortOrder": "Ascending"
591 },
592 {
593 "apiName": "Created_Date23",
594 "createdBy": "005SG0000057HN8YAM",
595 "createdDate": "2024-02-07T13:36:58.000Z",
596 "dataObjectFieldName": "ssot__CreatedDate__c",
597 "dataType": "DateTime",
598 "description": null,
599 "displayCategory": "Continuous",
600 "geoRole": "Country",
601 "id": "18mSG0000000TddYAE",
602 "isVisible": true,
603 "label": "Created Date",
604 "lastModifiedBy": null,
605 "lastModifiedDate": null,
606 "sortOrder": "Ascending"
607 },
608 {
609 "apiName": "Data_Source24",
610 "createdBy": "005SG0000057HN8YAM",
611 "createdDate": "2024-02-07T13:36:58.000Z",
612 "dataObjectFieldName": "ssot__DataSourceId__c",
613 "dataType": "Text",
614 "description": null,
615 "displayCategory": "Discrete",
616 "geoRole": "Country",
617 "id": "18mSG0000000TdcYAE",
618 "isVisible": true,
619 "label": "Data Source",
620 "lastModifiedBy": null,
621 "lastModifiedDate": null,
622 "sortOrder": "Ascending"
623 },
624 {
625 "apiName": "Data_Source_Object24",
626 "createdBy": "005SG0000057HN8YAM",
627 "createdDate": "2024-02-07T13:36:58.000Z",
628 "dataObjectFieldName": "ssot__DataSourceObjectId__c",
629 "dataType": "Text",
630 "description": null,
631 "displayCategory": "Discrete",
632 "geoRole": "Country",
633 "id": "18mSG0000000TdkYAE",
634 "isVisible": true,
635 "label": "Data Source Object",
636 "lastModifiedBy": null,
637 "lastModifiedDate": null,
638 "sortOrder": "Ascending"
639 },
640 {
641 "apiName": "Description7",
642 "createdBy": "005SG0000057HN8YAM",
643 "createdDate": "2024-02-07T13:36:58.000Z",
644 "dataObjectFieldName": "ssot__Description__c",
645 "dataType": "Text",
646 "description": null,
647 "displayCategory": "Discrete",
648 "geoRole": "Country",
649 "id": "18mSG0000000TdeYAE",
650 "isVisible": true,
651 "label": "Description",
652 "lastModifiedBy": null,
653 "lastModifiedDate": null,
654 "sortOrder": "Ascending"
655 },
656 {
657 "apiName": "Industry4",
658 "createdBy": "005SG0000057HN8YAM",
659 "createdDate": "2024-02-07T13:36:59.000Z",
660 "dataObjectFieldName": "ssot__IndustryId__c",
661 "dataType": "Text",
662 "description": null,
663 "displayCategory": "Discrete",
664 "geoRole": "Country",
665 "id": "18mSG0000000TdnYAE",
666 "isVisible": true,
667 "label": "Industry",
668 "lastModifiedBy": null,
669 "lastModifiedDate": null,
670 "sortOrder": "Ascending"
671 },
672 {
673 "apiName": "Key_Qualifier_Lead_Id4",
674 "createdBy": "005SG0000057HN8YAM",
675 "createdDate": "2024-02-07T13:36:58.000Z",
676 "dataObjectFieldName": "KQ_Id__c",
677 "dataType": "Text",
678 "description": null,
679 "displayCategory": "Discrete",
680 "geoRole": "Country",
681 "id": "18mSG0000000TdiYAE",
682 "isVisible": true,
683 "label": "Key Qualifier Lead Id",
684 "lastModifiedBy": null,
685 "lastModifiedDate": null,
686 "sortOrder": "Ascending"
687 },
688 {
689 "apiName": "Last_Modified_Date23",
690 "createdBy": "005SG0000057HN8YAM",
691 "createdDate": "2024-02-07T13:36:59.000Z",
692 "dataObjectFieldName": "ssot__LastModifiedDate__c",
693 "dataType": "DateTime",
694 "description": null,
695 "displayCategory": "Continuous",
696 "geoRole": "Country",
697 "id": "18mSG0000000TdpYAE",
698 "isVisible": true,
699 "label": "Last Modified Date",
700 "lastModifiedBy": null,
701 "lastModifiedDate": null,
702 "sortOrder": "Ascending"
703 },
704 {
705 "apiName": "Lead_Id4",
706 "createdBy": "005SG0000057HN8YAM",
707 "createdDate": "2024-02-07T13:36:59.000Z",
708 "dataObjectFieldName": "ssot__Id__c",
709 "dataType": "Text",
710 "description": null,
711 "displayCategory": "Discrete",
712 "geoRole": "Country",
713 "id": "18mSG0000000TdmYAE",
714 "isVisible": true,
715 "label": "Lead Id",
716 "lastModifiedBy": null,
717 "lastModifiedDate": null,
718 "sortOrder": "Ascending"
719 },
720 {
721 "apiName": "Lead_Source7",
722 "createdBy": "005SG0000057HN8YAM",
723 "createdDate": "2024-02-07T13:36:57.000Z",
724 "dataObjectFieldName": "ssot__LeadSourceId__c",
725 "dataType": "Text",
726 "description": null,
727 "displayCategory": "Discrete",
728 "geoRole": "Country",
729 "id": "18mSG0000000TdaYAE",
730 "isVisible": true,
731 "label": "Lead Source",
732 "lastModifiedBy": null,
733 "lastModifiedDate": null,
734 "sortOrder": "Ascending"
735 },
736 {
737 "apiName": "Photo_URL4",
738 "createdBy": "005SG0000057HN8YAM",
739 "createdDate": "2024-02-07T13:36:58.000Z",
740 "dataObjectFieldName": "ssot__PhotoURL__c",
741 "dataType": "Text",
742 "description": null,
743 "displayCategory": "Discrete",
744 "geoRole": "Country",
745 "id": "18mSG0000000TdfYAE",
746 "isVisible": true,
747 "label": "Photo URL",
748 "lastModifiedBy": null,
749 "lastModifiedDate": null,
750 "sortOrder": "Ascending"
751 },
752 {
753 "apiName": "State_Province4",
754 "createdBy": "005SG0000057HN8YAM",
755 "createdDate": "2024-02-07T13:36:59.000Z",
756 "dataObjectFieldName": "ssot__StateProvinceId__c",
757 "dataType": "Text",
758 "description": null,
759 "displayCategory": "Discrete",
760 "geoRole": "Country",
761 "id": "18mSG0000000TdoYAE",
762 "isVisible": true,
763 "label": "State Province",
764 "lastModifiedBy": null,
765 "lastModifiedDate": null,
766 "sortOrder": "Ascending"
767 },
768 {
769 "apiName": "Title9",
770 "createdBy": "005SG0000057HN8YAM",
771 "createdDate": "2024-02-07T13:36:58.000Z",
772 "dataObjectFieldName": "ssot__Title__c",
773 "dataType": "Text",
774 "description": null,
775 "displayCategory": "Discrete",
776 "geoRole": "Country",
777 "id": "18mSG0000000TdhYAE",
778 "isVisible": true,
779 "label": "Title",
780 "lastModifiedBy": null,
781 "lastModifiedDate": null,
782 "sortOrder": "Ascending"
783 },
784 {
785 "apiName": "Website15",
786 "createdBy": "005SG0000057HN8YAM",
787 "createdDate": "2024-02-07T13:36:59.000Z",
788 "dataObjectFieldName": "ssot__Website__c",
789 "dataType": "Text",
790 "description": null,
791 "displayCategory": "Discrete",
792 "geoRole": "Country",
793 "id": "18mSG0000000TdlYAE",
794 "isVisible": true,
795 "label": "Website",
796 "lastModifiedBy": null,
797 "lastModifiedDate": null,
798 "sortOrder": "Ascending"
799 }
800 ],
801 "semanticDimensionsUrl": "/services/data/v61.0/ssot/semantic/models/model_28455216/data-objects/Lead5/dimensions",
802 "semanticMeasurements": [
803 {
804 "aggregationType": "None",
805 "apiName": "Annual_Revenue4",
806 "createdBy": "005SG0000057HN8YAM",
807 "createdDate": "2024-02-07T13:36:59.000Z",
808 "dataObjectFieldName": "ssot__AnnualRevenue__c",
809 "dataType": "Number",
810 "decimalPlace": 2,
811 "description": null,
812 "directionality": "Up",
813 "displayCategory": "Continuous",
814 "id": "18mSG0000000TdqYAE",
815 "isAggregatable": true,
816 "isVisible": true,
817 "label": "Annual Revenue",
818 "lastModifiedBy": null,
819 "lastModifiedDate": null,
820 "shouldTreatNullsAsZeros": false,
821 "sortOrder": "Ascending"
822 }
823 ],
824 "semanticMeasurementsUrl": "/services/data/v61.0/ssot/semantic/models/model_28455216/data-objects/Lead5/measurements",
825 "shouldIncludeAllFields": true
826 }
827 ],
828 "semanticDataObjectsUrl": "/services/data/v61.0/ssot/semantic/models/model_28455216/data-objects",
829 "semanticLogicalTables": [],
830 "semanticParameters": [],
831 "semanticParametersUrl": "/services/data/v61.0/ssot/semantic/models/model_28455216/parameters",
832 "semanticRelationships": [],
833 "semanticRelationshipsUrl": "/services/data/v61.0/ssot/semantic/models/model_28455216/relationships"
834}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
1{
2 "apiName": "{{newModelName}}",
3 "label": "{{newModelName}}",
4 "type": "Standard",
5 "dataspace": "default",
6 "semanticCalculatedMeasurements": [],
7 "semanticLogicalViews": [
8 {
9 "apiName": "{{newModelName}}",
10 "customSQLV2": "select \"ssot__Id__c\" as \"Id\" from \"ssot__Account__dlm\"",
11 "filters": [],
12 "label": "{{newModelName}}",
13 "semanticDataObjects": [
14 {
15 "dataObjectName": "Dummy",
16 "dataObjectType": "CustomSQL",
17 "label": "{{newModelName}}",
18 "semanticDimensions": [
19 {
20 "dataObjectFieldName": "Id",
21 "dataType": "Text",
22 "displayCategory": "Discrete",
23 "label": "Account Id",
24 "semanticDataType": "None"
25 }
26 ],
27 "semanticMeasurements": [],
28 "shouldIncludeAllFields": false
29 }
30 ],
31 "referenceIntegritySemanticDataObjects": [
32 {
33 "apiName": "{{newModelName}}",
34 "dataObjectName": "ssot__Account__dlm",
35 "dataObjectType": "Dmo",
36 "label": "Account",
37 "semanticDimensions": [
38 {
39 "apiName": "{{newModelName}}",
40 "dataObjectFieldName": "ssot__Id__c",
41 "dataType": "Text",
42 "displayCategory": "Discrete",
43 "label": "DataSourceId",
44 "semanticDataType": "None"
45 }
46 ],
47 "semanticMeasurements": [],
48 "shouldIncludeAllFields": false
49 }
50 ],
51 "semanticRelationships": [],
52 "semanticUnions": [],
53 "semanticViewTypeEnum": "CustomSQL"
54 }
55 ],
56 "semanticDataObjects": []
57}The following is an example of a response to create a full Semantic Model request (with Custom SQL Logical View):
1{
2 "agentEnabled":false,
3 "allowUnmapped":false,
4 "apiName":"model1223",
5 "categories":[
6
7 ],
8 "createdBy":"005UA0000002xbuYAA",
9 "createdDate":"2026-04-12T10:28:58.000Z",
10 "currency":{
11 "useOrgDefault":true
12 },
13 "dataspace":"default",
14 "fieldsOverrides":[
15
16 ],
17 "hasUnmapped":false,
18 "id":"2SMUA000000ds294AA",
19 "isAiDrafted":false,
20 "isPartialSdm":false,
21 "label":"model1223",
22 "lastModifiedBy":"005UA0000002xbuYAA",
23 "lastModifiedDate":"2026-04-12T10:28:58.000Z",
24 "lockedActions":{
25
26 },
27 "semanticCalculatedDimensions":[
28
29 ],
30 "semanticCalculatedDimensionsUrl":"/services/data/v66.0/ssot/semantic/models/model1223/calculated-dimensions",
31 "semanticCalculatedMeasurements":[
32
33 ],
34 "semanticCalculatedMeasurementsUrl":"/services/data/v66.0/ssot/semantic/models/model1223/calculated-measurements",
35 "semanticDataObjects":[
36
37 ],
38 "semanticDataObjectsUrl":"/services/data/v66.0/ssot/semantic/models/model1223/data-objects",
39 "semanticDimensionHierarchies":[
40
41 ],
42 "semanticGroupings":[
43
44 ],
45 "semanticGroupingsUrl":"/services/data/v66.0/ssot/semantic/models/model1223/groupings",
46 "semanticLogicalViews":[
47 {
48 "apiName":"customSQL_lv_example",
49 "createdBy":"005UA0000002xbuYAA",
50 "createdDate":"2026-04-12T10:28:59.000Z",
51 "customSQLV2":"select "ssot__Id__c" as "Id" from "ssot__Account__dlm"",
52 "filters":[
53
54 ],
55 "id":"1DOUA000000i0Yz4AI",
56 "isQueryable":"Queryable",
57 "label":"customSQL lv example",
58 "lastModifiedBy":"005UA0000002xbuYAA",
59 "lastModifiedDate":"2026-04-12T10:28:59.000Z",
60 "overriddenProperties":[
61
62 ],
63 "referenceIntegritySemanticDataObjects":[
64 {
65 "apiName":"account11",
66 "createdBy":"005UA0000002xbuYAA",
67 "createdDate":"2026-04-12T10:28:59.000Z",
68 "customSqlIdentifier":"ssot__Account__dlm",
69 "dataObjectName":"ssot__Account__dlm",
70 "dataObjectType":"Dmo",
71 "filters":[
72
73 ],
74 "id":"1DOUA000000i0Z14AI",
75 "isQueryable":"Queryable",
76 "label":"Account",
77 "lastModifiedBy":"005UA0000002xbuYAA",
78 "lastModifiedDate":"2026-04-12T10:28:59.000Z",
79 "logicalViewId":"1DOUA000000i0Yz4AI",
80 "overriddenProperties":[
81
82 ],
83 "semanticDimensions":[
84 {
85 "apiName":"Id112",
86 "createdBy":"005UA0000002xbuYAA",
87 "createdDate":"2026-04-12T10:29:00.000Z",
88 "customSqlIdentifier":"ssot__Id__c",
89 "dataObjectFieldName":"ssot__Id__c",
90 "dataType":"Text",
91 "displayCategory":"Discrete",
92 "id":"18mUA000000WIBWYA4",
93 "isQueryable":"Queryable",
94 "isVisible":true,
95 "label":"DataSourceId",
96 "overriddenProperties":[
97
98 ],
99 "semanticDataType":"None",
100 "storageDataType":"Text"
101 }
102 ],
103 "semanticDimensionsUrl":"/services/data/v66.0/ssot/semantic/models/model1223/data-objects/account11/dimensions",
104 "semanticMeasurements":[
105
106 ],
107 "semanticMeasurementsUrl":"/services/data/v66.0/ssot/semantic/models/model1223/data-objects/account11/measurements",
108 "shouldIncludeAllFields":false,
109 "tableType":"Standard"
110 }
111 ],
112 "semanticDataObjects":[
113 {
114 "apiName":"Account3",
115 "createdBy":"005UA0000002xbuYAA",
116 "createdDate":"2026-04-12T10:28:59.000Z",
117 "dataObjectName":"Dummy",
118 "dataObjectType":"CustomSQL",
119 "filters":[
120
121 ],
122 "id":"1DOUA000000i0Z04AI",
123 "isQueryable":"Queryable",
124 "label":"Account",
125 "lastModifiedBy":"005UA0000002xbuYAA",
126 "lastModifiedDate":"2026-04-12T10:28:59.000Z",
127 "logicalViewId":"1DOUA000000i0Yz4AI",
128 "overriddenProperties":[
129
130 ],
131 "semanticDimensions":[
132 {
133 "apiName":"Account_Id",
134 "createdBy":"005UA0000002xbuYAA",
135 "createdDate":"2026-04-12T10:29:00.000Z",
136 "dataObjectFieldName":"Id",
137 "dataType":"Text",
138 "displayCategory":"Discrete",
139 "id":"18mUA000000WIBVYA4",
140 "isQueryable":"Queryable",
141 "isVisible":true,
142 "label":"Account Id",
143 "overriddenProperties":[
144
145 ],
146 "semanticDataType":"None"
147 }
148 ],
149 "semanticDimensionsUrl":"/services/data/v66.0/ssot/semantic/models/model1223/data-objects/Account3/dimensions",
150 "semanticMeasurements":[
151
152 ],
153 "semanticMeasurementsUrl":"/services/data/v66.0/ssot/semantic/models/model1223/data-objects/Account3/measurements",
154 "shouldIncludeAllFields":false,
155 "tableType":"Standard"
156 }
157 ],
158 "semanticRelationships":[
159
160 ],
161 "semanticUnions":[
162
163 ],
164 "semanticViewTypeEnum":"CustomSQL",
165 "tableType":"Standard"
166 }
167 ],
168 "semanticMetrics":[
169
170 ],
171 "semanticModelFilters":[
172
173 ],
174 "semanticModelInfo":{
175 "definitionsCount":3,
176 "maxDefinitionCount":5000,
177 "modelHierarchyDepth":1
178 },
179 "semanticParameters":[
180
181 ],
182 "semanticParametersUrl":"/services/data/v66.0/ssot/semantic/models/model1223/parameters",
183 "semanticRelationships":[
184
185 ],
186 "semanticRelationshipsUrl":"/services/data/v66.0/ssot/semantic/models/model1223/relationships",
187 "sourceCreation":"Other"
188}
j