Update Column Data
PUT /ws/rest/service/v1/cost/columndata/{project_number}
Purpose
Update column data of all rows / lineitems of cost sheet for a given column name
Request Format
All parameters should be URL encoded.
Both input & output in JSON format in the body
Path Parameter
project_number(Required): Specify the project/shell number to update column data of project cost sheet
Query Parameter
columnname(Required): Specify the column name of cost sheet.
Response Format
A JSON object is returned in the following format.
{
"data": [],
"message": [],
"status": <REST status code value>
}
A successful response displays a status code 200.
A failed response displays a message with a status code.
Sample Request
{
"data": [
{
"wbs_code": "Code 1",
"short_description": "Code 1 Description",
"amount": "20.0",
"spends_category": "",
"quantity": "2.0",
"work_package": "",
"unit_of_measure": "each",
"unit_cost": "10.0",
"long_description": ""
},
{
"wbs_code": "Code 2",
"short_description": "Code 2 Description",
"amount": "90.0",
"spends_category": "",
"quantity": "3.0",
"work_package": "",
"unit_of_measure": "fl. oz",
"unit_cost": "30.0",
"long_description": ""
},
{
"wbs_code": "Code 3",
"short_description": "Code 3 Description",
"amount": "160.0",
"spends_category": "",
"quantity": "4.0",
"work_package": "",
"unit_of_measure": "",
"unit_cost": "40.0",
"long_description": ""
},
{
"wbs_code": "Code 3",
"short_description": "Code 3 Description",
"amount": "250.0",
"spends_category": "",
"quantity": "5.0",
"work_package": "",
"unit_of_measure": "yd.",
"unit_cost": "50.0",
"long_description": ""
}
],
"message": [ "success" ],
"status": 200
}
Note: Data of all rows must be provided in the request; otherwise, their respective line items will be deleted and amounts of the rows which are not part of request will be reset to 0.
Sample Success Response
{
"data": [
{
"wbs_code": "Code 1",
"short_description": "Code 1 Description",
"amount": "20.0",
"spends_category": "",
"quantity": "2.0",
"work_package": "",
"unit_of_measure": "each",
"unit_cost": "10.0",
"long_description": ""
},
{
"wbs_code": "Code 2",
"short_description": "Code 2 Description",
"amount": "90.0",
"spends_category": "",
"quantity": "3.0",
"work_package": "",
"unit_of_measure": "fl. oz",
"unit_cost": "30.0",
"long_description": ""
},
{
"wbs_code": "Code 3",
"short_description": "Code 3 Description",
"amount": "160.0",
"spends_category": "",
"quantity": "4.0",
"work_package": "",
"unit_of_measure": "",
"unit_cost": "40.0",
"long_description": ""
},
{
"wbs_code": "Code 3",
"short_description": "Code 3 Description",
"amount": "250.0",
"spends_category": "",
"quantity": "5.0",
"work_package": "",
"unit_of_measure": "yd.",
"unit_cost": "50.0",
"long_description": ""
}
]
"message": [ "success" ],
"status": 200
}
Related Topics
Last Published Tuesday, July 1, 2025