Create, Save, Validate, and Update Dataset JSON Examples
This documentation is for Kyvos 2026.6.x. To view documentation for other Kyvos versions, click here. |
|---|
Table of Contents
Complete JSON Example
This JSON example applies to Create Dataset, Save Dataset, Validate Dataset, and Update Dataset APIs and can be used as a reference for request body object.
JSON Body
{
"iro":{
"entityRepositDate":"",
"ownerAppId":"397039469",
"linkedEntityId":"",
"type":"QUERY",
"specific":{
"qo":{
"role":"DIMENSION",
"connType":"HADOOP_CLUSTER",
"cached":true,
"connName":"DefaultHadoopCluster01",
"transformation":{
"steps":[
{
"inputSteps":[
],
"top":"0",
"left":"0",
"outputSteps":[
],
"name":"Fetch",
"stepInfo":{
"fetchInfo":{
"columns":[
{
"updatedName":"orderid",
"fieldFormat":{
"useDefault":"",
"content":"0"
},
"databaseTimeZone":"",
"pigDataType":1,
"role":"",
"hidden":false,
"fieldDataFormatType":"1",
"dataSubTypeName":"",
"dataTypeName":"CHAR",
"precision":"",
"scale":"",
"locale":"",
"fullyQualifiedName":"",
"originalName":"orderid",
"originalQualifiedName":"",
"sortType":"",
"sortOrder":"",
"name":"orderid",
"originalDataTypeName":"12"
},
{
"updatedName":"orderdate",
"fieldFormat":{
"useDefault":"",
"content":"0"
},
"databaseTimeZone":"",
"pigDataType":1,
"role":"",
"hidden":false,
"fieldDataFormatType":"1",
"dataSubTypeName":"",
"dataTypeName":"CHAR",
"precision":"",
"scale":"",
"locale":"",
"fullyQualifiedName":"",
"originalName":"orderdate",
"originalQualifiedName":"",
"sortType":"",
"sortOrder":"",
"name":"orderdate",
"originalDataTypeName":"12"
},
{
"updatedName":"sales",
"fieldFormat":{
"useDefault":"",
"content":"0"
},
"databaseTimeZone":"",
"pigDataType":8,
"role":"",
"hidden":false,
"fieldDataFormatType":"2",
"dataSubTypeName":"double",
"dataTypeName":"NUMBER",
"precision":"",
"scale":"",
"locale":"",
"fullyQualifiedName":"",
"originalName":"sales",
"originalQualifiedName":"",
"sortType":"",
"sortOrder":"",
"name":"sales",
"originalDataTypeName":"12"
}
],
"fetch":{
"incrementalIdentifier":{
"columnName":""
},
"sqlSource":{
"sql":"select orderid, orderdate, sales FROM automationtables.raw_orderdate"
},
"connType":"PARENT",
"sparkJdbcDataPartitionColumn":{
"metadataMode":"DEFAULT",
"minValue":"",
"maxValue":"",
"numberOfRecords":"",
"numberOfPartitions":"",
"columnName":"",
"tableName":""
},
"connName":"DefaultHadoopCluster01",
"inputType":"SQL",
"source":"HCATALOG",
"isSorted":false,
"sourceSubType":"",
"lookupEnabled":false
}
}
},
"id":"17768556321332127066042198586809",
"type":"FETCH"
}
]
}
}
},
"folderId":"folder_17562077963635127049022155488607",
"designSource":"DESIGNER",
"ownerAppName":"Admin",
"common":{
"compatibilityVersion":"1",
"desc":"",
"tags":""
},
"entityState":"",
"name":"Account",
"isPublic":true,
"subType":"REGISTERED",
"repositDate":"04/21/2026 18:03:46 IST",
"id":"17768556321332127066042198586809",
"folderName":"AutomationTables",
"accessRights":"1",
"categoryId":"folder_17562077963635127049022155488607"
}
}