API Catalog

Retrieve Work Orders By Code

01 Oct 2025
12 Minutes to read

Print
Dark
Light

Retrieve Work Orders By Code

Updated on 01 Oct 2025
12 Minutes to read

Print
Dark
Light

Article summary

Did you find this summary helpful?

Thank you for your feedback!

Get

/prm-rest-api/rest/1/workorder

Query Standards

Finder

Following row finders are available for data filtering and optimizing request performance.

Select By Code
Select By Date
By UUID

Select By Code

Recommended finder parameters. Refer to Query Parameters for example.

Parameter	Description	Sample
WorkOrderCode	Work Order Code	WO.00030
CompCode	Company Code	001

Select By Date

This is an optional finder for querying Work Orders by Audit Date.

Parameter	Description	Sample
AuditDate	Create or Update Date Time Filter	2015-06-01

By UUID

This is an optional finder for querying a specific Work Order by row ID.

Parameter	Description	Sample
/VUUID	The VUuid attribute is the Unique row ID	/prm-rest-api/rest/1/workorder/D21723A19CE95650E05316821FACB6B7

Security

HTTP

Type basic

Basic authentication

Query parameters

finder

string

ExampleselectByCode;WorkOrderCode=WO.00030, CompCode=001

limit

integer

Example500

offset

integer

Example0

totalResults

boolean

Exampletrue

orderBy

string

ExampleWoVUuid:desc

Responses

200

Headers

Content-Type

string

Exampleapplication/vnd.oracle.adf.resourcecollection+json

example-0

Successful Response - Finder - selectByDate

