// fusionrest agent · sales and service (cx)

Products

products Based on latest (2026.09)

Create, change and look up Products, with default prices and smart actions.

/crmRestApi/resources/11.13.18.05/products
Operations
GET (list)GET (one)POST (create)PATCH (update)9 actions
Record key
InventoryItemId
Required on create
DefaultUOMDefaultUOMCodeNameOrganizationId
At a glance
91 fields1 finders8 children2 file/large text fields
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/products?fields=ATPCode,ATPComponentsCode,AllowMaintenanceAssetFlag,AllowSuspendFlag,AllowTerminateFlag&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "ATPCode": "<string, max 1>",
      "ATPComponentsCode": "<string, max 1>",
      "AllowMaintenanceAssetFlag": false,
      "AllowSuspendFlag": false,
      "AllowTerminateFlag": false
    }
  ],
  "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 91

AttributeTypeUse
ATPCodetext · max 1Optional on createUpdatableSearchable
ATPComponentsCodetext · max 1Optional on createUpdatableSearchable
AllowMaintenanceAssetFlagyes/no · max 1Optional on createUpdatableSearchable
AllowSuspendFlagyes/no · max 1Optional on createUpdatableSearchable
AllowTerminateFlagyes/no · max 1Optional on createUpdatableSearchable
ApprovalStatustext · max 30Read-onlySearchable
AssetTrackedFlagyes/no · max 1Optional on createUpdatableSearchable
AttachmentEntityNametext · default ITEM_ENTITYOptional on createUpdatableSearchable
AutoSerialAlphaPrefixtext · max 80Optional on createUpdatableSearchable
BOMItemTypetext · max 30Optional on createUpdatableSearchable
CSSEnabledtext · max 1 · default NOptional on createUpdatableSearchable
CollateralFlagyes/no · max 1Optional on createUpdatableSearchable
ConfigurableFlagyes/no · max 1Optional on createUpdatableSearchable
ContainerItemFlagyes/no · max 1Optional on createUpdatableSearchable
ContainerTypeCodetext · max 30Optional on createUpdatableSearchable
CoverageNametext · max 150Optional on createUpdatableSearchable
CoverageScheduleIdnumberOptional on createUpdatableSearchable
CreatedBytext · max 64Read-onlySearchable
CreationDatedate-timeRead-onlySearchable
CustomerOrderFlagyes/no · max 1Optional on createUpdatableSearchable
CxAssetTrackedFlagyes/no · max 1 · default falseOptional on createUpdatableSearchable
DefaultPeriodicitytext · max 80Optional on createUpdatableSearchable
DefaultPeriodicityCodetext · max 30Optional on createUpdatableSearchable
DefaultPeriodsnumberOptional on createUpdatableSearchable
DefaultPriceTypetext · max 80Optional on createUpdatableSearchable
DefaultPriceTypeCodetext · max 30Optional on createUpdatableSearchable
DefaultUOMtext · max 25Required on createSearchable
DefaultUOMCodetext · max 3Required on createSearchable
DeleteFlagyes/noRead-onlySearchable
Descriptiontext · max 4000Optional on createUpdatableSearchable
DimensionUOMCodetext · max 3Optional on createUpdatableSearchable
EligibilityCompatibilityRuleFlagyes/no · max 1Optional on createUpdatableSearchable
EligibleForServicetext · default YOptional on createUpdatable
EligibleToSelltext · max 80Optional on createUpdatableSearchable
EligibleToSellFlagyes/no · max 1 · default trueOptional on createUpdatableSearchable
EnableContractCoverageFlagyes/no · max 1Optional on createUpdatableSearchable
EquipmentTypeFlagyes/no · max 30Optional on createUpdatableSearchable
EventFlagyes/no · max 1Optional on createUpdatableSearchable
ExtendedDescriptionOnetextOptional on createUpdatable
ExtendedDescriptionTwotextOptional on createUpdatable
FinancingAllowedFlagyes/no · max 1Optional on createUpdatableSearchable
InternalVolumenumberOptional on createUpdatableSearchable
InvOrgIdnumberRead-onlySearchable
InventoryItemIdnumberOptional on createSearchable
InventoryItemStatusCodetext · max 10 · default ActiveOptional on createSearchable
InvoiceEnabledFlagyes/no · max 1Optional on createUpdatableSearchable
InvoiceableItemFlagyes/no · max 1Optional on createUpdatableSearchable
ItemCatalogGroupIdnumberOptional on createSearchable
ItemNumbertext · max 300Optional on createSearchable
ItemTypetext · max 30Optional on createUpdatableSearchable
LastSyncDatedateRead-onlySearchable
LastUpdateDatedate-timeRead-onlySearchable
LastUpdateLogintext · max 32Read-onlySearchable
LastUpdatedBytext · max 64Read-onlySearchable
MaximumLoadWeightnumberOptional on createUpdatableSearchable
MinimumFillPercentnumberOptional on createUpdatableSearchable
ModelConfigAttributestext · max 4000Optional on createUpdatableSearchable
ModelFamilytext · max 1000Optional on createUpdatableSearchable
ModelLinetext · max 1000Optional on createUpdatableSearchable
ModelNametext · max 1000Optional on createUpdatableSearchable
Nametext · max 240Required on createUpdatableSearchable
OrganizationCodetext · max 18Read-only
OrganizationIdnumberRequired on createSearchable
PickComponentsFlagyes/no · max 1Optional on createUpdatableSearchable
ProcessingDaysnumberOptional on createUpdatableSearchable
ProductLaunchFlagyes/no · max 1 · default falseOptional on createUpdatableSearchable
ProductStatusCodetext · max 30 · default ORA_CREATEDOptional on createUpdatableSearchable
ProductTypetext · max 80Optional on createUpdatableSearchable
ProductTypeCodetext · max 30Optional on createUpdatableSearchable
ReplenishToOrderFlagyes/no · max 1Optional on createUpdatableSearchable
ReturnableFlagyes/no · max 1Optional on createUpdatableSearchable
SalesProductLookupTypetextOptional on createUpdatable
SerialNumberControlCodetext · max 30Optional on createUpdatableSearchable
ServiceDurationnumberOptional on createUpdatableSearchable
ServiceDurationPeriodCodetext · max 10Optional on createUpdatableSearchable
ServiceDurationTypeCodetext · max 3Optional on createUpdatableSearchable
ServiceStartDelaynumberOptional on createUpdatableSearchable
ServiceStartTypeCodetext · max 3Optional on createUpdatableSearchable
ShippableItemFlagyes/no · max 1Optional on createUpdatableSearchable
StartAutoSerialNumbertext · max 80Optional on createUpdatableSearchable
TemplateNametext · max 960Optional on create
UnitHeightnumberOptional on createUpdatableSearchable
UnitLengthnumberOptional on createUpdatableSearchable
UnitVolumenumberOptional on createUpdatableSearchable
UnitWeightnumberOptional on createUpdatableSearchable
UnitWidthnumberOptional on createUpdatableSearchable
UpdateFlagyes/noRead-onlySearchable
VehicleItemFlagyes/no · max 1Optional on createUpdatableSearchable
VolumeUOMCodetext · max 3Optional on createUpdatableSearchable
WIPSupplyTypenumberOptional on createUpdatableSearchable
WeightUOMCodetext · max 3Optional 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 1

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 8

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

Actions 9

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