Get Column Data
GET /ws/rest/service/v1/cost/columndata/{project_number}
Purpose
Get 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 get 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 Success Response
{
"data": [
{
"wbs_code": "Cost Code 1",
"short_description": "Direct Entry Line Item",
"amount": "1000.0",
"spends_category": "",
"quantity": "10.0",
"work_package": "",
"unit_of_measure": "each",
"unit_cost": "100.0",
"long_description": ""
},
{
"wbs_code": "Cost Code 2",
"short_description": "Direct Entry Line Item",
"amount": "100.0",
"spends_category": "",
"quantity": "10.0",
"work_package": "",
"unit_of_measure": "",
"unit_cost": "10.0",
"long_description": ""
}
],
"message": [ "success" ],
"status": 200
}
Related Topics
Last Published Tuesday, July 1, 2025