{
  "items": [
    {
      "WoCompCode": "001",
      "WoCompName": "CMiC Construction Inc",
      "WoCode": "WO.18",
      "WoNumber": 18,
      "WoDescription": "Soil Removal",
      "WoType": "J",
      "WoCostingType": "T",
      "WoCostingTypeDesc": "Entered via transactions",
      "WoBillingType": "N",
      "WoBillingTypeDesc": "Not billed",
      "WoStatus": "C",
      "WoStatusDesc": "Closed",
      "WoShopWoFlag": null,
      "WoPriorityNumber": 3,
      "WoReceivedDateTime": "2015-10-30",
      "WoReceivedDate": "2015-10-30",
      "WoReceivedTime": "2025-10-01",
      "WoReqStartDateTime": null,
      "WoReqEndDateTime": null,
      "WoDispatchedDateTime": null,
      "WoStartDateTime": null,
      "WoCompletionDateTime": null,
      "WoComments": null,
      "WoClass1": null,
      "WoClass2": null,
      "WoClass3": null,
      "WoClass4": null,
      "WoNormalBillRate": null,
      "WoOtBillRate": null,
      "WoDotBillRate": null,
      "WoPrintCounter": 0,
      "WoMteamCode": null,
      "WoCreatedBy": "ADWAIT",
      "WoDateCreated": "2015-10-30T15:04:03Z",
      "WoModifiedBy": "ADWAIT",
      "WoDateModified": "2016-03-09T21:53:55Z",
      "WoTranType": "J",
      "WoCostCompCode": "001",
      "WoCostCompName": "CMiC Construction Inc",
      "WoCostDeptCode": "080",
      "WoCostDeptName": "Support Services",
      "WoVendorCode": null,
      "WoTitle": "Soil Removal",
      "WoDeptCode": "080",
      "WoCostJobCode": "WO.18",
      "WoCustCode": "KAISER",
      "WoCustName": "Kaiser Permanente",
      "WoBillAmt": null,
      "WoBillAmtFrmtd": null,
      "WoAppTypeCode": "CRM",
      "WoIssueId": null,
      "WoDmLocCode": null,
      "WoDmLocName": null,
      "WoJobBidFlag": "N",
      "WoProjCode": null,
      "WoProjName": null,
      "WoProjJobCode": null,
      "WoBillingRateTableCode": "WORKORDERS",
      "WoInvoiceFormat": "WO",
      "WoInvoiceFormatName": "Work Order Billing (Grp1 - Freeform)",
      "WoEntry2Flag": "N",
      "WoTax1Code": null,
      "WoTax2Code": null,
      "WoTax3Code": null,
      "WoFfPoNum": null,
      "WoAddrCode": null,
      "WoAddrTypeCode": null,
      "WoVUuid": "D21723A19CE45650E05316821FACB6B7",
      "WoIuCreateDate": "2015-10-30T15:04:03Z",
      "WoIuUpdateDate": "2016-03-09T21:53:55Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder/D21723A19CE45650E05316821FACB6B7",
          "name": "workorder",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder/D21723A19CE45650E05316821FACB6B7",
          "name": "workorder",
          "kind": "item"
        }
      ]
    },
    {
      "WoCompCode": "001",
      "WoCompName": "CMiC Construction Inc",
      "WoCode": "WO.20",
      "WoNumber": 20,
      "WoDescription": "Replace tiles in front lobby.",
      "WoType": "J",
      "WoCostingType": "T",
      "WoCostingTypeDesc": "Entered via transactions",
      "WoBillingType": "N",
      "WoBillingTypeDesc": "Not billed",
      "WoStatus": "C",
      "WoStatusDesc": "Closed",
      "WoShopWoFlag": null,
      "WoPriorityNumber": 3,
      "WoReceivedDateTime": "2015-11-09",
      "WoReceivedDate": "2015-11-09",
      "WoReceivedTime": "2025-10-01",
      "WoReqStartDateTime": null,
      "WoReqEndDateTime": null,
      "WoDispatchedDateTime": null,
      "WoStartDateTime": null,
      "WoCompletionDateTime": null,
      "WoComments": null,
      "WoClass1": null,
      "WoClass2": null,
      "WoClass3": null,
      "WoClass4": null,
      "WoNormalBillRate": null,
      "WoOtBillRate": null,
      "WoDotBillRate": null,
      "WoPrintCounter": 0,
      "WoMteamCode": null,
      "WoCreatedBy": "BILL",
      "WoDateCreated": "2015-11-12T18:18:38Z",
      "WoModifiedBy": "ADWAIT",
      "WoDateModified": "2016-03-09T21:54:17Z",
      "WoTranType": "J",
      "WoCostCompCode": "001",
      "WoCostCompName": "CMiC Construction Inc",
      "WoCostDeptCode": "080",
      "WoCostDeptName": "Support Services",
      "WoVendorCode": null,
      "WoTitle": "Replace tiles in front lobby.",
      "WoDeptCode": "080",
      "WoCostJobCode": "WO.20",
      "WoCustCode": "KAISER",
      "WoCustName": "Kaiser Permanente",
      "WoBillAmt": null,
      "WoBillAmtFrmtd": null,
      "WoAppTypeCode": "CRM",
      "WoIssueId": null,
      "WoDmLocCode": null,
      "WoDmLocName": null,
      "WoJobBidFlag": "N",
      "WoProjCode": null,
      "WoProjName": null,
      "WoProjJobCode": null,
      "WoBillingRateTableCode": "WORKORDERS",
      "WoInvoiceFormat": "WO",
      "WoInvoiceFormatName": "Work Order Billing (Grp1 - Freeform)",
      "WoEntry2Flag": "N",
      "WoTax1Code": null,
      "WoTax2Code": null,
      "WoTax3Code": null,
      "WoFfPoNum": null,
      "WoAddrCode": null,
      "WoAddrTypeCode": null,
      "WoVUuid": "D21723A19CE55650E05316821FACB6B7",
      "WoIuCreateDate": "2015-11-12T18:18:38Z",
      "WoIuUpdateDate": "2016-03-09T21:54:17Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder/D21723A19CE55650E05316821FACB6B7",
          "name": "workorder",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder/D21723A19CE55650E05316821FACB6B7",
          "name": "workorder",
          "kind": "item"
        }
      ]
    },
    {
      "WoCompCode": "001",
      "WoCompName": "CMiC Construction Inc",
      "WoCode": "WO.00030",
      "WoNumber": 30,
      "WoDescription": "Safety Line Repair",
      "WoType": "J",
      "WoCostingType": "T",
      "WoCostingTypeDesc": "Entered via transactions",
      "WoBillingType": "N",
      "WoBillingTypeDesc": "Not billed",
      "WoStatus": "C",
      "WoStatusDesc": "Closed",
      "WoShopWoFlag": null,
      "WoPriorityNumber": 3,
      "WoReceivedDateTime": "2016-02-05",
      "WoReceivedDate": "2016-02-05",
      "WoReceivedTime": "2025-10-01",
      "WoReqStartDateTime": null,
      "WoReqEndDateTime": null,
      "WoDispatchedDateTime": null,
      "WoStartDateTime": null,
      "WoCompletionDateTime": null,
      "WoComments": null,
      "WoClass1": null,
      "WoClass2": null,
      "WoClass3": null,
      "WoClass4": null,
      "WoNormalBillRate": null,
      "WoOtBillRate": null,
      "WoDotBillRate": null,
      "WoPrintCounter": 0,
      "WoMteamCode": null,
      "WoCreatedBy": "ADWAIT",
      "WoDateCreated": "2016-02-05T16:04:39Z",
      "WoModifiedBy": "ADWAIT",
      "WoDateModified": "2017-01-30T19:15:03Z",
      "WoTranType": "J",
      "WoCostCompCode": "001",
      "WoCostCompName": "CMiC Construction Inc",
      "WoCostDeptCode": "080",
      "WoCostDeptName": "Support Services",
      "WoVendorCode": null,
      "WoTitle": "Safety Line Repair",
      "WoDeptCode": "080",
      "WoCostJobCode": "WO.00030",
      "WoCustCode": "KAISER",
      "WoCustName": "Kaiser Permanente",
      "WoBillAmt": null,
      "WoBillAmtFrmtd": null,
      "WoAppTypeCode": "CRM",
      "WoIssueId": null,
      "WoDmLocCode": null,
      "WoDmLocName": null,
      "WoJobBidFlag": "N",
      "WoProjCode": null,
      "WoProjName": null,
      "WoProjJobCode": null,
      "WoBillingRateTableCode": "WORKORDERS",
      "WoInvoiceFormat": "WO",
      "WoInvoiceFormatName": "Work Order Billing (Grp1 - Freeform)",
      "WoEntry2Flag": "N",
      "WoTax1Code": null,
      "WoTax2Code": null,
      "WoTax3Code": null,
      "WoFfPoNum": null,
      "WoAddrCode": null,
      "WoAddrTypeCode": null,
      "WoVUuid": "D21723A19CE95650E05316821FACB6B7",
      "WoIuCreateDate": "2016-02-05T16:04:39Z",
      "WoIuUpdateDate": "2017-01-30T19:15:03Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder/D21723A19CE95650E05316821FACB6B7",
          "name": "workorder",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder/D21723A19CE95650E05316821FACB6B7",
          "name": "workorder",
          "kind": "item"
        }
      ]
    },
    {
      "WoCompCode": "001",
      "WoCompName": "CMiC Construction Inc",
      "WoCode": "WO.00034",
      "WoNumber": 34,
      "WoDescription": "Fix Broken Window - Room 1A",
      "WoType": "J",
      "WoCostingType": "T",
      "WoCostingTypeDesc": "Entered via transactions",
      "WoBillingType": "N",
      "WoBillingTypeDesc": "Not billed",
      "WoStatus": "C",
      "WoStatusDesc": "Closed",
      "WoShopWoFlag": null,
      "WoPriorityNumber": 3,
      "WoReceivedDateTime": "2016-02-01",
      "WoReceivedDate": "2016-02-01",
      "WoReceivedTime": "2025-10-01",
      "WoReqStartDateTime": null,
      "WoReqEndDateTime": null,
      "WoDispatchedDateTime": null,
      "WoStartDateTime": null,
      "WoCompletionDateTime": null,
      "WoComments": null,
      "WoClass1": null,
      "WoClass2": null,
      "WoClass3": null,
      "WoClass4": null,
      "WoNormalBillRate": null,
      "WoOtBillRate": null,
      "WoDotBillRate": null,
      "WoPrintCounter": 0,
      "WoMteamCode": null,
      "WoCreatedBy": "ADWAIT",
      "WoDateCreated": "2016-02-25T14:15:26Z",
      "WoModifiedBy": "ADWAIT",
      "WoDateModified": "2017-01-30T19:15:03Z",
      "WoTranType": "J",
      "WoCostCompCode": "001",
      "WoCostCompName": "CMiC Construction Inc",
      "WoCostDeptCode": "080",
      "WoCostDeptName": "Support Services",
      "WoVendorCode": null,
      "WoTitle": "Fix Broken Window - Room 1A",
      "WoDeptCode": "080",
      "WoCostJobCode": "WO.00034",
      "WoCustCode": "KAISER",
      "WoCustName": "Kaiser Permanente",
      "WoBillAmt": null,
      "WoBillAmtFrmtd": null,
      "WoAppTypeCode": "CRM",
      "WoIssueId": null,
      "WoDmLocCode": null,
      "WoDmLocName": null,
      "WoJobBidFlag": "N",
      "WoProjCode": null,
      "WoProjName": null,
      "WoProjJobCode": null,
      "WoBillingRateTableCode": "WORKORDERS",
      "WoInvoiceFormat": "WO",
      "WoInvoiceFormatName": "Work Order Billing (Grp1 - Freeform)",
      "WoEntry2Flag": "N",
      "WoTax1Code": null,
      "WoTax2Code": null,
      "WoTax3Code": null,
      "WoFfPoNum": null,
      "WoAddrCode": null,
      "WoAddrTypeCode": null,
      "WoVUuid": "D21723A19CEB5650E05316821FACB6B7",
      "WoIuCreateDate": "2016-02-25T14:15:26Z",
      "WoIuUpdateDate": "2017-01-30T19:15:03Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder/D21723A19CEB5650E05316821FACB6B7",
          "name": "workorder",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder/D21723A19CEB5650E05316821FACB6B7",
          "name": "workorder",
          "kind": "item"
        }
      ]
    },
    {
      "WoCompCode": "001",
      "WoCompName": "CMiC Construction Inc",
      "WoCode": "WO.00036",
      "WoNumber": 36,
      "WoDescription": "Enviromental Dig",
      "WoType": "J",
      "WoCostingType": "T",
      "WoCostingTypeDesc": "Entered via transactions",
      "WoBillingType": "N",
      "WoBillingTypeDesc": "Not billed",
      "WoStatus": "C",
      "WoStatusDesc": "Closed",
      "WoShopWoFlag": null,
      "WoPriorityNumber": 3,
      "WoReceivedDateTime": "2016-02-29",
      "WoReceivedDate": "2016-02-29",
      "WoReceivedTime": "2025-10-01",
      "WoReqStartDateTime": null,
      "WoReqEndDateTime": null,
      "WoDispatchedDateTime": null,
      "WoStartDateTime": null,
      "WoCompletionDateTime": null,
      "WoComments": null,
      "WoClass1": null,
      "WoClass2": null,
      "WoClass3": null,
      "WoClass4": null,
      "WoNormalBillRate": null,
      "WoOtBillRate": null,
      "WoDotBillRate": null,
      "WoPrintCounter": 0,
      "WoMteamCode": null,
      "WoCreatedBy": "ADWAIT",
      "WoDateCreated": "2016-02-29T20:25:18Z",
      "WoModifiedBy": "ADWAIT",
      "WoDateModified": "2017-01-30T19:15:03Z",
      "WoTranType": "J",
      "WoCostCompCode": "001",
      "WoCostCompName": "CMiC Construction Inc",
      "WoCostDeptCode": "080",
      "WoCostDeptName": "Support Services",
      "WoVendorCode": null,
      "WoTitle": "Enviromental Dig",
      "WoDeptCode": "080",
      "WoCostJobCode": "WO.00036",
      "WoCustCode": "KAISER",
      "WoCustName": "Kaiser Permanente",
      "WoBillAmt": null,
      "WoBillAmtFrmtd": null,
      "WoAppTypeCode": "CRM",
      "WoIssueId": null,
      "WoDmLocCode": null,
      "WoDmLocName": null,
      "WoJobBidFlag": "N",
      "WoProjCode": null,
      "WoProjName": null,
      "WoProjJobCode": null,
      "WoBillingRateTableCode": "WORKORDERS",
      "WoInvoiceFormat": "WO",
      "WoInvoiceFormatName": "Work Order Billing (Grp1 - Freeform)",
      "WoEntry2Flag": "N",
      "WoTax1Code": null,
      "WoTax2Code": null,
      "WoTax3Code": null,
      "WoFfPoNum": null,
      "WoAddrCode": null,
      "WoAddrTypeCode": null,
      "WoVUuid": "D21723A19CEC5650E05316821FACB6B7",
      "WoIuCreateDate": "2016-02-29T20:25:18Z",
      "WoIuUpdateDate": "2017-01-30T19:15:03Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder/D21723A19CEC5650E05316821FACB6B7",
          "name": "workorder",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder/D21723A19CEC5650E05316821FACB6B7",
          "name": "workorder",
          "kind": "item"
        }
      ]
    }
  ],
  "count": 5,
  "hasMore": true,
  "limit": 5,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder",
      "name": "workorder",
      "kind": "collection"
    }
  ]
}

