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

Cost

Get CBS Codes

Create CBS Codes

Update CBS Codes

Get Column Data

Sort Cost Sheet



Last Published Tuesday, July 1, 2025