// fusionrest agent · sales and service (cx)

Sales Leads

leads Based on latest (2026.09)

Create, change, delete and look up Sales Leads, with assessments, interviews and lead campaigns. Actions include accept lead and convert lead and get opty.

The record key leadsUniqID is a generated hash. Take it from the record's links (rel self) in a GET response; never build it yourself.

Oracle documents an Effective-Of header and an effectiveDate parameter for this resource, used for date-effective reads and changes.

/crmRestApi/resources/11.13.18.05/leads
Operations
GET (list)GET (one)POST (create)PATCH (update)DELETE96 actions
Record key
leadsUniqID
Required on create
Name
At a glance
169 fields3 finders59 children
Extra parameters
?effectiveDate=Effective-Of:
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/leads?fields=AILeadScore,AcceptedDate,AcceptedDateTime,AccountPartyNumber,AddrElementAttribute1&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "AILeadScore": 0,
      "AcceptedDate": "2026-01-31",
      "AcceptedDateTime": "2026-01-31T09:00:00+00:00",
      "AccountPartyNumber": "<string, max 30>",
      "AddrElementAttribute1": "<string, max 150>"
    }
  ],
  "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 169

AttributeTypeUse
AILeadScorenumberRead-onlySearchable
AcceptedDatedateRead-only
AcceptedDateTimedate-timeRead-onlySearchable
AccountPartyNumbertext · max 30Read-onlySearchable
AddrElementAttribute1text · max 150Optional on createUpdatable
AddrElementAttribute2text · max 150Optional on createUpdatable
AddrElementAttribute3text · max 150Optional on createUpdatable
AddrElementAttribute4text · max 150Optional on createUpdatable
AddrElementAttribute5text · max 150Optional on createUpdatable
AddressLinesPhonetictext · max 560Optional on createUpdatable
ApprovalDatedateOptional on createUpdatable
ApprovalDateTimedate-timeOptional on createUpdatable
AssetIdnumberOptional on createUpdatableSearchable
AssetNumbertext · max 100Optional on createUpdatableSearchable
AssetSerialNumbertext · max 100Read-onlySearchable
AssignmentStatusCodetext · max 30Optional on createUpdatableSearchable
BudgetAmountnumberOptional on createUpdatable
BudgetCurrencyCodetext · max 80Optional on createUpdatable
BudgetStatustext · max 120Optional on createUpdatableSearchable
Buildingtext · max 40Optional on createUpdatable
BusinessUnitIdnumberOptional on create
CampaignNametext · max 250Read-onlySearchable
ChannelTypetext · max 30Optional on createUpdatableSearchable
ClassCode1text · max 30Optional on createUpdatable
ClassCode2text · max 30Optional on createUpdatable
ClassCode3text · max 30Optional on createUpdatable
ClassCode4text · max 30Optional on createUpdatable
ConflictIdnumber · default 1Optional on createUpdatableSearchable
ContactDoNotPreferenceyes/no · max 30Optional on createUpdatable
ContactFormattedAddresstextRead-only
ContactPartyNumbertext · max 30Read-onlySearchable
ContactTimezoneCdtext · max 35Optional on createUpdatableSearchable
ConvertedDateTimedate-timeOptional on createUpdatable
CreatedBytext · max 64Read-only
CreationDatedate-timeRead-onlySearchable
CurrencyCodetext · max 15Optional on createUpdatable
CustPartyTypetext · max 30Optional on createUpdatable
CustomerIdnumberOptional on createUpdatableSearchable
CustomerNeedtext · max 30Optional on createUpdatable
CustomerPartyNametext · max 360Optional on createUpdatableSearchable
DealAmountnumberOptional on createUpdatableSearchable
DecisionMakerIdentifiedFlagyes/no · max 120 · default falseOptional on createUpdatable
DeleteFlagyes/noRead-only
Descriptiontext · max 2000Optional on createUpdatable
DistancenumberRead-only
EligibleForConversionFlagyes/no · max 1Optional on createUpdatableSearchable
EnableCreateAccounttext · max 1Optional on createUpdatable
EnableCreateContacttext · max 1Optional on createUpdatable
EstimatedCloseDatedateOptional on createUpdatable
ExpirationDatedateOptional on createUpdatable
FloorNumbertext · max 40Optional on createUpdatable
FollowupTimestampdateOptional on createUpdatable
FormattedPhoneNumber1textRead-only
IBAssetIdnumberOptional on createUpdatableSearchable
IBAssetNumbertext · max 80Read-onlySearchable
IBAssetSerialNumbertext · max 80Read-onlySearchable
InventoryItemDescriptiontext · max 240Optional on createUpdatable
JobTitletext · max 100Optional on createUpdatableSearchable
LastAssignmentDatedate-timeOptional on createUpdatableSearchable
LastUpdateDatedate-timeRead-onlySearchable
LastUpdateLogintext · max 32Read-only
LastUpdatedBytext · max 64Read-only
LatitudenumberOptional on createUpdatableSearchable
LeadAcceptedFlagyes/no · max 4Optional on createUpdatableSearchable
LeadAgingnumberRead-onlySearchable
LeadCreatedBytext · max 64Optional on createSearchable
LeadCreationDatedate-timeOptional on createSearchable
LeadIdnumberOptional on createUpdatableSearchable
LeadLastUpdateDatedate-timeOptional on createUpdatableSearchable
LeadLastUpdatedBytext · max 64Optional on createUpdatableSearchable
LeadNumbertext · max 30Optional on createSearchable
LeadOrigintext · max 30 · default SALES_LEADOptional on createSearchable
LongitudenumberOptional on createUpdatableSearchable
Nametext · max 250Required on createUpdatableSearchable
OpportunityIdForConvertnumberOptional on createUpdatable
OpportunityNametextOptional on createUpdatable
OpportunityOwnerNumbertextOptional on createUpdatable
OrganizationNametext · max 360Read-only
OrganizationSizetext · max 30Optional on createUpdatable
OrganizationTypetext · max 30Optional on createUpdatable
OwnerIdnumberOptional on createUpdatableSearchable
OwnerPartyNametext · max 360Optional on createUpdatableSearchable
OwnerPartyNumbertext · max 30Read-onlySearchable
PartnerCompanyNumbertext · max 30Optional on createSearchable
PartnerIdnumberOptional on createUpdatableSearchable
PartnerPartyNametextOptional on createUpdatableSearchable
PartnerProgramIdnumberOptional on createUpdatable
PartnerProgramNumbertext · max 30Optional on createSearchable
PartnerTypetext · max 30Optional on createUpdatable
PostalPlus4Codetext · max 10Optional on createUpdatable
PrimaryCampaignIdnumberOptional on createUpdatableSearchable
PrimaryCampaignNametextOptional on createUpdatableSearchable
PrimaryCampaignNumbertext · max 30Optional on createUpdatableSearchable
PrimaryCompetitorNametextOptional on createUpdatableSearchable
PrimaryCompetitorPartyIdnumberOptional on createUpdatableSearchable
PrimaryCompetitorPartyNumbertext · max 30Read-onlySearchable
PrimaryContactAddress1text · max 240Optional on createUpdatableSearchable
PrimaryContactAddress2text · max 240Optional on createUpdatableSearchable
PrimaryContactAddress3text · max 240Optional on createUpdatable
PrimaryContactAddress4text · max 240Optional on createUpdatable
PrimaryContactCitytext · max 60Optional on createUpdatableSearchable
PrimaryContactCountrytext · max 2Optional on createUpdatableSearchable
PrimaryContactCountryNametextRead-only
PrimaryContactCountytext · max 60Optional on createUpdatableSearchable
PrimaryContactEmailAddresstext · max 320Optional on createUpdatableSearchable
PrimaryContactEmailPreferencetext · max 30Optional on createUpdatable
PrimaryContactEmailVerificationDatedate-timeOptional on createUpdatable
PrimaryContactEmailVerificationStatustext · max 30Optional on createUpdatable
PrimaryContactIdnumberOptional on createUpdatableSearchable
PrimaryContactMailPreferencetext · max 30Optional on createUpdatable
PrimaryContactNumbertext · max 64Optional on createUpdatableSearchable
PrimaryContactPartyNametext · max 450Optional on createUpdatableSearchable
PrimaryContactPersonFirstNametext · max 150Optional on createUpdatableSearchable
PrimaryContactPersonLastNametext · max 150Optional on createUpdatableSearchable
PrimaryContactPersonMiddleNametext · max 150Optional on createUpdatableSearchable
PrimaryContactPhonePreferencetext · max 30Optional on createUpdatable
PrimaryContactPostalCodetext · max 60Optional on createUpdatableSearchable
PrimaryContactProvincetext · max 60Optional on createUpdatable
PrimaryContactRelationshipIdnumberOptional on createUpdatable
PrimaryContactStatetext · max 60Optional on createUpdatableSearchable
PrimaryInventoryItemIdnumberOptional on createUpdatable
PrimaryInventoryItemNumbertext · max 300Read-onlySearchable
PrimaryInventoryOrgIdnumberOptional on createUpdatable
PrimaryPhoneAreaCodetext · max 10Optional on createUpdatable
PrimaryPhoneCountryCodetext · max 10Optional on createUpdatable
PrimaryPhoneNumbertext · max 40Optional on createUpdatableSearchable
PrimaryPhoneVerificationDatedate-timeOptional on createUpdatable
PrimaryPhoneVerificationStatustext · max 30Optional on createUpdatable
PrimaryProductGroupIdnumberOptional on createUpdatable
PrimaryProductGroupReferenceNumbertext · max 820Read-onlySearchable
ProductGroupDescriptiontext · max 1000Read-only
ProductGroupNametext · max 250Optional on createUpdatableSearchable
ProductTypetextOptional on createUpdatable
ProgramNametextOptional on createUpdatable
Projecttext · max 30Optional on createUpdatable
QualificationScorenumber · default 0Read-only
QualifiedDatedateOptional on createUpdatable
QualifiedDateTimedate-timeOptional on createUpdatable
Ranktext · max 30Optional on createUpdatableSearchable
RawPrimaryPhoneNumbertextOptional on createUpdatableSearchable
ReassignCommenttext · max 1000Optional on createUpdatable
ReassignReasonCodetext · max 30Optional on createUpdatableSearchable
RecordSettextRead-onlySearchable
RegistrationNumbertext · max 120Optional on createUpdatableSearchable
RegistrationStatustext · max 120Optional on createUpdatableSearchable
RegistrationTypetext · max 120Optional on createUpdatableSearchable
RejectByUserIdnumberOptional on createUpdatable
RejectCommenttext · max 250Optional on createUpdatable
RejectReasonCodetext · max 30Optional on createUpdatableSearchable
RejectedDateTimedate-timeOptional on createUpdatable
RetireCommenttext · max 250Optional on createUpdatable
RetireReasonCodetext · max 30Optional on createUpdatableSearchable
RetiredDateTimedate-timeOptional on createUpdatable
SalesChanneltext · max 120Optional on createUpdatable
SalesTargetLeadEloquaSyncDatedate-timeOptional on createUpdatable
SalesTargetLeadOptOutCommenttext · max 1000Optional on createUpdatable
SalesTargetLeadOptOutDatedate-timeOptional on createUpdatable
SalesTargetLeadOptOutReasonCodetext · max 32Optional on createUpdatable
SalesTargetLeadStagetext · max 32Optional on createUpdatableSearchable
SalesTargetLeadValidationDueDatedate-timeOptional on createUpdatable
ScorenumberOptional on createUpdatableSearchable
SourceCodetext · max 30Optional on createUpdatableSearchable
StatusCodetext · max 30 · default UNQUALIFIEDOptional on createUpdatableSearchable
Timeframetext · max 120Optional on createUpdatableSearchable
ToReassignFlagyes/no · max 1 · default falseOptional on createUpdatable
UpdateFlagyes/noRead-only
WorkPhoneAreaCodetext · max 10Optional on createUpdatable
WorkPhoneCountryCodetext · max 10Optional on createUpdatable
WorkPhoneNumbertext · max 40Optional 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 3

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 59

Child resources sit under one record: /crmRestApi/resources/11.13.18.05/leads/{leadsUniqID}/child/<name>. Add them to a GET with expand.

Actions 96

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