Updates the table with the given payload.
Everything is updated except for the name.
To update the table name use
Rename Table.
Path Elements
id
string
|
UUID that is used to identify the table.
example value cb2d8a2d-67e8-40c2-8884-1c77c5ddf251
|
Example
- Update Table Using Table ID
Request:
{
"name":"Special Events",
"columns" : [
{
"name" : "Forecasted Volume",
"dataType" : "DECIMAL",
"constraints" : [
{
"name" : "unitRequired",
"type" : "BOOLEAN",
"value" : true
}],
"required" : true
},
{
"name" : "Historic Revenue",
"dataType" : "DECIMAL",
"constraints" : [
{
"name" : "currencyRequired",
"type" : "BOOLEAN",
"value" : true
}],
"required" : true
},
{
"name" : "Product Cost",
"dataType" : "DECIMAL",
"constraints" : [
{
"name" : "unitRequired",
"type" : "BOOLEAN",
"value" : true,
},
{
"name" : "currencyRequired",
"type" : "BOOLEAN",
"value" : true
}],
"required" : true
},
{
"name" : "Competitor Influence",
"dataType" : "STRING",
"required" : false
}
],
"accessSequence" : [
{
"accessLevel" : [
{
"dimID" : "28484058-4ffc-329b-94ff-63e1ddbd7189",
"aspectID" : "fbd99ad0-1b92-3baf-8686-772a39e3d065"
},
{
"dimID" : "c689acc7-ee13-3482-aa7b-c6a13419431c",
"aspectID" : "85921462-8431-3951-97c0-558f7b5f8ffc"
}
]
},
{
"accessLevel" : [
{
"dimID" : "28484058-4ffc-329b-94ff-63e1ddbd7189",
"aspectID" : "fbd99ad0-1b92-3baf-8686-772a39e3d065"
},
{
"dimID" : "c689acc7-ee13-3482-aa7b-c6a13419431c",
"aspectID" : "2b848a8c-c886-3253-921a-77c43cd50aae"
}
]
}
]
}
Response:
HTTP/1.1
200
OK
{
"id": "cb2d8a2d-67e8-40c2-8884-1c77c5ddf251",
"name":"Special Events",
"columns" : [
{
"name" : "Forecasted Volume",
"dataType" : "DECIMAL",
"constraints" : [
{
"name" : "unitRequired",
"type" : "BOOLEAN",
"value" : true
}],
"required" : true
},
{
"name" : "Historic Revenue",
"dataType" : "DECIMAL",
"constraints" : [
{
"name" : "currencyRequired",
"type" : "BOOLEAN",
"value" : true
}],
"required" : true
},
{
"name" : "Product Cost",
"dataType" : "DECIMAL",
"constraints" : [
{
"name" : "unitRequired",
"type" : "BOOLEAN",
"value" : true
},
{
"name" : "currencyRequired",
"type" : "BOOLEAN",
"value" : true
}],
"required" : true
},
{
"name" : "Competitor Influence",
"dataType" : "STRING",
"required" : false
}
],
"accessSequence" : [
{
"accessLevel" : [
{
"dimID" : "28484058-4ffc-329b-94ff-63e1ddbd7189",
"dimName" : "SAMPLE_PRODUCTS",
"aspectID" : "fbd99ad0-1b92-3baf-8686-772a39e3d065",
"aspectName" : "UPC"
},
{
"dimID" : "c689acc7-ee13-3482-aa7b-c6a13419431c",
"dimName" : "LARGE_CITIES",
"aspectID" : "85921462-8431-3951-97c0-558f7b5f8ffc",
"aspectName" : "CITY"
}
]
},
{
"accessLevel" : [
{
"dimID" : "28484058-4ffc-329b-94ff-63e1ddbd7189",
"dimName" : "SAMPLE_PRODUCTS",
"aspectID" : "fbd99ad0-1b92-3baf-8686-772a39e3d065",
"aspectName" : "UPC"
},
{
"dimID" : "c689acc7-ee13-3482-aa7b-c6a13419431c",
"dimName" : "LARGE_CITIES",
"aspectID" : "2b848a8c-c886-3253-921a-77c43cd50aae",
"aspectName" : "STATE"
}
]
}
],
"dynamic" : false,
"createdBy" : "c3fb23a7-51d5-3f23-aae4-ea3ebcda987f"
}
Example
- Update Table to use Dynamic Column
Request:
{
"name":"Special Forecasts",
"dynamic" : true,
"accessSequence" : [
{
"accessLevel" : [
{
"dimID" : "28484058-4ffc-329b-94ff-63e1ddbd7189",
"aspectID" : "fbd99ad0-1b92-3baf-8686-772a39e3d065"
},
{
"dimID" : "c689acc7-ee13-3482-aa7b-c6a13419431c",
"aspectID" : "85921462-8431-3951-97c0-558f7b5f8ffc"
}
]
},
{
"accessLevel" :[
{
"dimID" : "28484058-4ffc-329b-94ff-63e1ddbd7189",
"aspectID" : "fbd99ad0-1b92-3baf-8686-772a39e3d065"
},
{
"dimID" : "c689acc7-ee13-3482-aa7b-c6a13419431c",
"aspectID" : "2b848a8c-c886-3253-921a-77c43cd50aae"
}
]
},
{
"accessLevel" : [
{
"dimID" : "28484058-4ffc-329b-94ff-63e1ddbd7189",
"aspectID" : "28484058-4ffc-329b-94ff-63e1ddbd7189"
},
{
"dimID" : "c689acc7-ee13-3482-aa7b-c6a13419431c",
"aspectID" : "2b848a8c-c886-3253-921a-77c43cd50aae"
}
]
},
{
"accessLevel" : [
{
"dimID" : "28484058-4ffc-329b-94ff-63e1ddbd7189",
"aspectID" : "28484058-4ffc-329b-94ff-63e1ddbd7189"
},
{
"dimID" : "c689acc7-ee13-3482-aa7b-c6a13419431c",
"aspectID" : "c689acc7-ee13-3482-aa7b-c6a13419431c"
}
]
}
]
}
Response:
HTTP/1.1
200
OK
{
"id": "cb2d8a2d-67e8-40c2-8884-1c77c5ddf251",
"name":"Special Events",
"accessSequence" : [
{
"accessLevel" : [
{
"dimID" : "28484058-4ffc-329b-94ff-63e1ddbd7189",
"dimName" : "SAMPLE_PRODUCTS",
"aspectID" : "fbd99ad0-1b92-3baf-8686-772a39e3d065",
"aspectName" : "UPC"
},
{
"dimID" : "c689acc7-ee13-3482-aa7b-c6a13419431c",
"dimName" : "LARGE_CITIES",
"aspectID" : "85921462-8431-3951-97c0-558f7b5f8ffc",
"aspectName" : "CITY"
}
]
},
{
"accessLevel" : [
{
"dimID" : "28484058-4ffc-329b-94ff-63e1ddbd7189",
"dimName" : "SAMPLE_PRODUCTS",
"aspectID" : "fbd99ad0-1b92-3baf-8686-772a39e3d065",
"aspectName" : "UPC"
},
{
"dimID" : "c689acc7-ee13-3482-aa7b-c6a13419431c",
"dimName" : "LARGE_CITIES",
"aspectID" : "2b848a8c-c886-3253-921a-77c43cd50aae",
"aspectName" : "STATE"
}
]
}
],
"dynamic" : true,
"createdBy" : "c3fb23a7-51d5-3f23-aae4-ea3ebcda987f"
}
Error
Example
- Update Table to use Dynamic Columns and Static Columns
Request:
{
"name":"Special Events",
"dynamic" : true,
"columns" : [
{
"name" : "Forecasted Volume",
"dataType" : "DECIMAL",
"constraints" : [
{
"name" : "unitRequired",
"type" : "BOOLEAN",
"value" : true
}],
"required" : true
},
{
"name" : "Historic Revenue",
"dataType" : "DECIMAL",
"constraints" : [
{
"name" : "currencyRequired",
"type" : "BOOLEAN",
"value" : true
}],
"required" : true
},
{
"name" : "Product Cost",
"dataType" : "DECIMAL",
"constraints" : [
{
"name" : "unitRequired",
"type" : "BOOLEAN",
"value" : true
},
{
"name" : "currencyRequired",
"type" : "BOOLEAN",
"value" : true
}],
"required" : true
},
{
"name" : "Competitor Influence",
"dataType" : "STRING",
"required" : false
}
],
"accessSequence" : [
{
"accessLevel" : [
{
"dimID" : "28484058-4ffc-329b-94ff-63e1ddbd7189",
"aspectID" : "fbd99ad0-1b92-3baf-8686-772a39e3d065"
},
{
"dimID" : "c689acc7-ee13-3482-aa7b-c6a13419431c",
"aspectID" : "85921462-8431-3951-97c0-558f7b5f8ffc"
}
]
},
{
"accessLevel" : [
{
"dimID" : "28484058-4ffc-329b-94ff-63e1ddbd7189",
"aspectID" : "fbd99ad0-1b92-3baf-8686-772a39e3d065"
},
{
"dimID" : "c689acc7-ee13-3482-aa7b-c6a13419431c",
"aspectID" : "2b848a8c-c886-3253-921a-77c43cd50aae"
}
]
}
]
}
Response:
HTTP/1.1
400
BAD REQUEST
{
"errorID": "HVS-003701",
"errorMessage": "\"cb2d8a2d-67e8-40c2-8884-1c77c5ddf251\" cannot be defined to support dynamic columns while also containing specific column configurations.",
"resourceType": "table",
"requestID": "8daf08ed-a989-4792-8453-dc51c4127af4"
}