// fusionrest agent · sales and service (cx) · work orders

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.

/crmRestApi/resources/11.13.18.05/customerWorkOrders
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
I want to…List the latest 25Count recordsGet one recordCreate oneUpdate one

Try it

Response fields ·
Filters (q)

Only attributes Oracle marks as searchable are offered.

Finder
Include children (expand)
Paging and options
limit
Endpoint and headers
GET /crmRestApi/resources/11.13.18.05/customerWorkOrders?fields=AccountPartyId,AccountPartyName,AccountPartyNameNonUnique,AccountPartyNumber,AccountStatus&limit=25&onlyData=true
Response shape (placeholders)
{
  "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

AttributeTypeUse
AccountPartyIdnumberOptional on createUpdatable
AccountPartyNametext · max 900Optional on createUpdatableSearchable
AccountPartyNameNonUniquetext · max 360Read-onlySearchable
AccountPartyNumbertext · max 30Read-onlySearchable
AccountStatustext · max 1Read-only
ActiveFlagyes/no · max 1 · default trueRead-onlySearchable
ActualEndDatedate-timeOptional on createUpdatableSearchable
ActualStartDatedate-timeOptional on createUpdatableSearchable
AddrElementAttribute1text · max 150Optional on createUpdatableSearchable
AddrElementAttribute2text · max 150Optional on createUpdatableSearchable
AddrElementAttribute3text · max 150Optional on createUpdatableSearchable
AddrElementAttribute4text · max 150Optional on createUpdatableSearchable
AddrElementAttribute5text · max 150Optional on createUpdatableSearchable
Address1text · max 240Optional on createUpdatableSearchable
Address2text · max 240Optional on createUpdatableSearchable
Address3text · max 240Optional on createUpdatableSearchable
Address4text · max 240Optional on createUpdatableSearchable
AddressIdnumberOptional on createUpdatableSearchable
AddressLinesPhonetictext · max 560Optional on createUpdatableSearchable
AddressSourcetext · max 255Read-onlySearchable
AddressSourceCdtext · max 30Optional on createUpdatableSearchable
AssigneeEmailtext · max 320Read-onlySearchable
AssigneePersonNametext · max 360Optional on createUpdatableSearchable
AssigneePhoneNumbertextRead-only
AssigneeResourceIdnumberOptional on createUpdatable
BUOrgIdnumberOptional on createUpdatableSearchable
BUOrgNametextRead-onlySearchable
BillToCustAccountIdnumberOptional on createUpdatableSearchable
BillToCustAccountSiteIdnumberOptional on createUpdatableSearchable
BillToCustIdnumberOptional on createUpdatableSearchable
BillToCustPartySiteIdnumberOptional on createUpdatableSearchable
BillToCustomerAccountNametext · max 240Read-onlySearchable
BillToCustomerAccountNumbertext · max 30Read-onlySearchable
BillToPartyNametext · max 360Read-onlySearchable
BillToPartyNumbertext · max 30Read-onlySearchable
BillToPartySiteFormattedAddresstext · max 5000Read-onlySearchable
BillToPartySiteLocationIdnumberRead-onlySearchable
BillToPartySiteNametext · max 240Read-onlySearchable
BillToPartySiteNumbertext · max 30Read-onlySearchable
BillToPartyUniqueNametext · max 900Read-onlySearchable
BookedDatedate-timeOptional on createUpdatableSearchable
Buildingtext · max 240Optional on createUpdatableSearchable
CancelReasontext · max 256Optional on createUpdatable
CaseNotetext · max 65535Optional on createUpdatable
Citytext · max 60Optional on createUpdatableSearchable
ContactAltPhoneNumbertext · max 240Optional on createUpdatableSearchable
ContactEmailtext · max 320Optional on createUpdatableSearchable
ContactLanguageCodetext · max 4Read-only
ContactNametext · max 420Optional on createUpdatableSearchable
ContactNameLovSwitchertextRead-only
ContactPartyFirstNametext · max 150Read-only
ContactPartyIdnumberOptional on createUpdatable
ContactPartyLastNametext · max 150Read-only
ContactPartyNumbertext · max 30Read-only
ContactPartySiteIdnumberOptional on createUpdatableSearchable
ContactPhoneNumbertext · max 240Optional on createUpdatableSearchable
ContactStatustext · max 1Read-only
Countrytext · max 2Optional on createUpdatableSearchable
Countytext · max 60Optional on createUpdatableSearchable
CreatedBytext · max 64Read-onlySearchable
CreationDatedate-timeRead-onlySearchable
DeletedFlagyes/no · max 1 · default falseRead-only
DeliveryWinEndDatedate-timeOptional on createUpdatable
DeliveryWinStartDatedate-timeOptional on createUpdatable
DurationnumberOptional on createUpdatable
EditModeFlagyes/noRead-only
EstimatedArrivalTimetextRead-only
EstimatedStartDatedate-timeOptional on createUpdatableSearchable
FieldServiceResourceEmailtext · max 320Read-onlySearchable
FieldServiceResourceIdnumberOptional on createUpdatableSearchable
FieldServiceResourcePersonNametext · max 360Read-onlySearchable
FieldServiceResourcePhoneNumbertextRead-only
FloorNumbertext · max 40Optional on createUpdatableSearchable
FormattedAddresstextOptional on createUpdatable
FsActivityIdnumberOptional on createUpdatableSearchable
FsContactFlagyes/no · max 1 · default falseOptional on createUpdatable
FsErrorDetailtext · max 500Optional on createUpdatable
FsNotetext · max 65535Optional on createUpdatable
FsResourcetext · max 256Optional on createUpdatableSearchable
FsResourceExternalIdtext · max 32Optional on createUpdatableSearchable
FsSchedResourcetext · max 256Optional on createUpdatableSearchable
FsSchedResourceExternalIdtext · max 32Optional on createUpdatableSearchable
FsTechnicianLocatorUrltext · max 2000Optional on createUpdatableSearchable
FsTypeCdtext · max 128Read-onlySearchable
GroupNametext · max 255Read-onlySearchable
IBAssetActiveFlagyes/noRead-onlySearchable
IBAssetDescriptiontext · max 240Read-onlySearchable
IBAssetEndDatedate-timeRead-only
IBAssetIdnumberOptional on createUpdatableSearchable
IBAssetInstalledDatedateRead-only
IBAssetItemDescriptiontext · max 255Read-only
IBAssetItemNumbertext · max 255Read-only
IBAssetNumbertext · max 80Read-onlySearchable
IBAssetPurchaseDatedateRead-only
IBAssetQuantitynumberRead-only
IBAssetSerialNumbertext · max 80Read-onlySearchable
IBAssetStartDatedate-timeRead-only
IBAssetStatusCodetext · max 30Read-only
IBAssetTagtext · max 240Read-only
IBAssetUOMCodetext · max 3Read-only
InventoryItemIdnumberOptional on createUpdatableSearchable
InventoryOrgIdnumberOptional on createUpdatableSearchable
LastUpdateDatedate-timeRead-onlySearchable
LastUpdateLogintext · max 32Read-only
LastUpdateSourceCdtext · max 30Optional on createUpdatableSearchable
LastUpdatedBytext · max 64Read-onlySearchable
OpportunityIdnumberOptional on createUpdatable
OwnerTypeCdtext · max 30Optional on createUpdatableSearchable
PartnerAccountNametext · max 900Required on createUpdatable
PartnerAccountPartyIdnumberOptional on createUpdatable
PartnerAccountPartyTypetext · max 30Read-only
PartnerAccountStatustextRead-only
PostalCodetext · max 60Optional on createUpdatableSearchable
PostalPlus4Codetext · max 20Optional on createUpdatableSearchable
PrimaryAssetDescriptiontext · max 2000Read-only
PrimaryAssetEndDatedateRead-only
PrimaryAssetIdnumberOptional on createUpdatableSearchable
PrimaryAssetInstallDatedateRead-only
PrimaryAssetNametext · max 300Read-only
PrimaryAssetNumbertext · max 100Read-only
PrimaryAssetProducttext · max 255Read-only
PrimaryAssetPurchaseDatedateRead-only
PrimaryAssetQuantitynumberRead-only
PrimaryAssetSerialNumbertext · max 100Read-only
PrimaryAssetStartDatedateRead-only
PrimaryAssetStatusCodetext · max 50Read-only
PrimaryAssetTagtext · max 50Read-only
PrimaryAssetUOMCodetext · max 3Read-only
ProdGroupIdnumberOptional on createUpdatableSearchable
ProdGroupNametext · max 255Read-only
ProductItemDescriptiontext · max 255Read-only
Provincetext · max 60Optional on createUpdatableSearchable
ReminderTimenumberOptional on createUpdatable
RequestedByPartyIdnumberOptional on createUpdatable
RequestedDatedateOptional on createUpdatableSearchable
RequestedDateEndTimedate-timeOptional on createUpdatableSearchable
RequestedDateStartTimedate-timeOptional on createUpdatableSearchable
RequestedTimetext · max 255Read-only
RequestedTimeSlottext · max 40Optional on createUpdatableSearchable
RequirementCancellableLinesnumberRead-only
RequirementCancelledLinesnumberRead-only
RequirementEarliestArrivalDatedate-timeRead-only
RequirementEarliestArrivalDateLocaldate-timeRead-only
RequirementLatestArrivalDatedate-timeRead-only
RequirementLatestArrivalDateLocaldate-timeRead-only
RequirementOpenLinesnumberRead-only
RequirementShippedLinestextRead-only
RequirementTotalLinesnumberRead-only
RescheduleReasontext · max 256Optional on createUpdatable
ResolutionDueDatedate-timeOptional on createUpdatableSearchable
ResolutionDueDateLocaltextRead-only
ResubmitAllowedFlagyes/noRead-only
ScheduledDatedateOptional on createUpdatableSearchable
ScheduledDateEndTimedate-timeOptional on createUpdatableSearchable
ScheduledDateStartTimedate-timeOptional on createUpdatableSearchable
ScheduledTimetext · max 255Read-only
ScheduledTimeSlottext · max 40Optional on createUpdatableSearchable
ServiceProfileIdnumberOptional on createUpdatableSearchable
ServiceProfileNametext · max 400Read-onlySearchable
ServiceProfileNumbertext · max 30Read-onlySearchable
SourceCdtext · max 30Optional on createSearchable
SrIdnumberOptional on createUpdatableSearchable
SrNumbertext · max 30Optional on createUpdatableSearchable
Statetext · max 60Optional on createUpdatableSearchable
StripeCdtext · max 30Read-only
TimezoneCodetext · max 64Optional on createUpdatable
TimezoneLongNametextRead-only
Titletext · max 400Optional on createUpdatableSearchable
TravelTimenumberOptional on createUpdatable
TriggerUpdateEventtext · max 80Optional on createUpdatable
UpdateAfterCompleteFlagyes/noRead-only
UseCancelProcessFlagyes/noRead-onlySearchable
WoAreatext · max 256Optional on createUpdatableSearchable
WoIdnumberRead-onlySearchable
WoIntegrationCatCdMeaningtextRead-only
WoIntegrationCdtext · max 30Required on createSearchable
WoIntegrationCdMeaningtextRead-only
WoIntegrationMsgCdtext · max 30Optional on createUpdatableSearchable
WoIntegrationMsgCdDisptext · max 30Read-onlySearchable
WoIntegrationStatusCdtext · max 30Optional on createUpdatableSearchable
WoIntegrationStatusCdDisptext · max 30Read-onlySearchable
WoNumbertext · max 30Optional on createSearchable
WoParentFlagyes/noRead-only
WoParentIdnumberOptional on createUpdatableSearchable
WoParentNumbertextRead-only
WoRecordTypetext · max 60Optional on createUpdatableSearchable
WoStatusCatCdtext · max 30Read-onlySearchable
WoStatusCdtext · max 30Optional on createUpdatableSearchable
WoStatusCdMeaningtextRead-only
WoStatusMapIdnumberOptional on createUpdatable
WoStatusesLOVSwitchertextRead-only
WoTypeCdtextRead-only
WoTypeCdMeaningtextRead-only
WoTypeIdnumberOptional 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.

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.

Actions 2

Actions use Content-Type: application/vnd.oracle.adf.action+json. A path with a {key} runs on one record.

Use in AI Agent Studio

More in For Builders.

Pitfalls