query_resource
Query Oracle Fusion HCM resources using ADF filters, field restrictions, and inline expansions for targeted data retrieval.
Instructions
Query any Oracle Fusion HCM resource (the generic read workhorse).
q: ADF filter, e.g.PersonNumber = 100010orLastName LIKE 'Sm%'.fields: restrict returned attributes (strongly recommended to keep responses small). Usedescribe_resourceto find valid names.expand: child collections to inline. Sensitive fields (national IDs, salary, DOB) are redacted unless the deployment enables them. Filters are validated against the schema first.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| q | No | ||
| limit | No | ||
| expand | No | ||
| fields | No | ||
| offset | No | ||
| order_by | No | ||
| resource | Yes | ||
| total_results | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||