Retrieve UE Table Data
- 27 Feb 2025
- 1 Minute to read
- Print
- DarkLight
Retrieve UE Table Data
- Updated on 27 Feb 2025
- 1 Minute to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback!
Get
/sys-rest-api/jersey/v1/userextensions/{UETableCode}
Query Standards
Path Parameter
The UE Table Code to be queried must be informed in the URL. Example:
.../sys-rest-api/jersey/v1/userextensions/MY_UE_TAB
Query Parameters
Query parameters. All parameters are optional.
| Parameter | Description | Sample |
|---|---|---|
| auditDate | Audit Date | 2024-03-10 |
| dateFormat | Date Format. If not informed, YYYY-MM-DD is assumed | DD-MM-YYYY |
| whereVariables | List of columns and values to filter data, separated by semi-colon. | COMP_CODE=001;ITEM_CODE=ABC |
Security
HTTP
Type basic
Basic authentication
Path parameters
UETableCode
stringRequired
Query parameters
auditDate
string
Example2024-03-10
dateFormat
string
ExampleYYYY-MM-DD
whereVariables
string
Example{{column1}}={{value1}};{{column2}}={{value2}}
Responses
200
OK
Headers
Content-Type
string
Exampleapplication/vnd.oracle.adf.resourcecollection+json
{
"items": [
{
"COMP_CODE": "FCM",
"ITEM_CODE": "PAPER",
"COMMENTS1": "Test Description",
"UE__IU__CREATE_DATE": "2024-06-07T17:03:34Z",
"UE__IU__UPDATE_DATE": null
}
],
"count": 1
}object