Parts

Parts

Retrieve and manage part master records.

FieldData TypePOSTPATCH
PartIDStringXX
DescriptionStringXX
TypeStringXX
UOMStringXX
WeightDecimalXX
UOWStringXX
MFRIDStringXX
StockStringXX
ModelStringXX
UNSPSCCodeStringXX
PartClassStringXX
BalanceAccountStringXX
ExpenseAccountStringXX
WriteOffAccountStringXX
SingleSourceBooleanXX
NotesStringXX
SpecificationsStringXX
IsActiveBooleanXX
CreatedByString
DateCreatedDateTime
EditedByString
DateEditedDateTime

Key: PartID

Required property: PartID

Endpoints

GET

URL: https://{site}.mvpplant.com/ODataApi/v1/Parts

Description: Retrieve part master records.

POST

URL: https://{site}.mvpplant.com/ODataApi/v1/Parts

Description: Create a part record.

Body: Send the property values marked in the POST column.

PATCH

URL: https://{site}.mvpplant.com/ODataApi/v1/Parts('partID')

Description: Update an existing part record.

Body: Send only the property values you want to update from the PATCH column.

OData Query Examples

  • Select specific fields:
    https://{site}.mvpplant.com/ODataApi/v1/Parts?$select=PartID,Description,Type

  • Filter active parts:
    https://{site}.mvpplant.com/ODataApi/v1/Parts?$filter=IsActive eq true

  • Sort by part ID:
    https://{site}.mvpplant.com/ODataApi/v1/Parts?$orderby=PartID

  • Return the first 10 records:
    https://{site}.mvpplant.com/ODataApi/v1/Parts?$top=10

Notes

  • CreatedBy, DateCreated, EditedBy, and DateEdited are system-generated fields.
  • Use PartID as the key field for part records.