Work Requests

Retrieve and manage work request records.

Field	Data Type	POST	PATCH
WorkReqID	String	X	X
AssetType	String	X	X
AssetID	String	X	X
Description	String	X	X
RequestedStartDate	DateTime	X	X
RequestedFinishDate	DateTime	X	X
RequestDate	DateTime	X	X
Status	String	X	X
State	String	X	X
AssetDown	Boolean	X	X
DownReason	String	X	X
AssignedTo	String	X	X
Priority	String	X	X
RequestedBy	String	X	X
HoldReason	String	X	X
RequestID	String	X	X
Type	String	X	X
ExpenseClass	String	X	X
Notes	String	X	X
CreatedBy	String
DateCreated	DateTime
EditedBy	String
DateEdited	DateTime

Key: WorkReqID

Required property: WorkReqID

Endpoints

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

Description: Retrieve work request records.

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

Description: Create a work request record.

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

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.

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

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