Updates the table with the given payload.
Everything is updated except for the name.
To update the table name use Rename Table.
Request Content |
json
|
Request Object | |
Response Content |
json
|
Response Object | |
Success Statuses |
200
OK
|
Error Statuses |
400
BAD REQUEST
|
Other Methods |
{ "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" } ] } ] }
{ "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" }
{ "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" } ] } ] }
{ "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" }
{ "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" } ] } ] }
{ "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" }