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

Input:

All parameters should be URL encoded.

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.

Both input & output in JSON format in the body

Update Column Data input JSON

{

"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.

Output:

JSON object containing 'status', 'data', 'message'

Update Column Data output JSON

{

"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

}

Status codes are:

1> 200, for success

Related Topics