Retrieve PRM Work Items By Code
  • 27 Feb 2025
  • 6 Minutes to read
  • Dark
    Light

Retrieve PRM Work Items By Code

  • Dark
    Light

Article summary

Get
/prm-rest-api/rest/1/prmworkitem

Query Standards

Finder

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

  • Select By Date
  • By UUID

Select By Date

Recommended finder parameters. Refer to Query Parameters for example.

ParameterDescriptionSample
auditDateCreate or Update Date Time Filter2015-06-01

By UUID

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

ParameterDescriptionSample
/VUUIDThe VUuid attribute is the Unique row ID/prm-rest-api/rest/1/prmworkitem/D21729F91C7B5FB8E05316821FACAF93
Security
HTTP
Type basic

Basic authentication

Query parameters
finder
string
ExampleselectByDate; auditDate=2015-06-01
limit
integer
Example500
offset
integer
Example0
totalResults
boolean
ExampleTrue
orderBy
string
ExampleWitmVUuid:desc
Responses
200

OK

Headers
Content-Type
string
Exampleapplication/vnd.oracle.adf.resourcecollection+json
{
  "items": [
    {
      "WitmWorkItemType": "JB",
      "WitmTaskCode": null,
      "WitmTaskPtgtType": null,
      "WitmTgtType": "JB",
      "WitmWoCompCode": "001",
      "WitmWoCode": "WO.8",
      "WitmLineNumber": 1,
      "WitmWoStepTitle": "Repairing Drywall",
      "WitmWoStepDescription": "Repairing Drywall",
      "WitmDeadlineDate": "2015-09-15",
      "WitmThresholdDate": "2015-09-15",
      "WitmRecurringFlag": "0",
      "WitmDeadlineReading": null,
      "WitmMissedTaskCount": 0,
      "WitmAcumTypeCode": null,
      "WitmJcatLabCompCode": null,
      "WitmJcatLabJobCode": null,
      "WitmJcatLabPhsCode": null,
      "WitmJcatLabourCode": null,
      "WitmJcatPartsCompCode": null,
      "WitmJcatPartsJobCode": null,
      "WitmJcatPartsPhsCode": null,
      "WitmJcatPartsCode": null,
      "WitmJcatConCompCode": null,
      "WitmJcatConJobCode": null,
      "WitmJcatConPhsCode": null,
      "WitmJcatContractorCode": null,
      "WitmJcatEqCompCode": null,
      "WitmJcatEqJobCode": null,
      "WitmJcatEqPhsCode": null,
      "WitmJcatEquipmentCode": null,
      "WitmJcatOthCompCode": null,
      "WitmJcatOthJobCode": null,
      "WitmJcatOthPhsCode": null,
      "WitmJcatOtherCode": null,
      "WitmWiccCompCode": null,
      "WitmWiccLabourCode": null,
      "WitmWiccPartsCode": null,
      "WitmWiccContractorCode": null,
      "WitmWiccEquipmentCode": null,
      "WitmWiccOtherCode": null,
      "WitmStatus": "O",
      "WitmComments": null,
      "WitmCompletionDate": null,
      "WitmCompletionReading": null,
      "WitmNoticePrtCnt": null,
      "WitmClass1": null,
      "WitmClass2": null,
      "WitmClass3": null,
      "WitmClass4": null,
      "WitmVendorCode": null,
      "WitmScheduleDate": "2015-09-10",
      "WitmActiveFlag": null,
      "WitmTeamCode": null,
      "WitmBchNum": null,
      "WitmPostDate": null,
      "WitmSrcCompCode": "001",
      "WitmJobCode": "WO.8",
      "WitmPhsCode": "1",
      "WitmDeptCode": "080",
      "WitmPriority": 1,
      "WitmIssueId": null,
      "WitmDeliveryDate": null,
      "WitmAppTypeCode": "CRM",
      "WitmDateCreated": null,
      "WitmCreatedBy": null,
      "WitmDateModified": null,
      "WitmModifiedBy": null,
      "WitmScheduleEndDate": null,
      "WitmBillingType": "T",
      "WitmSubmittedBillingFlag": null,
      "WitmBillingAmt": null,
      "WitmBillingStateCode": "NR",
      "WitmChargeJobFlag": null,
      "WitmChargeCompCode": null,
      "WitmChargeJobCode": null,
      "WitmChargePhsCode": null,
      "WitmChargeCatCode": null,
      "WitmUnits": null,
      "WitmWoEntry2Flag": "N",
      "WitmBuildingCode": "101",
      "WitmFloorNo": "01",
      "WitmRoomNo": "101",
      "WitmUserField2": "WO.8",
      "WitmUserField3": "1",
      "WitmSelectFlag": "N",
      "WitmWoVUuid": "D21723A19CE15650E05316821FACB6B7",
      "WitmVUuid": "D21729F91C7B5FB8E05316821FACAF93",
      "WitmIuCreateDate": "2015-09-09T20:55:23Z",
      "WitmIuCreateUser": "ADWAIT",
      "WitmIuUpdateDate": null,
      "WitmIuUpdateUser": null,
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/prmworkitem/D21729F91C7B5FB8E05316821FACAF93",
          "name": "prmworkitem",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/prmworkitem/D21729F91C7B5FB8E05316821FACAF93",
          "name": "prmworkitem",
          "kind": "item"
        }
      ]
    },
    {
      "WitmWorkItemType": "JB",
      "WitmTaskCode": null,
      "WitmTaskPtgtType": null,
      "WitmTgtType": "JB",
      "WitmWoCompCode": "001",
      "WitmWoCode": "WO.00004",
      "WitmLineNumber": 1,
      "WitmWoStepTitle": "Damaged Drywall",
      "WitmWoStepDescription": "Damaged Drywall needs to be replaced because of water damage",
      "WitmDeadlineDate": "2015-07-21",
      "WitmThresholdDate": "2015-07-21",
      "WitmRecurringFlag": "0",
      "WitmDeadlineReading": null,
      "WitmMissedTaskCount": 0,
      "WitmAcumTypeCode": null,
      "WitmJcatLabCompCode": null,
      "WitmJcatLabJobCode": null,
      "WitmJcatLabPhsCode": null,
      "WitmJcatLabourCode": null,
      "WitmJcatPartsCompCode": null,
      "WitmJcatPartsJobCode": null,
      "WitmJcatPartsPhsCode": null,
      "WitmJcatPartsCode": null,
      "WitmJcatConCompCode": null,
      "WitmJcatConJobCode": null,
      "WitmJcatConPhsCode": null,
      "WitmJcatContractorCode": null,
      "WitmJcatEqCompCode": null,
      "WitmJcatEqJobCode": null,
      "WitmJcatEqPhsCode": null,
      "WitmJcatEquipmentCode": null,
      "WitmJcatOthCompCode": null,
      "WitmJcatOthJobCode": null,
      "WitmJcatOthPhsCode": null,
      "WitmJcatOtherCode": null,
      "WitmWiccCompCode": null,
      "WitmWiccLabourCode": null,
      "WitmWiccPartsCode": null,
      "WitmWiccContractorCode": null,
      "WitmWiccEquipmentCode": null,
      "WitmWiccOtherCode": null,
      "WitmStatus": "O",
      "WitmComments": null,
      "WitmCompletionDate": null,
      "WitmCompletionReading": null,
      "WitmNoticePrtCnt": null,
      "WitmClass1": null,
      "WitmClass2": null,
      "WitmClass3": null,
      "WitmClass4": null,
      "WitmVendorCode": null,
      "WitmScheduleDate": "2015-07-13",
      "WitmActiveFlag": null,
      "WitmTeamCode": null,
      "WitmBchNum": null,
      "WitmPostDate": null,
      "WitmSrcCompCode": "001",
      "WitmJobCode": "WO.00004",
      "WitmPhsCode": null,
      "WitmDeptCode": "080",
      "WitmPriority": 2,
      "WitmIssueId": null,
      "WitmDeliveryDate": null,
      "WitmAppTypeCode": "CRM",
      "WitmDateCreated": null,
      "WitmCreatedBy": null,
      "WitmDateModified": null,
      "WitmModifiedBy": null,
      "WitmScheduleEndDate": null,
      "WitmBillingType": "T",
      "WitmSubmittedBillingFlag": null,
      "WitmBillingAmt": null,
      "WitmBillingStateCode": "NR",
      "WitmChargeJobFlag": null,
      "WitmChargeCompCode": null,
      "WitmChargeJobCode": null,
      "WitmChargePhsCode": null,
      "WitmChargeCatCode": null,
      "WitmUnits": null,
      "WitmWoEntry2Flag": "N",
      "WitmBuildingCode": null,
      "WitmFloorNo": null,
      "WitmRoomNo": null,
      "WitmUserField2": "WO.00004",
      "WitmUserField3": null,
      "WitmSelectFlag": "N",
      "WitmWoVUuid": "D21723A19CE05650E05316821FACB6B7",
      "WitmVUuid": "D21729F91C7A5FB8E05316821FACAF93",
      "WitmIuCreateDate": "2015-07-09T13:26:43Z",
      "WitmIuCreateUser": "ADWAIT",
      "WitmIuUpdateDate": null,
      "WitmIuUpdateUser": null,
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/prmworkitem/D21729F91C7A5FB8E05316821FACAF93",
          "name": "prmworkitem",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/prmworkitem/D21729F91C7A5FB8E05316821FACAF93",
          "name": "prmworkitem",
          "kind": "item"
        }
      ]
    },
    {
      "WitmWorkItemType": "JB",
      "WitmTaskCode": null,
      "WitmTaskPtgtType": null,
      "WitmTgtType": "JB",
      "WitmWoCompCode": "001",
      "WitmWoCode": "WO.00003",
      "WitmLineNumber": 1,
      "WitmWoStepTitle": "Fixture of Window",
      "WitmWoStepDescription": "Fixture of Window",
      "WitmDeadlineDate": "2015-06-11",
      "WitmThresholdDate": "2015-06-11",
      "WitmRecurringFlag": "0",
      "WitmDeadlineReading": null,
      "WitmMissedTaskCount": 0,
      "WitmAcumTypeCode": null,
      "WitmJcatLabCompCode": null,
      "WitmJcatLabJobCode": null,
      "WitmJcatLabPhsCode": null,
      "WitmJcatLabourCode": null,
      "WitmJcatPartsCompCode": null,
      "WitmJcatPartsJobCode": null,
      "WitmJcatPartsPhsCode": null,
      "WitmJcatPartsCode": null,
      "WitmJcatConCompCode": null,
      "WitmJcatConJobCode": null,
      "WitmJcatConPhsCode": null,
      "WitmJcatContractorCode": null,
      "WitmJcatEqCompCode": null,
      "WitmJcatEqJobCode": null,
      "WitmJcatEqPhsCode": null,
      "WitmJcatEquipmentCode": null,
      "WitmJcatOthCompCode": null,
      "WitmJcatOthJobCode": null,
      "WitmJcatOthPhsCode": null,
      "WitmJcatOtherCode": null,
      "WitmWiccCompCode": null,
      "WitmWiccLabourCode": null,
      "WitmWiccPartsCode": null,
      "WitmWiccContractorCode": null,
      "WitmWiccEquipmentCode": null,
      "WitmWiccOtherCode": null,
      "WitmStatus": "O",
      "WitmComments": null,
      "WitmCompletionDate": null,
      "WitmCompletionReading": null,
      "WitmNoticePrtCnt": null,
      "WitmClass1": null,
      "WitmClass2": null,
      "WitmClass3": null,
      "WitmClass4": null,
      "WitmVendorCode": null,
      "WitmScheduleDate": "2015-06-08",
      "WitmActiveFlag": null,
      "WitmTeamCode": null,
      "WitmBchNum": null,
      "WitmPostDate": null,
      "WitmSrcCompCode": "001",
      "WitmJobCode": "WO.00003",
      "WitmPhsCode": null,
      "WitmDeptCode": "050",
      "WitmPriority": 2,
      "WitmIssueId": null,
      "WitmDeliveryDate": null,
      "WitmAppTypeCode": "CRM",
      "WitmDateCreated": null,
      "WitmCreatedBy": null,
      "WitmDateModified": "2015-08-30T23:27:00Z",
      "WitmModifiedBy": "BILL",
      "WitmScheduleEndDate": "2015-06-09",
      "WitmBillingType": "T",
      "WitmSubmittedBillingFlag": null,
      "WitmBillingAmt": 400,
      "WitmBillingStateCode": "SB",
      "WitmChargeJobFlag": null,
      "WitmChargeCompCode": null,
      "WitmChargeJobCode": null,
      "WitmChargePhsCode": null,
      "WitmChargeCatCode": null,
      "WitmUnits": null,
      "WitmWoEntry2Flag": "N",
      "WitmBuildingCode": "101",
      "WitmFloorNo": "01",
      "WitmRoomNo": "103",
      "WitmUserField2": "WO.00003",
      "WitmUserField3": null,
      "WitmSelectFlag": "N",
      "WitmWoVUuid": "D21723A19CF35650E05316821FACB6B7",
      "WitmVUuid": "D21729F91C845FB8E05316821FACAF93",
      "WitmIuCreateDate": "2015-06-04T17:39:58Z",
      "WitmIuCreateUser": "ADWAIT",
      "WitmIuUpdateDate": "2015-08-30T23:27:00Z",
      "WitmIuUpdateUser": "BILL",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/prmworkitem/D21729F91C845FB8E05316821FACAF93",
          "name": "prmworkitem",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/prmworkitem/D21729F91C845FB8E05316821FACAF93",
          "name": "prmworkitem",
          "kind": "item"
        }
      ]
    },
    {
      "WitmWorkItemType": "EQ",
      "WitmTaskCode": "01",
      "WitmTaskPtgtType": "CL",
      "WitmTgtType": "EQ",
      "WitmWoCompCode": "001",
      "WitmWoCode": "PWOYY.002",
      "WitmLineNumber": 2,
      "WitmWoStepTitle": "A 250 Hr Service",
      "WitmWoStepDescription": "CHG ENG OIL            GALS    15W40      BLUE       3.5 GAL           SAE 15W40             BLUE             3.5 GAL           INSPECT FOR LEAKS WHEN COMPLETED           REMOVE CRANKCASE VENT TUBE & CLEAN, REINSTALLCHG ENG OIL FILTER          J.D. RE504836 OR NAPA 7750S",
      "WitmDeadlineDate": "2015-05-27",
      "WitmThresholdDate": "2015-05-27",
      "WitmRecurringFlag": "1",
      "WitmDeadlineReading": null,
      "WitmMissedTaskCount": 0,
      "WitmAcumTypeCode": "CD",
      "WitmJcatLabCompCode": null,
      "WitmJcatLabJobCode": null,
      "WitmJcatLabPhsCode": null,
      "WitmJcatLabourCode": null,
      "WitmJcatPartsCompCode": null,
      "WitmJcatPartsJobCode": null,
      "WitmJcatPartsPhsCode": null,
      "WitmJcatPartsCode": null,
      "WitmJcatConCompCode": null,
      "WitmJcatConJobCode": null,
      "WitmJcatConPhsCode": null,
      "WitmJcatContractorCode": null,
      "WitmJcatEqCompCode": null,
      "WitmJcatEqJobCode": null,
      "WitmJcatEqPhsCode": null,
      "WitmJcatEquipmentCode": null,
      "WitmJcatOthCompCode": null,
      "WitmJcatOthJobCode": null,
      "WitmJcatOthPhsCode": null,
      "WitmJcatOtherCode": null,
      "WitmWiccCompCode": null,
      "WitmWiccLabourCode": null,
      "WitmWiccPartsCode": null,
      "WitmWiccContractorCode": null,
      "WitmWiccEquipmentCode": null,
      "WitmWiccOtherCode": null,
      "WitmStatus": "C",
      "WitmComments": null,
      "WitmCompletionDate": "2016-03-09",
      "WitmCompletionReading": null,
      "WitmNoticePrtCnt": 0,
      "WitmClass1": "PLANNED",
      "WitmClass2": null,
      "WitmClass3": null,
      "WitmClass4": null,
      "WitmVendorCode": null,
      "WitmScheduleDate": "2015-05-27",
      "WitmActiveFlag": "Y",
      "WitmTeamCode": "FIELD",
      "WitmBchNum": null,
      "WitmPostDate": null,
      "WitmSrcCompCode": null,
      "WitmJobCode": null,
      "WitmPhsCode": null,
      "WitmDeptCode": null,
      "WitmPriority": 3,
      "WitmIssueId": null,
      "WitmDeliveryDate": null,
      "WitmAppTypeCode": "PRM",
      "WitmDateCreated": null,
      "WitmCreatedBy": null,
      "WitmDateModified": "2016-03-09T18:52:04Z",
      "WitmModifiedBy": "ADWAIT",
      "WitmScheduleEndDate": null,
      "WitmBillingType": null,
      "WitmSubmittedBillingFlag": null,
      "WitmBillingAmt": null,
      "WitmBillingStateCode": "NR",
      "WitmChargeJobFlag": "N",
      "WitmChargeCompCode": null,
      "WitmChargeJobCode": null,
      "WitmChargePhsCode": null,
      "WitmChargeCatCode": null,
      "WitmUnits": null,
      "WitmWoEntry2Flag": "N",
      "WitmBuildingCode": null,
      "WitmFloorNo": null,
      "WitmRoomNo": null,
      "WitmUserField2": "055033",
      "WitmUserField3": "MAINT",
      "WitmSelectFlag": "N",
      "WitmWoVUuid": "D21723A19CDE5650E05316821FACB6B7",
      "WitmVUuid": "D21729F91C755FB8E05316821FACAF93",
      "WitmIuCreateDate": "2015-05-27T16:19:32Z",
      "WitmIuCreateUser": "BILL",
      "WitmIuUpdateDate": "2016-03-09T18:52:04Z",
      "WitmIuUpdateUser": "ADWAIT",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/prmworkitem/D21729F91C755FB8E05316821FACAF93",
          "name": "prmworkitem",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/prmworkitem/D21729F91C755FB8E05316821FACAF93",
          "name": "prmworkitem",
          "kind": "item"
        }
      ]
    },
    {
      "WitmWorkItemType": "EQ",
      "WitmTaskCode": "02",
      "WitmTaskPtgtType": "CL",
      "WitmTgtType": "EQ",
      "WitmWoCompCode": "001",
      "WitmWoCode": "PWOYY.002",
      "WitmLineNumber": 1,
      "WitmWoStepTitle": "B 500 Hr Service",
      "WitmWoStepDescription": "CHG. HYDRAULIC FILTER               SMCS Code: CT308274COOLING SYSTEM FLUSH               SMCS Code: 1350-044",
      "WitmDeadlineDate": "2015-05-27",
      "WitmThresholdDate": "2015-05-27",
      "WitmRecurringFlag": "1",
      "WitmDeadlineReading": 500,
      "WitmMissedTaskCount": 0,
      "WitmAcumTypeCode": "HR",
      "WitmJcatLabCompCode": null,
      "WitmJcatLabJobCode": null,
      "WitmJcatLabPhsCode": null,
      "WitmJcatLabourCode": null,
      "WitmJcatPartsCompCode": null,
      "WitmJcatPartsJobCode": null,
      "WitmJcatPartsPhsCode": null,
      "WitmJcatPartsCode": null,
      "WitmJcatConCompCode": null,
      "WitmJcatConJobCode": null,
      "WitmJcatConPhsCode": null,
      "WitmJcatContractorCode": null,
      "WitmJcatEqCompCode": null,
      "WitmJcatEqJobCode": null,
      "WitmJcatEqPhsCode": null,
      "WitmJcatEquipmentCode": null,
      "WitmJcatOthCompCode": null,
      "WitmJcatOthJobCode": null,
      "WitmJcatOthPhsCode": null,
      "WitmJcatOtherCode": null,
      "WitmWiccCompCode": null,
      "WitmWiccLabourCode": null,
      "WitmWiccPartsCode": null,
      "WitmWiccContractorCode": null,
      "WitmWiccEquipmentCode": null,
      "WitmWiccOtherCode": null,
      "WitmStatus": "C",
      "WitmComments": null,
      "WitmCompletionDate": "2016-03-09",
      "WitmCompletionReading": 2632,
      "WitmNoticePrtCnt": 0,
      "WitmClass1": "PLANNED",
      "WitmClass2": null,
      "WitmClass3": null,
      "WitmClass4": null,
      "WitmVendorCode": null,
      "WitmScheduleDate": "2015-05-27",
      "WitmActiveFlag": "Y",
      "WitmTeamCode": "FIELD",
      "WitmBchNum": null,
      "WitmPostDate": null,
      "WitmSrcCompCode": null,
      "WitmJobCode": null,
      "WitmPhsCode": null,
      "WitmDeptCode": null,
      "WitmPriority": 3,
      "WitmIssueId": null,
      "WitmDeliveryDate": null,
      "WitmAppTypeCode": "PRM",
      "WitmDateCreated": null,
      "WitmCreatedBy": null,
      "WitmDateModified": "2016-03-09T18:52:43Z",
      "WitmModifiedBy": "ADWAIT",
      "WitmScheduleEndDate": null,
      "WitmBillingType": null,
      "WitmSubmittedBillingFlag": null,
      "WitmBillingAmt": null,
      "WitmBillingStateCode": "NR",
      "WitmChargeJobFlag": "N",
      "WitmChargeCompCode": null,
      "WitmChargeJobCode": null,
      "WitmChargePhsCode": null,
      "WitmChargeCatCode": null,
      "WitmUnits": null,
      "WitmWoEntry2Flag": "N",
      "WitmBuildingCode": null,
      "WitmFloorNo": null,
      "WitmRoomNo": null,
      "WitmUserField2": "055033",
      "WitmUserField3": "MAINT",
      "WitmSelectFlag": "N",
      "WitmWoVUuid": "D21723A19CDE5650E05316821FACB6B7",
      "WitmVUuid": "D21729F91C765FB8E05316821FACAF93",
      "WitmIuCreateDate": "2015-05-27T16:19:32Z",
      "WitmIuCreateUser": "BILL",
      "WitmIuUpdateDate": "2016-03-09T18:52:43Z",
      "WitmIuUpdateUser": "ADWAIT",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/prmworkitem/D21729F91C765FB8E05316821FACAF93",
          "name": "prmworkitem",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/prmworkitem/D21729F91C765FB8E05316821FACAF93",
          "name": "prmworkitem",
          "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/prmworkitem",
      "name": "prmworkitem",
      "kind": "collection"
    }
  ]
}
object