Retrieve UE Table Data

Prev Next
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
Responses
200

OK

Headers
Content-Type
string
Exampleapplication/json
example-0

Retrieve UE Table Data

"{\n    \"items\": [\n        {\n            \"COMP_CODE\": \"VCC\",\n            \"JOB_CODE\": \"6000\",\n            \"APP_DATE\": \"2022-07-18T00:00:00-04:00\",\n            \"CONST_TYPE\": null,\n            \"UE__IU__CREATE_DATE\": \"2022-07-18T16:08:42-04:00\",\n            \"UE__IU__UPDATE_DATE\": null,\n            \"UE_CREATE_SAPORTALUSER\": null,\n            \"UE_UPDATE_SAPORTALUSER\": null\n        },\n        {\n            \"COMP_CODE\": \"CCC\",\n            \"JOB_CODE\": \"071822\",\n            \"APP_DATE\": \"2022-06-17T00:00:00-04:00\",\n            \"CONST_TYPE\": null,\n            \"UE__IU__CREATE_DATE\": \"2022-07-18T12:59:38-04:00\",\n            \"UE__IU__UPDATE_DATE\": null,\n            \"UE_CREATE_SAPORTALUSER\": null,\n            \"UE_UPDATE_SAPORTALUSER\": null\n        },\n        {\n            \"COMP_CODE\": \"CCC\",\n            \"JOB_CODE\": \"001198\",\n            \"APP_DATE\": \"2022-07-18T00:00:00-04:00\",\n            \"CONST_TYPE\": null,\n            \"UE__IU__CREATE_DATE\": \"2022-07-18T13:01:02-04:00\",\n            \"UE__IU__UPDATE_DATE\": null,\n            \"UE_CREATE_SAPORTALUSER\": null,\n            \"UE_UPDATE_SAPORTALUSER\": null\n        },\n        {\n            \"COMP_CODE\": \"KTC\",\n            \"JOB_CODE\": \"QALATEST1\",\n            \"APP_DATE\": \"2022-12-04T00:00:00-05:00\",\n            \"CONST_TYPE\": null,\n            \"UE__IU__CREATE_DATE\": \"2022-12-04T20:32:04-05:00\",\n            \"UE__IU__UPDATE_DATE\": null,\n            \"UE_CREATE_SAPORTALUSER\": null,\n            \"UE_UPDATE_SAPORTALUSER\": null\n        }\n    ],\n    \"count\": 4\n}"
example-1

Retrieve UE Table Data

"{\n    \"items\": [\n        {\n            \"COMP_CODE\": \"ZZ\",\n            \"JOB_CODE\": \"ROVER12C\",\n            \"PHASE\": \"01-100\",\n            \"CATEGORY\": \"2000\",\n            \"MAR6\": null,\n            \"UE__IU__CREATE_DATE\": \"2026-01-16T10:21:51-05:00\",\n            \"UE__IU__UPDATE_DATE\": null,\n            \"UE_CREATE_SAPORTALUSER\": null,\n            \"UE_UPDATE_SAPORTALUSER\": null\n        }\n    ],\n    \"count\": 1\n}"
string