Part Vendors

Part Vendors

Retrieve and manage vendor records linked to parts.

FieldData TypePOSTPATCH
PartIDStringXX
VendorIDStringXX
MFRIDStringXX
PrimaryBooleanXX
UnitCostDecimalXX
VendorPartIDStringXX
MFRPartIDStringXX
OEMBooleanXX
LeadTimeDecimalXX
UOPStringXX
QtyPerUOPDecimalXX
MinOrderQtyDecimalXX
MinimumOrderCostDecimalXX

Key: PartID, VendorID, MFRID

Endpoints

GET

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

Description: Retrieve vendor records linked to parts.

POST

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

Description: Create a part vendor record.

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

PATCH

URL: https://{site}.mvpplant.com/ODataApi/v1/PartVendors(PartID='partID',VendorID='vendorID',MFRID='mfrID')

Description: Update an existing part vendor 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/PartVendors?$select=PartID,VendorID,MFRID,UnitCost

  • Filter primary part vendors:
    https://{site}.mvpplant.com/ODataApi/v1/PartVendors?$filter=Primary eq true

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

Notes

  • Use the composite key PartID, VendorID, and MFRID to identify a part vendor record.