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