{
"name": "Table A",
"tableName": "t_example",
"columns": [
{
"isHidden": false,
"columnName": "code",
"label": "{c}",
"dataType": "VARCHAR(255)",
"isDistributed": false,
"isAutoIncrement": false,
"isNullable": true,
"isUnique": true,
"metadatas": [
{
"unit": "unit_a",
"colors": [
{
"black" : "#00000"
},
{
"white" : "#aaaaa"
}
],
"iconUrl": "https://is3.cloudhost.id/img-kbrt/2023/02/jokowi-versi-anime-naruto.jpg",
"showPercentage": 0
}
]
},
{
"isHidden": false,
"columnName": "name",
"label": "{a}",
"dataType": "VARCHAR(255)",
"isDistributed": true,
"isAutoIncrement": false,
"isNullable": true,
"isUnique": false,
"metadatas": [
{
"unit": "unit_a",
"colors": [
{
"black" : "#00000"
},
{
"white" : "#aaaaa"
}
],
"iconUrl": "https://is3.cloudhost.id/img-kbrt/2023/02/jokowi-versi-anime-naruto.jpg",
"showPercentage": 0
}
]
},
{
"isHidden": true,
"columnName": "age",
"label": "{b}",
"dataType": "INT",
"isDistributed": false,
"isAutoIncrement": false,
"isNullable": true,
"isUnique": false,
"metadatas": [
{
"unit": "unit_b",
"colors": [
{
"black" : "#00000"
},
{
"white" : "#aaaaa"
}
],
"iconUrl": "https://is3.cloudhost.id/img-kbrt/2023/02/jokowi-versi-anime-naruto.jpg",
"showPercentage": 0
}
]
},
{
"isHidden": false,
"columnName": "date_of_birth",
"label": "{c}",
"dataType": "DATETIME",
"isDistributed": false,
"isAutoIncrement": false,
"isNullable": true,
"isUnique": true,
"metadatas": [
{
"unit": "unit_a",
"colors": [
{
"black" : "#00000"
},
{
"white" : "#aaaaa"
}
],
"iconUrl": "https://is3.cloudhost.id/img-kbrt/2023/02/jokowi-versi-anime-naruto.jpg",
"showPercentage": 0
}
]
}
],
"etls": [
{
"type": "rename",
"fieldSource": "DATE_PERIODE",
"fieldDestination": "destination_a",
"replaceIn": "replace_in_a",
"replaceOut": "replace_out_a"
},
{
"type": "rename",
"fieldSource": "CENTRAL",
"fieldDestination": "destination_b",
"replaceIn": "",
"replaceOut": ""
},
{
"type": "rename",
"fieldSource": "DESC_CENTRAL",
"fieldDestination": "destination_b",
"replaceIn": "",
"replaceOut": ""
},
{
"type": "rename",
"fieldSource": "DESC_CENTRAL",
"fieldDestination": "destination_b",
"replaceIn": "",
"replaceOut": ""
},
{
"type": "rename",
"fieldSource": "DESC_CENTRAL",
"fieldDestination": "destination_b",
"replaceIn": "",
"replaceOut": ""
},
{
"type": "rename",
"fieldSource": "DESC_CENTRAL",
"fieldDestination": "destination_b",
"replaceIn": "",
"replaceOut": ""
},
{
"type": "rename",
"fieldSource": "DESC_CENTRAL",
"fieldDestination": "destination_b",
"replaceIn": "",
"replaceOut": ""
},
{
"type": "rename",
"fieldSource": "DESC_CENTRAL",
"fieldDestination": "destination_b",
"replaceIn": "",
"replaceOut": ""
},
{
"type": "rename",
"fieldSource": "DESC_CENTRAL",
"fieldDestination": "destination_b",
"replaceIn": "",
"replaceOut": ""
},
{
"type": "rename",
"fieldSource": "DESC_CENTRAL",
"fieldDestination": "destination_b",
"replaceIn": "",
"replaceOut": ""
},
{
"type": "rename",
"fieldSource": "DESC_CENTRAL",
"fieldDestination": "destination_b",
"replaceIn": "",
"replaceOut": ""
},
{
"type": "rename",
"fieldSource": "DESC_CENTRAL",
"fieldDestination": "destination_b",
"replaceIn": "",
"replaceOut": ""
},
{
"type": "rename",
"fieldSource": "DESC_CENTRAL",
"fieldDestination": "destination_b",
"replaceIn": "",
"replaceOut": ""
}
],
"customEtlId" : 0
}
curl --location --request POST 'http://localhost:8080/api/v1/dataTable' \
--header 'Content-Type: application/json' \
--data-raw '{
"name": "Table A",
"tableName": "t_example",
"columns": [
{
"isHidden": false,
"columnName": "code",
"label": "{c}",
"dataType": "VARCHAR(255)",
"isDistributed": false,
"isAutoIncrement": false,
"isNullable": true,
"isUnique": true,
"metadatas": [
{
"unit": "unit_a",
"colors": [
{
"black" : "#00000"
},
{
"white" : "#aaaaa"
}
],
"iconUrl": "https://is3.cloudhost.id/img-kbrt/2023/02/jokowi-versi-anime-naruto.jpg",
"showPercentage": 0
}
]
},
{
"isHidden": false,
"columnName": "name",
"label": "{a}",
"dataType": "VARCHAR(255)",
"isDistributed": true,
"isAutoIncrement": false,
"isNullable": true,
"isUnique": false,
"metadatas": [
{
"unit": "unit_a",
"colors": [
{
"black" : "#00000"
},
{
"white" : "#aaaaa"
}
],
"iconUrl": "https://is3.cloudhost.id/img-kbrt/2023/02/jokowi-versi-anime-naruto.jpg",
"showPercentage": 0
}
]
},
{
"isHidden": true,
"columnName": "age",
"label": "{b}",
"dataType": "INT",
"isDistributed": false,
"isAutoIncrement": false,
"isNullable": true,
"isUnique": false,
"metadatas": [
{
"unit": "unit_b",
"colors": [
{
"black" : "#00000"
},
{
"white" : "#aaaaa"
}
],
"iconUrl": "https://is3.cloudhost.id/img-kbrt/2023/02/jokowi-versi-anime-naruto.jpg",
"showPercentage": 0
}
]
},
{
"isHidden": false,
"columnName": "date_of_birth",
"label": "{c}",
"dataType": "DATETIME",
"isDistributed": false,
"isAutoIncrement": false,
"isNullable": true,
"isUnique": true,
"metadatas": [
{
"unit": "unit_a",
"colors": [
{
"black" : "#00000"
},
{
"white" : "#aaaaa"
}
],
"iconUrl": "https://is3.cloudhost.id/img-kbrt/2023/02/jokowi-versi-anime-naruto.jpg",
"showPercentage": 0
}
]
}
],
"etls": [
{
"type": "rename",
"fieldSource": "DATE_PERIODE",
"fieldDestination": "destination_a",
"replaceIn": "replace_in_a",
"replaceOut": "replace_out_a"
},
{
"type": "rename",
"fieldSource": "CENTRAL",
"fieldDestination": "destination_b",
"replaceIn": "",
"replaceOut": ""
},
{
"type": "rename",
"fieldSource": "DESC_CENTRAL",
"fieldDestination": "destination_b",
"replaceIn": "",
"replaceOut": ""
},
{
"type": "rename",
"fieldSource": "DESC_CENTRAL",
"fieldDestination": "destination_b",
"replaceIn": "",
"replaceOut": ""
},
{
"type": "rename",
"fieldSource": "DESC_CENTRAL",
"fieldDestination": "destination_b",
"replaceIn": "",
"replaceOut": ""
},
{
"type": "rename",
"fieldSource": "DESC_CENTRAL",
"fieldDestination": "destination_b",
"replaceIn": "",
"replaceOut": ""
},
{
"type": "rename",
"fieldSource": "DESC_CENTRAL",
"fieldDestination": "destination_b",
"replaceIn": "",
"replaceOut": ""
},
{
"type": "rename",
"fieldSource": "DESC_CENTRAL",
"fieldDestination": "destination_b",
"replaceIn": "",
"replaceOut": ""
},
{
"type": "rename",
"fieldSource": "DESC_CENTRAL",
"fieldDestination": "destination_b",
"replaceIn": "",
"replaceOut": ""
},
{
"type": "rename",
"fieldSource": "DESC_CENTRAL",
"fieldDestination": "destination_b",
"replaceIn": "",
"replaceOut": ""
},
{
"type": "rename",
"fieldSource": "DESC_CENTRAL",
"fieldDestination": "destination_b",
"replaceIn": "",
"replaceOut": ""
},
{
"type": "rename",
"fieldSource": "DESC_CENTRAL",
"fieldDestination": "destination_b",
"replaceIn": "",
"replaceOut": ""
},
{
"type": "rename",
"fieldSource": "DESC_CENTRAL",
"fieldDestination": "destination_b",
"replaceIn": "",
"replaceOut": ""
}
],
"customEtlId" : 0
}'
{}