get
https://{sitename}.mvpplant.com/ODataApi/v1/GetWorkOrderMaterial
Recent Requests
Log in to see full request history
| Time | Status | User Agent | |
|---|---|---|---|
Retrieving recent requests… | |||
Loading…
GET Work Order Material
Retrieve material cost records for work orders.
GET /ODataApi/v1/GetWorkOrderMaterialEndpoint
https://{sitename}.mvpplant.com/ODataApi/v1/GetWorkOrderMaterialReplace {sitename} with your MVP One site name.
Available fields
| Field | Data type | Description |
|---|---|---|
WorkOrderID | String | Identifier of the work order associated with the material cost. |
Description | String | Description of the material cost. |
Date | DateTimeOffset | Date and time of the material transaction. |
Material | String | Material identifier or material description. |
Quantity | Decimal(9,3) | Quantity of material used. |
TotalCost | Decimal(18,3) | Total material cost applied to the work order. |
CreatedBy | String | User who created the material cost record. |
DateCreated | DateTimeOffset | Date and time the material cost record was created. |
Example endpoint
GET https://company.mvpplant.com/ODataApi/v1/GetWorkOrderMaterialOptional OData query examples
Return material costs for one work order
GET https://{sitename}.mvpplant.com/ODataApi/v1/GetWorkOrderMaterial?$filter=WorkOrderID eq 'WO-1001'Return selected fields
GET https://{sitename}.mvpplant.com/ODataApi/v1/GetWorkOrderMaterial?$select=WorkOrderID,Material,Quantity,TotalCost,DateReturn the first 10 material cost records
GET https://{sitename}.mvpplant.com/ODataApi/v1/GetWorkOrderMaterial?$top=10Sort material costs by date
GET https://{sitename}.mvpplant.com/ODataApi/v1/GetWorkOrderMaterial?$orderby=Date descNotes
- Use single quotes around string values in
$filterexpressions. - OData filter values are case-sensitive.
- Use
$selectto return only the fields your application needs. QuantityusesDecimal(9,3)precision.TotalCostusesDecimal(18,3)precision.