// fusionrest agent · hcm

User Column Instances

fastFormulaDatabaseItems Based on latest (2026.09)

Look up User Column Instances. Read-only.

/hcmRestApi/resources/11.13.18.05/fastFormulaDatabaseItems
Operations
GET (list)GET (one)
Record key
DatabaseItemId
Required on create
no create on this resource
At a glance
18 fields1 finders0 children
I want to…List the latest 25Count recordsGet one record

Try it

Response fields ·
Filters (q)

Only attributes Oracle marks as searchable are offered.

Finder
Paging and options
limit
Endpoint and headers
GET /hcmRestApi/resources/11.13.18.05/fastFormulaDatabaseItems?fields=BaseUserName,CreatedBy,CreationDate,DataType,DataTypeMeaning&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "BaseUserName": "<string, max 255>",
      "CreatedBy": "<string, max 64>",
      "CreationDate": "2026-01-31T09:00:00+00:00",
      "DataType": "<string, max 2>",
      "DataTypeMeaning": "<string, max 80>"
    }
  ],
  "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 18

AttributeTypeUse
BaseUserNametext · max 255
CreatedBytext · max 64Read-only
CreationDatedate-timeRead-only
DataTypetext · max 2Searchable
DataTypeMeaningtext · max 80Read-onlySearchable
DatabaseItemIdnumber
DefinitionTexttext · max 1000
Descriptiontext · max 255Searchable
LastUpdateDatedate-timeRead-only
LastUpdateLogintext · max 32Read-only
LastUpdatedBytext · max 64Read-only
LegislationCodetext · max 30Read-onlySearchable
LegislativeDataGroupIdnumberRead-onlySearchable
NullAllowedFlagyes/no · max 1 · default false
ObjectVersionNumbernumber
RelatedUserEntityIdnumberRead-onlySearchable
UserEntityIdnumber
UserNametext · max 255Searchable

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.

Use in AI Agent Studio

More in For Builders.

Pitfalls