1Create, Save, Validate, and Update Dataset JSON Examples
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"
}
}