1Create, Save, Validate and Update Dataset Relationship JSON Examples
Table of Contents
Complete JSON Example
This JSON example applies to Create Dataset Relationship, Save Dataset Relationship, Validate Dataset Relationship, and Update Dataset Relationship APIs and can be used as a reference for request body object.
JSON Body
{
"iro":{
"entityRepositDate":"",
"ownerAppId":"398949229",
"linkedEntityId":"",
"type":"DRD_OBJECT",
"specific":{
"drdObject":{
"layout":{
"nodes":[
{
"top":"414.8125",
"left":"80",
"width":"200",
"id":"17098110604382127032016158635163_6",
"collapse":"false",
"height":"300"
},
{
"top":"87.8125",
"left":"285",
"width":"200",
"id":"17098114278439127077099135156813_2",
"collapse":"false",
"height":"300"
},
{
"top":"78.8125",
"left":"21",
"width":"200",
"id":"17098107735558127085088197661322_1",
"collapse":"false",
"height":"300"
},
{
"top":"3.2125",
"left":"561",
"width":"200",
"id":"17098107920041127081041159911730_5",
"collapse":"false",
"height":"300"
}
]
},
"panelProperties":{
},
"nodes":[
{
"id":"17098110604382127032016158635163_6",
"relDataset":{
"aliasName":"DimProduct Small",
"id":"17098110604382127032016158635163",
"type":""
}
},
{
"id":"17098114278439127077099135156813_2",
"relDataset":{
"aliasName":"FactSales",
"id":"17098114278439127077099135156813",
"type":"FACT"
}
},
{
"id":"17098107735558127085088197661322_1",
"relDataset":{
"aliasName":"DimCustomer",
"id":"17098107735558127085088197661322",
"type":""
}
},
{
"id":"17098107920041127081041159911730_5",
"relDataset":{
"aliasName":"DimDate",
"id":"17098107920041127081041159911730",
"type":""
}
}
],
"lineType":"NOODLE",
"viewType":"GRAPHICAL",
"relations":[
{
"sourceId":"17098110604382127032016158635163_6",
"name":"undefined",
"join":{
"type":"INNER",
"joinBy":[
{
"node1Key":{
"id":"",
"type":"",
"content":"productkey"
},
"node1SecondaryKey":{
"id":"",
"type":""
},
"operator":"EQUAL_TO",
"node2SecondaryKey":{
"id":"",
"type":""
},
"node2Key":{
"id":"",
"type":"",
"content":"productkey"
}
}
]
},
"type":"ONE_TO_MANY",
"node2Id":"17098114278439127077099135156813_2",
"node1Id":"17098110604382127032016158635163_6"
},
{
"sourceId":"17098114278439127077099135156813_2",
"name":"undefined",
"join":{
"type":"INNER",
"joinBy":[
{
"node1Key":{
"id":"",
"type":"",
"content":"customerkey"
},
"node1SecondaryKey":{
"id":"",
"type":""
},
"operator":"EQUAL_TO",
"node2SecondaryKey":{
"id":"",
"type":""
},
"node2Key":{
"id":"",
"type":"",
"content":"customerkey"
}
}
]
},
"type":"ONE_TO_MANY",
"node2Id":"17098107735558127085088197661322_1",
"node1Id":"17098114278439127077099135156813_2"
},
{
"sourceId":"17098107920041127081041159911730_5",
"name":"undefined",
"join":{
"type":"INNER",
"joinBy":[
{
"node1Key":{
"id":"",
"type":"",
"content":"datekey"
},
"node1SecondaryKey":{
"id":"",
"type":""
},
"operator":"EQUAL_TO",
"node2SecondaryKey":{
"id":"",
"type":""
},
"node2Key":{
"id":"",
"type":"",
"content":"orderdatekey"
}
}
]
},
"type":"ONE_TO_MANY",
"node2Id":"17098114278439127077099135156813_2",
"node1Id":"17098107920041127081041159911730_5"
}
],
"layoutProperty":{
"panelDetails":{
"files":{
"style":{
},
"id":"files"
},
"datasets":{
"style":{
},
"id":"datasets"
},
"properties":{
"style":{
},
"id":"properties"
}
},
"columnDetails":[
{
"panels":[
],
"style":{
"width":224
}
},
{
"panels":[
],
"style":{
}
}
]
}
}
},
"folderId":"folder_17504177963919127045012149779917",
"designSource":"DESIGNER",
"ownerAppName":"Admin",
"common":{
"compatibilityVersion":"1",
"desc":"",
"tags":""
},
"entityState":"",
"name":"Sales Relationship",
"isPublic":true,
"subType":"",
"repositDate":"01/12/2026 17:06:02 IST",
"id":"17504178000665127098015115855971",
"folderName":"Sales",
"accessRights":"1",
"categoryId":"folder_17504177963919127045012149779917"
}
}