example-1

Successful Response - Finder - selectByCode

{
  "items": [
    {
      "WoCompCode": "001",
      "WoCompName": "CMiC Construction Inc",
      "WoCode": "WO.00030",
      "WoNumber": 30,
      "WoDescription": "Safety Line Repair",
      "WoType": "J",
      "WoCostingType": "T",
      "WoCostingTypeDesc": "Entered via transactions",
      "WoBillingType": "N",
      "WoBillingTypeDesc": "Not billed",
      "WoStatus": "C",
      "WoStatusDesc": "Closed",
      "WoShopWoFlag": null,
      "WoPriorityNumber": 3,
      "WoReceivedDateTime": "2016-02-05",
      "WoReceivedDate": "2016-02-05",
      "WoReceivedTime": "2025-10-01",
      "WoReqStartDateTime": null,
      "WoReqEndDateTime": null,
      "WoDispatchedDateTime": null,
      "WoStartDateTime": null,
      "WoCompletionDateTime": null,
      "WoComments": null,
      "WoClass1": null,
      "WoClass2": null,
      "WoClass3": null,
      "WoClass4": null,
      "WoNormalBillRate": null,
      "WoOtBillRate": null,
      "WoDotBillRate": null,
      "WoPrintCounter": 0,
      "WoMteamCode": null,
      "WoCreatedBy": "ADWAIT",
      "WoDateCreated": "2016-02-05T16:04:39Z",
      "WoModifiedBy": "ADWAIT",
      "WoDateModified": "2017-01-30T19:15:03Z",
      "WoTranType": "J",
      "WoCostCompCode": "001",
      "WoCostCompName": "CMiC Construction Inc",
      "WoCostDeptCode": "080",
      "WoCostDeptName": "Support Services",
      "WoVendorCode": null,
      "WoTitle": "Safety Line Repair",
      "WoDeptCode": "080",
      "WoCostJobCode": "WO.00030",
      "WoCustCode": "KAISER",
      "WoCustName": "Kaiser Permanente",
      "WoBillAmt": null,
      "WoBillAmtFrmtd": null,
      "WoAppTypeCode": "CRM",
      "WoIssueId": null,
      "WoDmLocCode": null,
      "WoDmLocName": null,
      "WoJobBidFlag": "N",
      "WoProjCode": null,
      "WoProjName": null,
      "WoProjJobCode": null,
      "WoBillingRateTableCode": "WORKORDERS",
      "WoInvoiceFormat": "WO",
      "WoInvoiceFormatName": "Work Order Billing (Grp1 - Freeform)",
      "WoEntry2Flag": "N",
      "WoTax1Code": null,
      "WoTax2Code": null,
      "WoTax3Code": null,
      "WoFfPoNum": null,
      "WoAddrCode": null,
      "WoAddrTypeCode": null,
      "WoVUuid": "D21723A19CE95650E05316821FACB6B7",
      "WoIuCreateDate": "2016-02-05T16:04:39Z",
      "WoIuUpdateDate": "2017-01-30T19:15:03Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder/D21723A19CE95650E05316821FACB6B7",
          "name": "workorder",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder/D21723A19CE95650E05316821FACB6B7",
          "name": "workorder",
          "kind": "item"
        }
      ]
    }
  ],
  "count": 1,
  "hasMore": false,
  "limit": 5,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder",
      "name": "workorder",
      "kind": "collection"
    }
  ]
}

