Update Column Data

PUT /ws/rest/service/v1/cost/columndata/{project_number}

Purpose:

Update column data of all rows / lineitems of costsheet 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