Work Orders (ADF)
customerWorkOrders Based on latest (2026.09)
Create, change, delete and look up Work Orders (ADF), with wo link. Actions include get access schedule payload and process status update.
- Operations
- GET (list)GET (one)POST (create)PATCH (update)DELETE2 actions
- Record key
WoNumber- Required on create
PartnerAccountNameWoIntegrationCd- At a glance
- 194 fields2 finders2 children
Try it
Only attributes Oracle marks as searchable are offered.
GET /crmRestApi/resources/11.13.18.05/customerWorkOrders?fields=AccountPartyId,AccountPartyName,AccountPartyNameNonUnique,AccountPartyNumber,AccountStatus&limit=25&onlyData=true
{
"items": [
{
"AccountPartyId": 0,
"AccountPartyName": "<string, max 900>",
"AccountPartyNameNonUnique": "<string, max 360>",
"AccountPartyNumber": "<string, max 30>",
"AccountStatus": "<string, max 1>"
}
],
"count": 25,
"hasMore": true,
"limit": 25,
"offset": 0
}Shapes and placeholders, not real data. Replace https://<your-pod> and the login with your own: this site never sees them. Based on Oracle's latest (2026.09) REST specification.
Fields 194
| Attribute | Type | Use |
|---|---|---|
AccountPartyId | number | Optional on createUpdatable |
AccountPartyName | text · max 900 | Optional on createUpdatableSearchable |
AccountPartyNameNonUnique | text · max 360 | Read-onlySearchable |
AccountPartyNumber | text · max 30 | Read-onlySearchable |
AccountStatus | text · max 1 | Read-only |
ActiveFlag | yes/no · max 1 · default true | Read-onlySearchable |
ActualEndDate | date-time | Optional on createUpdatableSearchable |
ActualStartDate | date-time | Optional on createUpdatableSearchable |
AddrElementAttribute1 | text · max 150 | Optional on createUpdatableSearchable |
AddrElementAttribute2 | text · max 150 | Optional on createUpdatableSearchable |
AddrElementAttribute3 | text · max 150 | Optional on createUpdatableSearchable |
AddrElementAttribute4 | text · max 150 | Optional on createUpdatableSearchable |
AddrElementAttribute5 | text · max 150 | Optional on createUpdatableSearchable |
Address1 | text · max 240 | Optional on createUpdatableSearchable |
Address2 | text · max 240 | Optional on createUpdatableSearchable |
Address3 | text · max 240 | Optional on createUpdatableSearchable |
Address4 | text · max 240 | Optional on createUpdatableSearchable |
AddressId | number | Optional on createUpdatableSearchable |
AddressLinesPhonetic | text · max 560 | Optional on createUpdatableSearchable |
AddressSource | text · max 255 | Read-onlySearchable |
AddressSourceCd | text · max 30 | Optional on createUpdatableSearchable |
AssigneeEmail | text · max 320 | Read-onlySearchable |
AssigneePersonName | text · max 360 | Optional on createUpdatableSearchable |
AssigneePhoneNumber | text | Read-only |
AssigneeResourceId | number | Optional on createUpdatable |
BUOrgId | number | Optional on createUpdatableSearchable |
BUOrgName | text | Read-onlySearchable |
BillToCustAccountId | number | Optional on createUpdatableSearchable |
BillToCustAccountSiteId | number | Optional on createUpdatableSearchable |
BillToCustId | number | Optional on createUpdatableSearchable |
BillToCustPartySiteId | number | Optional on createUpdatableSearchable |
BillToCustomerAccountName | text · max 240 | Read-onlySearchable |
BillToCustomerAccountNumber | text · max 30 | Read-onlySearchable |
BillToPartyName | text · max 360 | Read-onlySearchable |
BillToPartyNumber | text · max 30 | Read-onlySearchable |
BillToPartySiteFormattedAddress | text · max 5000 | Read-onlySearchable |
BillToPartySiteLocationId | number | Read-onlySearchable |
BillToPartySiteName | text · max 240 | Read-onlySearchable |
BillToPartySiteNumber | text · max 30 | Read-onlySearchable |
BillToPartyUniqueName | text · max 900 | Read-onlySearchable |
BookedDate | date-time | Optional on createUpdatableSearchable |
Building | text · max 240 | Optional on createUpdatableSearchable |
CancelReason | text · max 256 | Optional on createUpdatable |
CaseNote | text · max 65535 | Optional on createUpdatable |
City | text · max 60 | Optional on createUpdatableSearchable |
ContactAltPhoneNumber | text · max 240 | Optional on createUpdatableSearchable |
ContactEmail | text · max 320 | Optional on createUpdatableSearchable |
ContactLanguageCode | text · max 4 | Read-only |
ContactName | text · max 420 | Optional on createUpdatableSearchable |
ContactNameLovSwitcher | text | Read-only |
ContactPartyFirstName | text · max 150 | Read-only |
ContactPartyId | number | Optional on createUpdatable |
ContactPartyLastName | text · max 150 | Read-only |
ContactPartyNumber | text · max 30 | Read-only |
ContactPartySiteId | number | Optional on createUpdatableSearchable |
ContactPhoneNumber | text · max 240 | Optional on createUpdatableSearchable |
ContactStatus | text · max 1 | Read-only |
Country | text · max 2 | Optional on createUpdatableSearchable |
County | text · max 60 | Optional on createUpdatableSearchable |
CreatedBy | text · max 64 | Read-onlySearchable |
CreationDate | date-time | Read-onlySearchable |
DeletedFlag | yes/no · max 1 · default false | Read-only |
DeliveryWinEndDate | date-time | Optional on createUpdatable |
DeliveryWinStartDate | date-time | Optional on createUpdatable |
Duration | number | Optional on createUpdatable |
EditModeFlag | yes/no | Read-only |
EstimatedArrivalTime | text | Read-only |
EstimatedStartDate | date-time | Optional on createUpdatableSearchable |
FieldServiceResourceEmail | text · max 320 | Read-onlySearchable |
FieldServiceResourceId | number | Optional on createUpdatableSearchable |
FieldServiceResourcePersonName | text · max 360 | Read-onlySearchable |
FieldServiceResourcePhoneNumber | text | Read-only |
FloorNumber | text · max 40 | Optional on createUpdatableSearchable |
FormattedAddress | text | Optional on createUpdatable |
FsActivityId | number | Optional on createUpdatableSearchable |
FsContactFlag | yes/no · max 1 · default false | Optional on createUpdatable |
FsErrorDetail | text · max 500 | Optional on createUpdatable |
FsNote | text · max 65535 | Optional on createUpdatable |
FsResource | text · max 256 | Optional on createUpdatableSearchable |
FsResourceExternalId | text · max 32 | Optional on createUpdatableSearchable |
FsSchedResource | text · max 256 | Optional on createUpdatableSearchable |
FsSchedResourceExternalId | text · max 32 | Optional on createUpdatableSearchable |
FsTechnicianLocatorUrl | text · max 2000 | Optional on createUpdatableSearchable |
FsTypeCd | text · max 128 | Read-onlySearchable |
GroupName | text · max 255 | Read-onlySearchable |
IBAssetActiveFlag | yes/no | Read-onlySearchable |
IBAssetDescription | text · max 240 | Read-onlySearchable |
IBAssetEndDate | date-time | Read-only |
IBAssetId | number | Optional on createUpdatableSearchable |
IBAssetInstalledDate | date | Read-only |
IBAssetItemDescription | text · max 255 | Read-only |
IBAssetItemNumber | text · max 255 | Read-only |
IBAssetNumber | text · max 80 | Read-onlySearchable |
IBAssetPurchaseDate | date | Read-only |
IBAssetQuantity | number | Read-only |
IBAssetSerialNumber | text · max 80 | Read-onlySearchable |
IBAssetStartDate | date-time | Read-only |
IBAssetStatusCode | text · max 30 | Read-only |
IBAssetTag | text · max 240 | Read-only |
IBAssetUOMCode | text · max 3 | Read-only |
InventoryItemId | number | Optional on createUpdatableSearchable |
InventoryOrgId | number | Optional on createUpdatableSearchable |
LastUpdateDate | date-time | Read-onlySearchable |
LastUpdateLogin | text · max 32 | Read-only |
LastUpdateSourceCd | text · max 30 | Optional on createUpdatableSearchable |
LastUpdatedBy | text · max 64 | Read-onlySearchable |
OpportunityId | number | Optional on createUpdatable |
OwnerTypeCd | text · max 30 | Optional on createUpdatableSearchable |
PartnerAccountName | text · max 900 | Required on createUpdatable |
PartnerAccountPartyId | number | Optional on createUpdatable |
PartnerAccountPartyType | text · max 30 | Read-only |
PartnerAccountStatus | text | Read-only |
PostalCode | text · max 60 | Optional on createUpdatableSearchable |
PostalPlus4Code | text · max 20 | Optional on createUpdatableSearchable |
PrimaryAssetDescription | text · max 2000 | Read-only |
PrimaryAssetEndDate | date | Read-only |
PrimaryAssetId | number | Optional on createUpdatableSearchable |
PrimaryAssetInstallDate | date | Read-only |
PrimaryAssetName | text · max 300 | Read-only |
PrimaryAssetNumber | text · max 100 | Read-only |
PrimaryAssetProduct | text · max 255 | Read-only |
PrimaryAssetPurchaseDate | date | Read-only |
PrimaryAssetQuantity | number | Read-only |
PrimaryAssetSerialNumber | text · max 100 | Read-only |
PrimaryAssetStartDate | date | Read-only |
PrimaryAssetStatusCode | text · max 50 | Read-only |
PrimaryAssetTag | text · max 50 | Read-only |
PrimaryAssetUOMCode | text · max 3 | Read-only |
ProdGroupId | number | Optional on createUpdatableSearchable |
ProdGroupName | text · max 255 | Read-only |
ProductItemDescription | text · max 255 | Read-only |
Province | text · max 60 | Optional on createUpdatableSearchable |
ReminderTime | number | Optional on createUpdatable |
RequestedByPartyId | number | Optional on createUpdatable |
RequestedDate | date | Optional on createUpdatableSearchable |
RequestedDateEndTime | date-time | Optional on createUpdatableSearchable |
RequestedDateStartTime | date-time | Optional on createUpdatableSearchable |
RequestedTime | text · max 255 | Read-only |
RequestedTimeSlot | text · max 40 | Optional on createUpdatableSearchable |
RequirementCancellableLines | number | Read-only |
RequirementCancelledLines | number | Read-only |
RequirementEarliestArrivalDate | date-time | Read-only |
RequirementEarliestArrivalDateLocal | date-time | Read-only |
RequirementLatestArrivalDate | date-time | Read-only |
RequirementLatestArrivalDateLocal | date-time | Read-only |
RequirementOpenLines | number | Read-only |
RequirementShippedLines | text | Read-only |
RequirementTotalLines | number | Read-only |
RescheduleReason | text · max 256 | Optional on createUpdatable |
ResolutionDueDate | date-time | Optional on createUpdatableSearchable |
ResolutionDueDateLocal | text | Read-only |
ResubmitAllowedFlag | yes/no | Read-only |
ScheduledDate | date | Optional on createUpdatableSearchable |
ScheduledDateEndTime | date-time | Optional on createUpdatableSearchable |
ScheduledDateStartTime | date-time | Optional on createUpdatableSearchable |
ScheduledTime | text · max 255 | Read-only |
ScheduledTimeSlot | text · max 40 | Optional on createUpdatableSearchable |
ServiceProfileId | number | Optional on createUpdatableSearchable |
ServiceProfileName | text · max 400 | Read-onlySearchable |
ServiceProfileNumber | text · max 30 | Read-onlySearchable |
SourceCd | text · max 30 | Optional on createSearchable |
SrId | number | Optional on createUpdatableSearchable |
SrNumber | text · max 30 | Optional on createUpdatableSearchable |
State | text · max 60 | Optional on createUpdatableSearchable |
StripeCd | text · max 30 | Read-only |
TimezoneCode | text · max 64 | Optional on createUpdatable |
TimezoneLongName | text | Read-only |
Title | text · max 400 | Optional on createUpdatableSearchable |
TravelTime | number | Optional on createUpdatable |
TriggerUpdateEvent | text · max 80 | Optional on createUpdatable |
UpdateAfterCompleteFlag | yes/no | Read-only |
UseCancelProcessFlag | yes/no | Read-onlySearchable |
WoArea | text · max 256 | Optional on createUpdatableSearchable |
WoId | number | Read-onlySearchable |
WoIntegrationCatCdMeaning | text | Read-only |
WoIntegrationCd | text · max 30 | Required on createSearchable |
WoIntegrationCdMeaning | text | Read-only |
WoIntegrationMsgCd | text · max 30 | Optional on createUpdatableSearchable |
WoIntegrationMsgCdDisp | text · max 30 | Read-onlySearchable |
WoIntegrationStatusCd | text · max 30 | Optional on createUpdatableSearchable |
WoIntegrationStatusCdDisp | text · max 30 | Read-onlySearchable |
WoNumber | text · max 30 | Optional on createSearchable |
WoParentFlag | yes/no | Read-only |
WoParentId | number | Optional on createUpdatableSearchable |
WoParentNumber | text | Read-only |
WoRecordType | text · max 60 | Optional on createUpdatableSearchable |
WoStatusCatCd | text · max 30 | Read-onlySearchable |
WoStatusCd | text · max 30 | Optional on createUpdatableSearchable |
WoStatusCdMeaning | text | Read-only |
WoStatusMapId | number | Optional on createUpdatable |
WoStatusesLOVSwitcher | text | Read-only |
WoTypeCd | text | Read-only |
WoTypeCdMeaning | text | Read-only |
WoTypeId | number | Optional on createUpdatableSearchable |
Names, types, labels and flags from Oracle's REST specification (latest (2026.09)). Flexfield and custom attributes vary by pod: check /describe for yours.
Finders 2
Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.
WorkOrderByNumberFinderWorkOrdersByStripeCdFinder
Check a payload
Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.
Children 2
Child resources sit under one record: /crmRestApi/resources/11.13.18.05/customerWorkOrders/{WoNumber}/child/<name>. Add them to a GET with expand.
AttachmentGET · POST · PATCH · DELETE Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNameWoLinkGET · POST · PATCH · DELETE Work Order Links · 43 fields · 1 findersAssignmentConstraintCdCreatedByCreationDateFirstWoIdFirstWoNumberFirstWoScheduledDateFirstWoScheduledTimeSlotFirstWoStatusCdFirstWoStatusCdMeaningFirstWoTitleFsFirstActivityIdFsSecondActivityIdLastUpdateDateLastUpdateSourceCdLastUpdatedByLinkTemplateCatCdLinkTemplateCatDirFirstCdLinkTemplateCatDirFirstCdMeaningLinkTemplateCatDirSecondCdLinkTemplateCatDirSecondCdMeaningLinkTemplateIdLinkTemplateNumberLinkTypeDirectionCdLinkTypeLabelFirstLinkTypeLabelSecondLinkTypeNameFirstLinkTypeNameSecondMaximumIntervalMinutesMaximumIntervalTypeCdMaximumIntervalValueMinimumIntervalMinutesMinimumIntervalTypeCdMinimumIntervalValueSchedulingConstraintCdSecondWoIdSecondWoNumberSecondWoScheduledDateSecondWoScheduledTimeSlotSecondWoStatusCdSecondWoStatusCdMeaningSecondWoTitleTemplateActiveFlagWoLinkId
Actions 2
POST …/{WoNumber}/action/getAccessSchedulePayload·daysPOST …/{WoNumber}/action/processStatusUpdate·fsActivityIdstatus
Actions use Content-Type: application/vnd.oracle.adf.action+json. A path with a {key} runs on one record.
Use in AI Agent Studio
- Point a Business Object or REST tool at
/crmRestApi/resources/11.13.18.05/customerWorkOrdersand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Prefer a finder such as
WorkOrderByNumberFinderfor the agent's main search: its variables become clean tool parameters. - Narrow with
q=on searchable fields and a smalllimit; for a count usetotalResults=true&limit=1. - Call once and pass the result on to later steps rather than calling the same endpoint again.
- This resource can change data. Put a human approval step before any create, update, delete or action call.
More in For Builders.
Pitfalls
- Attribute names are case-sensitive in
q,fieldsand bodies:AccountPartyId, notaccountpartyid. - 98 fields are read-only: sending them in POST or PATCH fails or is ignored. The builder leaves them out.
- Send dates as
YYYY-MM-DD; date-time fields take ISO 8601 with a time zone. - A list returns 25 rows unless you set
limit; readhasMoreand moveoffsetto page through. - Text fields have maximum lengths (shown in the field table). Longer values are rejected.