example-2

Successful Response - Finder - selectByCode

{
  "items": [
    {
      "WoCompCode": "001",
      "WoCompName": "CMiC Construction Inc",
      "WoCode": "WO.00030",
      "WoNumber": 30,
      "WoDescription": "Safety Line Repair",
      "WoType": "J",
      "WoCostingType": "T",
      "WoCostingTypeDesc": "Entered via transactions",
      "WoBillingType": "N",
      "WoBillingTypeDesc": "Not billed",
      "WoStatus": "C",
      "WoStatusDesc": "Closed",
      "WoShopWoFlag": null,
      "WoPriorityNumber": 3,
      "WoReceivedDateTime": "2016-02-05",
      "WoReceivedDate": "2016-02-05",
      "WoReceivedTime": "2025-10-01",
      "WoReqStartDateTime": null,
      "WoReqEndDateTime": null,
      "WoDispatchedDateTime": null,
      "WoStartDateTime": null,
      "WoCompletionDateTime": null,
      "WoComments": null,
      "WoClass1": null,
      "WoClass2": null,
      "WoClass3": null,
      "WoClass4": null,
      "WoNormalBillRate": null,
      "WoOtBillRate": null,
      "WoDotBillRate": null,
      "WoPrintCounter": 0,
      "WoMteamCode": null,
      "WoCreatedBy": "ADWAIT",
      "WoDateCreated": "2016-02-05T16:04:39Z",
      "WoModifiedBy": "ADWAIT",
      "WoDateModified": "2017-01-30T19:15:03Z",
      "WoTranType": "J",
      "WoCostCompCode": "001",
      "WoCostCompName": "CMiC Construction Inc",
      "WoCostDeptCode": "080",
      "WoCostDeptName": "Support Services",
      "WoVendorCode": null,
      "WoTitle": "Safety Line Repair",
      "WoDeptCode": "080",
      "WoCostJobCode": "WO.00030",
      "WoCustCode": "KAISER",
      "WoCustName": "Kaiser Permanente",
      "WoBillAmt": null,
      "WoBillAmtFrmtd": null,
      "WoAppTypeCode": "CRM",
      "WoIssueId": null,
      "WoDmLocCode": null,
      "WoDmLocName": null,
      "WoJobBidFlag": "N",
      "WoProjCode": null,
      "WoProjName": null,
      "WoProjJobCode": null,
      "WoBillingRateTableCode": "WORKORDERS",
      "WoInvoiceFormat": "WO",
      "WoInvoiceFormatName": "Work Order Billing (Grp1 - Freeform)",
      "WoEntry2Flag": "N",
      "WoTax1Code": null,
      "WoTax2Code": null,
      "WoTax3Code": null,
      "WoFfPoNum": null,
      "WoAddrCode": null,
      "WoAddrTypeCode": null,
      "WoVUuid": "D21723A19CE95650E05316821FACB6B7",
      "WoIuCreateDate": "2016-02-05T16:04:39Z",
      "WoIuUpdateDate": "2017-01-30T19:15:03Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder/D21723A19CE95650E05316821FACB6B7",
          "name": "workorder",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder/D21723A19CE95650E05316821FACB6B7",
          "name": "workorder",
          "kind": "item"
        }
      ]
    }
  ],
  "count": 1,
  "hasMore": false,
  "limit": 5,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder",
      "name": "workorder",
      "kind": "collection"
    }
  ]
}

