// fusionrest agent · procurement

Catalog Category Hierarchies

categoryHierarchies Based on 26C

Create, change, delete and look up Catalog Category Hierarchies, with category assignments. Actions include update flattened tables and insert item categories.

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

/fscmRestApi/resources/11.13.18.05/categoryHierarchies
Operations
GET (list)GET (one)POST (create)PATCH (update)DELETE3 actions
Record key
categoryHierarchiesUniqID
Required on create
CategoryIdHierarchyTypeParentCategoryId
At a glance
14 fields3 finders1 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 /fscmRestApi/resources/11.13.18.05/categoryHierarchies?fields=CategoryDescription,CategoryId,CategoryImageURL,CategoryName,CreatedBy&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "CategoryDescription": "<string, max 255>",
      "CategoryId": 0,
      "CategoryImageURL": "<string, max 240>",
      "CategoryName": "<string, max 255>",
      "CreatedBy": "<string, max 64>"
    }
  ],
  "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 14

AttributeTypeUse
CategoryDescriptiontext · max 255Optional on createUpdatable
CategoryIdnumberRequired on createSearchable
CategoryImageURLtext · max 240Optional on createUpdatable
CategoryNametext · max 255Optional on createUpdatableSearchable
CreatedBytext · max 64Read-only
CreationDatedate-timeRead-only
FeaturedCategoryFlagyes/no · max 1Optional on createUpdatable
HierarchyTypetext · max 30Required on createSearchable
ItemCategoryFlagyes/no · max 1Read-onlySearchable
LastUpdateDatedate-timeRead-only
LastUpdatedBytext · max 64Read-only
ParentCategoryIdnumberRequired on createSearchable
ParentCategoryNametext · max 255Read-only
SupplierEnabledFlagyes/no · max 255Read-onlySearchable

Names, types, labels and flags from Oracle's REST specification (26C). 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 1

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

Actions 3

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