// fusionrest agent · procurement

Public Shopping Lists

publicShoppingLists Based on 26C

Create, change, delete and look up Public Shopping Lists, with assigned content zones. Actions include delete all lines.

The record key publicShoppingListsUniqID 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.

/fscmRestApi/resources/11.13.18.05/publicShoppingLists
Operations
GET (list)GET (one)POST (create)PATCH (update)DELETE1 action
Record key
publicShoppingListsUniqID
Required on create
none marked
At a glance
16 fields4 finders1 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 /fscmRestApi/resources/11.13.18.05/publicShoppingLists?fields=ContentZoneAssignment,ConversionRateType,CreatedBy,CreationDate,FunctionalCurrencyCode&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "ContentZoneAssignment": "<string, max 255>",
      "ConversionRateType": "<string, max 30>",
      "CreatedBy": "<string, max 64>",
      "CreationDate": "2026-01-31T09:00:00+00:00",
      "FunctionalCurrencyCode": "<string, max 10>"
    }
  ],
  "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 26C REST specification.

Fields 16

AttributeTypeUse
ContentZoneAssignmenttext · max 255Read-only
ConversionRateTypetext · max 30Read-onlySearchable
CreatedBytext · max 64Read-only
CreationDatedate-timeRead-only
FunctionalCurrencyCodetext · max 10Read-onlySearchable
HasInactiveLinestext · max 1Read-onlySearchable
ImageURLtext · max 1000Optional on createUpdatable
LastUpdateDatedate-timeRead-only
LastUpdatedBytext · max 64Read-only
ProcurementBUtextOptional on createUpdatable
ProcurementBUIdnumberOptional on createUpdatableSearchable
PublicShoppingListtext · max 100Optional on createUpdatable
PublicShoppingListDescriptiontext · max 250Optional on createUpdatable
PublicShoppingListEndDatedateOptional on createUpdatableSearchable
PublicShoppingListHeaderIdnumberRead-onlySearchable
PublicShoppingListStartDatedateOptional on createUpdatableSearchable

Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.

Finders 4

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 1

Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/publicShoppingLists/{publicShoppingListsUniqID}/child/<name>. Add them to a GET with expand.

Actions 1

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