example-3

Successful Response - Finder - selectByDate

{
  "items": [
    {
      "WoCompCode": "001",
      "WoCompName": "CMiC Construction Inc",
      "WoCode": "WO.18",
      "WoNumber": 18,
      "WoDescription": "Soil Removal",
      "WoType": "J",
      "WoCostingType": "T",
      "WoCostingTypeDesc": "Entered via transactions",
      "WoBillingType": "N",
      "WoBillingTypeDesc": "Not billed",
      "WoStatus": "C",
      "WoStatusDesc": "Closed",
      "WoShopWoFlag": null,
      "WoPriorityNumber": 3,
      "WoReceivedDateTime": "2015-10-30",
      "WoReceivedDate": "2015-10-30",
      "WoReceivedTime": "2025-10-01",
      "WoReqStartDateTime": null,
      "WoReqEndDateTime": null,
      "WoDispatchedDateTime": null,
      "WoStartDateTime": null,
      "WoCompletionDateTime": null,
      "WoComments": null,
      "WoClass1": null,
      "WoClass2": null,
      "WoClass3": null,
      "WoClass4": null,
      "WoNormalBillRate": null,
      "WoOtBillRate": null,
      "WoDotBillRate": null,
      "WoPrintCounter": 0,
      "WoMteamCode": null,
      "WoCreatedBy": "ADWAIT",
      "WoDateCreated": "2015-10-30T15:04:03Z",
      "WoModifiedBy": "ADWAIT",
      "WoDateModified": "2016-03-09T21:53:55Z",
      "WoTranType": "J",
      "WoCostCompCode": "001",
      "WoCostCompName": "CMiC Construction Inc",
      "WoCostDeptCode": "080",
      "WoCostDeptName": "Support Services",
      "WoVendorCode": null,
      "WoTitle": "Soil Removal",
      "WoDeptCode": "080",
      "WoCostJobCode": "WO.18",
      "WoCustCode": "KAISER",
      "WoCustName": "Kaiser Permanente",
      "WoBillAmt": null,
      "WoBillAmtFrmtd": null,
      "WoAppTypeCode": "CRM",
      "WoIssueId": null,
      "WoDmLocCode": null,
      "WoDmLocName": null,
      "WoJobBidFlag": "N",
      "WoProjCode": null,
      "WoProjName": null,
      "WoProjJobCode": null,
      "WoBillingRateTableCode": "WORKORDERS",
      "WoInvoiceFormat": "WO",
      "WoInvoiceFormatName": "Work Order Billing (Grp1 - Freeform)",
      "WoEntry2Flag": "N",
      "WoTax1Code": null,
      "WoTax2Code": null,
      "WoTax3Code": null,
      "WoFfPoNum": null,
      "WoAddrCode": null,
      "WoAddrTypeCode": null,
      "WoVUuid": "D21723A19CE45650E05316821FACB6B7",
      "WoIuCreateDate": "2015-10-30T15:04:03Z",
      "WoIuUpdateDate": "2016-03-09T21:53:55Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder/D21723A19CE45650E05316821FACB6B7",
          "name": "workorder",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder/D21723A19CE45650E05316821FACB6B7",
          "name": "workorder",
          "kind": "item"
        }
      ]
    },
    {
      "WoCompCode": "001",
      "WoCompName": "CMiC Construction Inc",
      "WoCode": "WO.20",
      "WoNumber": 20,
      "WoDescription": "Replace tiles in front lobby.",
      "WoType": "J",
      "WoCostingType": "T",
      "WoCostingTypeDesc": "Entered via transactions",
      "WoBillingType": "N",
      "WoBillingTypeDesc": "Not billed",
      "WoStatus": "C",
      "WoStatusDesc": "Closed",
      "WoShopWoFlag": null,
      "WoPriorityNumber": 3,
      "WoReceivedDateTime": "2015-11-09",
      "WoReceivedDate": "2015-11-09",
      "WoReceivedTime": "2025-10-01",
      "WoReqStartDateTime": null,
      "WoReqEndDateTime": null,
      "WoDispatchedDateTime": null,
      "WoStartDateTime": null,
      "WoCompletionDateTime": null,
      "WoComments": null,
      "WoClass1": null,
      "WoClass2": null,
      "WoClass3": null,
      "WoClass4": null,
      "WoNormalBillRate": null,
      "WoOtBillRate": null,
      "WoDotBillRate": null,
      "WoPrintCounter": 0,
      "WoMteamCode": null,
      "WoCreatedBy": "BILL",
      "WoDateCreated": "2015-11-12T18:18:38Z",
      "WoModifiedBy": "ADWAIT",
      "WoDateModified": "2016-03-09T21:54:17Z",
      "WoTranType": "J",
      "WoCostCompCode": "001",
      "WoCostCompName": "CMiC Construction Inc",
      "WoCostDeptCode": "080",
      "WoCostDeptName": "Support Services",
      "WoVendorCode": null,
      "WoTitle": "Replace tiles in front lobby.",
      "WoDeptCode": "080",
      "WoCostJobCode": "WO.20",
      "WoCustCode": "KAISER",
      "WoCustName": "Kaiser Permanente",
      "WoBillAmt": null,
      "WoBillAmtFrmtd": null,
      "WoAppTypeCode": "CRM",
      "WoIssueId": null,
      "WoDmLocCode": null,
      "WoDmLocName": null,
      "WoJobBidFlag": "N",
      "WoProjCode": null,
      "WoProjName": null,
      "WoProjJobCode": null,
      "WoBillingRateTableCode": "WORKORDERS",
      "WoInvoiceFormat": "WO",
      "WoInvoiceFormatName": "Work Order Billing (Grp1 - Freeform)",
      "WoEntry2Flag": "N",
      "WoTax1Code": null,
      "WoTax2Code": null,
      "WoTax3Code": null,
      "WoFfPoNum": null,
      "WoAddrCode": null,
      "WoAddrTypeCode": null,
      "WoVUuid": "D21723A19CE55650E05316821FACB6B7",
      "WoIuCreateDate": "2015-11-12T18:18:38Z",
      "WoIuUpdateDate": "2016-03-09T21:54:17Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder/D21723A19CE55650E05316821FACB6B7",
          "name": "workorder",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder/D21723A19CE55650E05316821FACB6B7",
          "name": "workorder",
          "kind": "item"
        }
      ]
    },
    {
      "WoCompCode": "001",
      "WoCompName": "CMiC Construction Inc",
      "WoCode": "WO.00030",
      "WoNumber": 30,
      "WoDescription": "Safety Line Repair",
      "WoType": "J",
      "WoCostingType": "T",
      "WoCostingTypeDesc": "Entered via transactions",
      "WoBillingType": "N",
      "WoBillingTypeDesc": "Not billed",
      "WoStatus": "C",
      "WoStatusDesc": "Closed",
      "WoShopWoFlag": null,
      "WoPriorityNumber": 3,
      "WoReceivedDateTime": "2016-02-05",
      "WoReceivedDate": "2016-02-05",
      "WoReceivedTime": "2025-10-01",
      "WoReqStartDateTime": null,
      "WoReqEndDateTime": null,
      "WoDispatchedDateTime": null,
      "WoStartDateTime": null,
      "WoCompletionDateTime": null,
      "WoComments": null,
      "WoClass1": null,
      "WoClass2": null,
      "WoClass3": null,
      "WoClass4": null,
      "WoNormalBillRate": null,
      "WoOtBillRate": null,
      "WoDotBillRate": null,
      "WoPrintCounter": 0,
      "WoMteamCode": null,
      "WoCreatedBy": "ADWAIT",
      "WoDateCreated": "2016-02-05T16:04:39Z",
      "WoModifiedBy": "ADWAIT",
      "WoDateModified": "2017-01-30T19:15:03Z",
      "WoTranType": "J",
      "WoCostCompCode": "001",
      "WoCostCompName": "CMiC Construction Inc",
      "WoCostDeptCode": "080",
      "WoCostDeptName": "Support Services",
      "WoVendorCode": null,
      "WoTitle": "Safety Line Repair",
      "WoDeptCode": "080",
      "WoCostJobCode": "WO.00030",
      "WoCustCode": "KAISER",
      "WoCustName": "Kaiser Permanente",
      "WoBillAmt": null,
      "WoBillAmtFrmtd": null,
      "WoAppTypeCode": "CRM",
      "WoIssueId": null,
      "WoDmLocCode": null,
      "WoDmLocName": null,
      "WoJobBidFlag": "N",
      "WoProjCode": null,
      "WoProjName": null,
      "WoProjJobCode": null,
      "WoBillingRateTableCode": "WORKORDERS",
      "WoInvoiceFormat": "WO",
      "WoInvoiceFormatName": "Work Order Billing (Grp1 - Freeform)",
      "WoEntry2Flag": "N",
      "WoTax1Code": null,
      "WoTax2Code": null,
      "WoTax3Code": null,
      "WoFfPoNum": null,
      "WoAddrCode": null,
      "WoAddrTypeCode": null,
      "WoVUuid": "D21723A19CE95650E05316821FACB6B7",
      "WoIuCreateDate": "2016-02-05T16:04:39Z",
      "WoIuUpdateDate": "2017-01-30T19:15:03Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder/D21723A19CE95650E05316821FACB6B7",
          "name": "workorder",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder/D21723A19CE95650E05316821FACB6B7",
          "name": "workorder",
          "kind": "item"
        }
      ]
    },
    {
      "WoCompCode": "001",
      "WoCompName": "CMiC Construction Inc",
      "WoCode": "WO.00034",
      "WoNumber": 34,
      "WoDescription": "Fix Broken Window - Room 1A",
      "WoType": "J",
      "WoCostingType": "T",
      "WoCostingTypeDesc": "Entered via transactions",
      "WoBillingType": "N",
      "WoBillingTypeDesc": "Not billed",
      "WoStatus": "C",
      "WoStatusDesc": "Closed",
      "WoShopWoFlag": null,
      "WoPriorityNumber": 3,
      "WoReceivedDateTime": "2016-02-01",
      "WoReceivedDate": "2016-02-01",
      "WoReceivedTime": "2025-10-01",
      "WoReqStartDateTime": null,
      "WoReqEndDateTime": null,
      "WoDispatchedDateTime": null,
      "WoStartDateTime": null,
      "WoCompletionDateTime": null,
      "WoComments": null,
      "WoClass1": null,
      "WoClass2": null,
      "WoClass3": null,
      "WoClass4": null,
      "WoNormalBillRate": null,
      "WoOtBillRate": null,
      "WoDotBillRate": null,
      "WoPrintCounter": 0,
      "WoMteamCode": null,
      "WoCreatedBy": "ADWAIT",
      "WoDateCreated": "2016-02-25T14:15:26Z",
      "WoModifiedBy": "ADWAIT",
      "WoDateModified": "2017-01-30T19:15:03Z",
      "WoTranType": "J",
      "WoCostCompCode": "001",
      "WoCostCompName": "CMiC Construction Inc",
      "WoCostDeptCode": "080",
      "WoCostDeptName": "Support Services",
      "WoVendorCode": null,
      "WoTitle": "Fix Broken Window - Room 1A",
      "WoDeptCode": "080",
      "WoCostJobCode": "WO.00034",
      "WoCustCode": "KAISER",
      "WoCustName": "Kaiser Permanente",
      "WoBillAmt": null,
      "WoBillAmtFrmtd": null,
      "WoAppTypeCode": "CRM",
      "WoIssueId": null,
      "WoDmLocCode": null,
      "WoDmLocName": null,
      "WoJobBidFlag": "N",
      "WoProjCode": null,
      "WoProjName": null,
      "WoProjJobCode": null,
      "WoBillingRateTableCode": "WORKORDERS",
      "WoInvoiceFormat": "WO",
      "WoInvoiceFormatName": "Work Order Billing (Grp1 - Freeform)",
      "WoEntry2Flag": "N",
      "WoTax1Code": null,
      "WoTax2Code": null,
      "WoTax3Code": null,
      "WoFfPoNum": null,
      "WoAddrCode": null,
      "WoAddrTypeCode": null,
      "WoVUuid": "D21723A19CEB5650E05316821FACB6B7",
      "WoIuCreateDate": "2016-02-25T14:15:26Z",
      "WoIuUpdateDate": "2017-01-30T19:15:03Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder/D21723A19CEB5650E05316821FACB6B7",
          "name": "workorder",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder/D21723A19CEB5650E05316821FACB6B7",
          "name": "workorder",
          "kind": "item"
        }
      ]
    },
    {
      "WoCompCode": "001",
      "WoCompName": "CMiC Construction Inc",
      "WoCode": "WO.00036",
      "WoNumber": 36,
      "WoDescription": "Enviromental Dig",
      "WoType": "J",
      "WoCostingType": "T",
      "WoCostingTypeDesc": "Entered via transactions",
      "WoBillingType": "N",
      "WoBillingTypeDesc": "Not billed",
      "WoStatus": "C",
      "WoStatusDesc": "Closed",
      "WoShopWoFlag": null,
      "WoPriorityNumber": 3,
      "WoReceivedDateTime": "2016-02-29",
      "WoReceivedDate": "2016-02-29",
      "WoReceivedTime": "2025-10-01",
      "WoReqStartDateTime": null,
      "WoReqEndDateTime": null,
      "WoDispatchedDateTime": null,
      "WoStartDateTime": null,
      "WoCompletionDateTime": null,
      "WoComments": null,
      "WoClass1": null,
      "WoClass2": null,
      "WoClass3": null,
      "WoClass4": null,
      "WoNormalBillRate": null,
      "WoOtBillRate": null,
      "WoDotBillRate": null,
      "WoPrintCounter": 0,
      "WoMteamCode": null,
      "WoCreatedBy": "ADWAIT",
      "WoDateCreated": "2016-02-29T20:25:18Z",
      "WoModifiedBy": "ADWAIT",
      "WoDateModified": "2017-01-30T19:15:03Z",
      "WoTranType": "J",
      "WoCostCompCode": "001",
      "WoCostCompName": "CMiC Construction Inc",
      "WoCostDeptCode": "080",
      "WoCostDeptName": "Support Services",
      "WoVendorCode": null,
      "WoTitle": "Enviromental Dig",
      "WoDeptCode": "080",
      "WoCostJobCode": "WO.00036",
      "WoCustCode": "KAISER",
      "WoCustName": "Kaiser Permanente",
      "WoBillAmt": null,
      "WoBillAmtFrmtd": null,
      "WoAppTypeCode": "CRM",
      "WoIssueId": null,
      "WoDmLocCode": null,
      "WoDmLocName": null,
      "WoJobBidFlag": "N",
      "WoProjCode": null,
      "WoProjName": null,
      "WoProjJobCode": null,
      "WoBillingRateTableCode": "WORKORDERS",
      "WoInvoiceFormat": "WO",
      "WoInvoiceFormatName": "Work Order Billing (Grp1 - Freeform)",
      "WoEntry2Flag": "N",
      "WoTax1Code": null,
      "WoTax2Code": null,
      "WoTax3Code": null,
      "WoFfPoNum": null,
      "WoAddrCode": null,
      "WoAddrTypeCode": null,
      "WoVUuid": "D21723A19CEC5650E05316821FACB6B7",
      "WoIuCreateDate": "2016-02-29T20:25:18Z",
      "WoIuUpdateDate": "2017-01-30T19:15:03Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder/D21723A19CEC5650E05316821FACB6B7",
          "name": "workorder",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder/D21723A19CEC5650E05316821FACB6B7",
          "name": "workorder",
          "kind": "item"
        }
      ]
    }
  ],
  "count": 5,
  "hasMore": true,
  "limit": 5,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/workorder",
      "name": "workorder",
      "kind": "collection"
    }
  ]
}

object

What's Next

Retrieve a Specific Work Order By VUUID

Retrieve Work Orders By Code

Query Standards

Finder

Select By Code

Select By Date

By UUID

What's Next

Contact Us