Work Requests

Work Requests

Retrieve and manage work request records.

FieldData TypePOSTPATCH
WorkReqIDStringXX
AssetTypeStringXX
AssetIDStringXX
DescriptionStringXX
RequestedStartDateDateTimeXX
RequestedFinishDateDateTimeXX
RequestDateDateTimeXX
StatusStringXX
StateStringXX
AssetDownBooleanXX
DownReasonStringXX
AssignedToStringXX
PriorityStringXX
RequestedByStringXX
HoldReasonStringXX
RequestIDStringXX
TypeStringXX
ExpenseClassStringXX
NotesStringXX
CreatedByString
DateCreatedDateTime
EditedByString
DateEditedDateTime

Key: WorkReqID

Required property: WorkReqID

Endpoints

GET

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

Description: Retrieve work request records.

POST

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

Description: Create a work request record.

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

PATCH

URL: https://{site}.mvpplant.com/ODataApi/v1/WorkRequests('workReqID')

Description: Update an existing work request 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/WorkRequests?$select=WorkReqID,Description,Status,Priority

  • Filter open work requests:
    https://{site}.mvpplant.com/ODataApi/v1/WorkRequests?$filter=Status ne 'Completed'

  • Sort by request date:
    https://{site}.mvpplant.com/ODataApi/v1/WorkRequests?$orderby=RequestDate desc

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

Notes

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