> ## Documentation Index > Fetch the complete documentation index at: https://developers.cmicglobal.com/llms.txt > Use this file to discover all available pages before exploring further. # getAllRecords > # GET /v2/user-extension/{tableCode} — Query UE Table Data ## Overview Queries rows from a User Extension (UE) table. Supports optional column filters and audit date filtering. Filters may be supplied as raw frontend field names or as generic `objectKey` placeholders — the endpoint resolves either form to the correct columns at runtime. Call `GET /v2/user-extension/definition/{tableCode}` first if you need to know what `objectKey1`, `objectKey2`, etc. map to for a given table. | Property | Value | |---|---| | URL | `{base_url}/sys-rest-api/jersey/v2/user-extension/{tableCode}` | | Method | `GET` | | Produces | `application/json` | | Success Status | `200 OK` | | Auth | Basic (`Authorization: Basic {credentials}`) | --- ## Notes - Authentication and authorization are required. - `tableCode` is a path parameter — it goes directly in the URL. - `whereVariables` accepts two filter styles — raw field names or generic `objectKey` slots. Both styles can coexist in the same request. - When `objectKey` filters are supplied the endpoint resolves them to authoritative key values by querying the parent base table; raw field-name filters bypass that resolution step. - When no rows are found `items` is omitted and a `message` field is returned instead. - `masterTableCode` is only populated in the response when at least one `objectKey` filter was provided; otherwise it is `null`. --- ## UI Navigation User Extension tables are attached to the parent object's own screen in CMiC. There is no standalone navigation path. Use this endpoint to query data from any UE table by its table code. --- ## Finders / Query Parameters | Parameter | Type | Required | Default | Description | | --- | --- | --- | --- | --- | | `tableCode` | Path | Yes | — | UE table code (e.g. `CIITEM_K`, `PROJ_EXT`). | | `auditDate` | Query | No | — | Return only rows whose `UE__IU__CREATE_DATE` or `UE__IU__UPDATE_DATE` is on or after this date. Format must match `dateFormat`. | | `dateFormat` | Query | No | `YYYY-MM-DD` | Oracle date format mask used to parse `auditDate` and any date filter values in `whereVariables`. | | `whereVariables` | Query | No | — | Semicolon-delimited filter pairs: `FIELD=VALUE;FIELD=VALUE`. Accepts raw frontend field names **or** generic `objectKey1`–`objectKey10` slot names. | ### `whereVariables` Filter Styles **Style 1 — Raw field names** (use exact frontend column names from the UE table): ``` whereVariables=COMP_CODE=01;ITEM_CODE=BOLT-123 ``` **Style 2 — Generic objectKey slots** (resolved automatically via key mapping): ``` whereVariables=objectKey1=01;objectKey2=BOLT-123 ``` Both styles may be combined in one request. When `objectKey` values are present the endpoint performs a key-validation and resolution round-trip before executing the query. --- ## Attributes ### Response Fields | Field | Type | Description | Example | | --- | --- | --- | --- | | `tableCode` | String | The UE table code that was queried | `CIITEM_K` | | `masterTableCode` | String | Parent object table; populated only when `objectKey` filters were used, otherwise `null` | `CIITEM` | | `count` | Integer | Number of rows returned | `2` | | `items` | Array | List of row maps; each map is a `{ "COLUMN_NAME": "value" }` object. Omitted when `count` is `0`. | — | | `message` | String | Informational message when no rows are found; omitted when rows are returned | `"There is no data in this UE table."` | --- ## Examples ### Request — filter by raw field names ``` GET {base_url}/sys-rest-api/jersey/v2/user-extension/CIITEM_K?whereVariables=COMP_CODE=01;ITEM_CODE=BOLT-123 Authorization: Basic {credentials} ``` ### Response — 200 OK (rows found) ``` { "tableCode": "CIITEM_K", "masterTableCode": null, "count": 1, "items": [ { "COMP_CODE": "01", "ITEM_CODE": "BOLT-123", "UE_CODE1": "STEEL", "UE_CODE2": "FASTENER", "UE_NUM1": "12.50", "UE_DATE1": "2025-01-15" } ] } ``` --- ### Request — filter by objectKey slots ``` GET {base_url}/sys-rest-api/jersey/v2/user-extension/CIITEM_K?whereVariables=objectKey1=01;objectKey2=BOLT-123 Authorization: Basic {credentials} ``` ### Response — 200 OK (rows found, objectKey resolution performed) ``` { "tableCode": "CIITEM_K", "masterTableCode": "CIITEM", "count": 1, "items": [ { "COMP_CODE": "01", "ITEM_CODE": "BOLT-123", "UE_CODE1": "STEEL", "UE_CODE2": "FASTENER", "UE_NUM1": "12.50", "UE_DATE1": "2025-01-15" } ] } ``` --- ### Request — with audit date filter ``` GET {base_url}/sys-rest-api/jersey/v2/user-extension/CIITEM_K?auditDate=2025-01-01&dateFormat=YYYY-MM-DD Authorization: Basic {credentials} ``` ### Response — 200 OK (no rows found) ``` { "tableCode": "CIITEM_K", "masterTableCode": null, "count": 0, "message": "There is no data in this UE table." } ``` --- ### Error — Invalid Table Code (400) ``` { "error": "SD-000376-ERR: Table code 'XYZ' is not valid or the object is not supported." } ``` ### Error — Malformed whereVariables (400) ``` { "error": "Filter variable 'BADTOKEN' does not contain '=' delimiter." } ``` --- ## Error Codes | HTTP | Error Code | Reason | | --- | --- | --- | | `400` | `SD-000375-ERR` | `tableCode` path parameter is blank or missing | | `400` | `SD-000376-ERR` | Table code does not exist or the parent object is not supported by the UE API | | `400` | — | `whereVariables` contains a token without an `=` delimiter | | `400` | — | No key mapping found in `ue_master_table_tn` for the resolved master table | | `500` | — | Unhandled server error | ## OpenAPI ````json GET /sys-rest-api/jersey/v2/user-extension/CIITEM_K { "openapi": "3.0.0", "info": { "title": "API Catalog", "description": "", "version": "1.0.0" }, "servers": [ { "url": "https://mobtest.cmiccloudr12.com/cmictestrti", "description": "CMIC API Server" } ], "security": [ { "cmicBasicAuth": [] } ], "tags": [ { "name": "Highlights" }, { "name": "Asset Management | Equipment" }, { "name": "Asset Management | Fixed Assets" }, { "name": "Asset Management | Purchase Order" }, { "name": "Asset Management | Inventory" }, { "name": "Asset Management | Requisition" }, { "name": "Asset Management | Purchase Change Order" }, { "name": "Bim Model" }, { "name": "Bim Model Revision" }, { "name": "Bim Tag Model" }, { "name": "Bim Tags" }, { "name": "Bim FileUpload Jersey" }, { "name": "Core System | Business Partners" }, { "name": "Core System | Business Partner Addresses" }, { "name": "Core System | Bank" }, { "name": "Core System | Currency" }, { "name": "Core System | Exchange Rates" }, { "name": "Core System | Global Table Text Codes" }, { "name": "Core System | Global Table Regions" }, { "name": "Core System | Terms" }, { "name": "Core System | System Contact" }, { "name": "Core System | Weight Measures" }, { "name": "Core System | Field User Defined Classifiers" }, { "name": "Core System | User Defined Classifiers by Object" }, { "name": "Core System | User Extension Definitions by Object" }, { "name": "Core System | User Extention Field Data Value" }, { "name": "Core System | User Extension Values by Object" }, { "name": "Core System | User System Role" }, { "name": "Core System | User Project Role" }, { "name": "Core System | Documents by Object" }, { "name": "Core System | Audit Status Log by Object" }, { "name": "Core System | Licensed Users" }, { "name": "Core System | Company Access" }, { "name": "Core System | Copy User Settings" }, { "name": "Core System | User Maintenance" }, { "name": "Core System | User Roles" }, { "name": "Core System | Security Groups" }, { "name": "Core System | Job/Project Security" }, { "name": "Core System | Weight Measure with Conversions Code" }, { "name": "Core System | Weight Measure Conversions Code" }, { "name": "Core System | User-defined-fields" }, { "name": "Core System | User-extension" }, { "name": "ECM and Workflow | Image Manager" }, { "name": "Financials | General Ledger" }, { "name": "Financials | Accounts Payable" }, { "name": "Financials | Accounts Receivable" }, { "name": "Preventative Maintenance | Issue Work Orders" }, { "name": "Preventative Maintenance | Issue Work Items" }, { "name": "Preventative Maintenance | Issue Work Budgets" }, { "name": "Preventative Maintenance | Issue Priorities" }, { "name": "Preventative Maintenance | Issue Status" }, { "name": "Preventative Maintenance | Issue Types" }, { "name": "Preventative Maintenance | Accumulative Equipment" }, { "name": "Preventative Maintenance | Work Orders" }, { "name": "Preventative Maintenance | Work Items" }, { "name": "Preventative Maintenance | Work Budgets" }, { "name": "Preventative Maintenance | Priorities" }, { "name": "Preventative Maintenance | Tasks" }, { "name": "HCM | UKG Pay Deductions" }, { "name": "HCM | UKG Pay Earnings" }, { "name": "HCM | UKG Pay Headers" }, { "name": "HCM | UKG Pay Taxes" }, { "name": "HCM | Payroll Geographical States" }, { "name": "HCM | Payroll Trades" }, { "name": "HCM | Payroll Union" }, { "name": "HCM | Payroll Pay Runs" }, { "name": "HCM | Payroll Pay Groups" }, { "name": "HCM | Payroll Tax" }, { "name": "HCM | Payroll Worker Compensation" }, { "name": "HCM | Payroll Work Locations" }, { "name": "HCM | Payroll Trade Pay Rates" }, { "name": "HCM | Payroll Union Pay Rates" }, { "name": "HCM | Payroll Job Pay Rates" }, { "name": "HCM | Payroll Master Benefits" }, { "name": "HCM | Payroll Master Deductions" }, { "name": "HCM | Payroll Ben/Ded/Leave Base Codes" }, { "name": "HCM | Payroll Ben/Ded Plans" }, { "name": "HCM | Payroll Ben/Ded Plan Options" }, { "name": "HCM | Payroll Company Benefits" }, { "name": "HCM | Payroll Company Deductions" }, { "name": "HCM | Payroll Vertex Geographic Locations" }, { "name": "HCM | Payroll Checks" }, { "name": "HCM | Payroll Timesheets" }, { "name": "HCM | Employee" }, { "name": "HCM | Employee (Minimum payload)" }, { "name": "HCM | Employee History" }, { "name": "HCM | Tax Exemptions" }, { "name": "HCM | Employee Tax Overrides" }, { "name": "HCM | Employee Pay Splits" }, { "name": "HCM | Employee Benefits" }, { "name": "HCM | Employee Clock In and Out" }, { "name": "HCM | Employee Deductions" }, { "name": "HCM | Employee Leaves" }, { "name": "HCM | Employee Leave History" }, { "name": "HCM | Employee Hour Types" }, { "name": "HCM | Employee Pay History" }, { "name": "HCM | Employee Work Statuses" }, { "name": "HCM | Employee Security Group" }, { "name": "HCM | Crewtime Crew" }, { "name": "HCM | Crewtime Employee Timesheet" }, { "name": "HCM | Crewtime Equipment Timesheet" }, { "name": "HCM | Crew Maintenance Activity Assignment" }, { "name": "HCM | Crew Maintenance Member Assignment" }, { "name": "HCM | Crew Maintenance Member Trade and Union Assignment" }, { "name": "HCM | Crew Maintenance Equipment Assignment" }, { "name": "HCM | Crew Maintenance Equipment Detail Assignment" }, { "name": "HCM | HR Requisitions" }, { "name": "HCM | HR Relations" }, { "name": "HCM | HR Employee Skills" }, { "name": "HCM | HR Incident" }, { "name": "HCM | HR Employee Relatives / Dependents" }, { "name": "HCM | HR Employee Positions" }, { "name": "HCM | HR Applicants" }, { "name": "HCM | HR Applications" }, { "name": "HCM | Vertex Location City" }, { "name": "HCM | HR Application History" }, { "name": "HCM | HR Dependent Benefits" }, { "name": "HCM | HR Dependent Deductions" }, { "name": "HCM | HR Employee Elected Plans" }, { "name": "HCM | HR Employee Training Certifications" }, { "name": "HCM | HR Trainings" }, { "name": "HCM | E-Timesheets" }, { "name": "HCM | System Contacts" }, { "name": "HCM | System User Payroll Security Group" }, { "name": "HCM | Payroll Timesheet Posting" }, { "name": "HCM | CrewTimesheet Posting" }, { "name": "HCM | HR Positions Master" }, { "name": "HCM | Payroll Pay Periods" }, { "name": "HCM | Payroll Rate Codes" }, { "name": "HCM | Payroll Overhead Codes and Rates" }, { "name": "HCM | Payroll Assigned Overhead to Jobs" }, { "name": "Materials Management | Material Sale Orders" }, { "name": "Materials Management | Material Sale Orders Details" }, { "name": "Materials Management | Truck Rate Detail" }, { "name": "Opportunity Management | Competitors" }, { "name": "Opportunity Management | Opportunities" }, { "name": "Opportunity Management | Revenue Details" }, { "name": "Opportunity Management | Opportunity History" }, { "name": "Opportunity Management | Organization" }, { "name": "Project Controls | Job Billing" }, { "name": "Project Controls | Job Cost" }, { "name": "Project Controls | PCI Details" }, { "name": "Project Controls | Unposted PCI Details" }, { "name": "Project Controls | PCI Headers" }, { "name": "Project Controls | Owner Change Orders" }, { "name": "Project Controls | CM Statuses" }, { "name": "Project Controls | CM Types" }, { "name": "Project Controls | CM Vendor Details" }, { "name": "Project Controls | Post PCI" }, { "name": "Project Management | Uploading Documents" }, { "name": "Project Management | Downloading Documents" }, { "name": "Project Management | Foreign Bid Item Imports" }, { "name": "Project Management | Communications" }, { "name": "Project Management | Daily Journals" }, { "name": "Project Management | Communications Types" }, { "name": "Project Management | Daily Journal Daily Work Plans" }, { "name": "Project Management | Daily Journal Field Forces" }, { "name": "Project Management | Daily Journal Labour" }, { "name": "Project Management | Daily Journal Materials" }, { "name": "Project Management | Daily Journal Owner Equipment" }, { "name": "Project Management | Daily Journal Quality Control" }, { "name": "Project Management | Daily Journal Tasks" }, { "name": "Project Management | Daily Journal Trade Equipment" }, { "name": "Project Management | Daily Journal Transactions" }, { "name": "Project Management | Daily Journal User Defined Data" }, { "name": "Project Management | Daily Journal Visitors" }, { "name": "Project Management | Daily Journal Bill Details" }, { "name": "Project Management | Field Work Directives" }, { "name": "Project Management | Contract Types" }, { "name": "Project Management | Company Contacts" }, { "name": "Project Management | Distribution BCC" }, { "name": "Project Management | Distribution CC" }, { "name": "Project Management | Field Work Directive Statuses" }, { "name": "Project Management | Issues" }, { "name": "Project Management | Key Players" }, { "name": "Project Management | Meetings" }, { "name": "Project Management | Meeting Attendees" }, { "name": "Project Management | Meeting Item Statuses" }, { "name": "Project Management | Meeting Tracks" }, { "name": "Project Management | Notes" }, { "name": "Project Management | Projects" }, { "name": "Project Management | Project Items" }, { "name": "Project Management | Project Item Phase Segment Sums" }, { "name": "Project Management | Project Partners" }, { "name": "Project Management | Notices" }, { "name": "Project Management | Notice Statuses" }, { "name": "Project Management | Owner JS Query" }, { "name": "Project Management | PCI Real Locations" }, { "name": "Project Management | Project Contacts" }, { "name": "Project Management | RFIs (Requests for Information)" }, { "name": "Project Management | RFI Statuses" }, { "name": "Project Management | Submittal Packages" }, { "name": "Project Management | Submittal Package Details" }, { "name": "Project Management | Submittal Package Status" }, { "name": "Project Management | Submittals" }, { "name": "Project Management | Submittal Status" }, { "name": "Project Management | Transmittals" }, { "name": "Project Management | Subcontract Headers" }, { "name": "Project Management | Subcontract Schedules" }, { "name": "Project Management | Subcontract Sechedule Phase Segment Sums" }, { "name": "Project Management | User Roles" }, { "name": "Project Management | Punchlists" }, { "name": "Project Management | Punchlist Details" }, { "name": "Project Management | Punchlist Statuses" }, { "name": "Project Management | Meeting Items" }, { "name": "Project Management | Self Perform Vendor" }, { "name": "Project Management | Submittal Types" }, { "name": "Project Management | Assign contact and partner to project" }, { "name": "Project Management | Subcontract Prequal" }, { "name": "Project Management | Bid Item Package" } ], "paths": { "/sys-rest-api/jersey/v2/user-extension/CIITEM_K": { "get": { "tags": [ "Core System | User-extension" ], "summary": "getAllRecords", "description": "# GET /v2/user-extension/{tableCode} — Query UE Table Data\n\n## Overview\n\nQueries rows from a User Extension (UE) table. Supports optional column filters and audit date filtering. Filters may be supplied as raw frontend field names or as generic `objectKey` placeholders — the endpoint resolves either form to the correct columns at runtime. Call `GET /v2/user-extension/definition/{tableCode}` first if you need to know what `objectKey1`, `objectKey2`, etc. map to for a given table. | Property | Value | |---|---| | URL | `{base_url}/sys-rest-api/jersey/v2/user-extension/{tableCode}` | | Method | `GET` | | Produces | `application/json` | | Success Status | `200 OK` | | Auth | Basic (`Authorization: Basic {credentials}`) |\n\n---\n\n## Notes\n\n- Authentication and authorization are required.\n \n- `tableCode` is a path parameter — it goes directly in the URL.\n \n- `whereVariables` accepts two filter styles — raw field names or generic `objectKey` slots. Both styles can coexist in the same request.\n \n- When `objectKey` filters are supplied the endpoint resolves them to authoritative key values by querying the parent base table; raw field-name filters bypass that resolution step.\n \n- When no rows are found `items` is omitted and a `message` field is returned instead.\n \n- `masterTableCode` is only populated in the response when at least one `objectKey` filter was provided; otherwise it is `null`.\n \n\n---\n\n## UI Navigation\n\nUser Extension tables are attached to the parent object's own screen in CMiC. There is no standalone navigation path. Use this endpoint to query data from any UE table by its table code.\n\n---\n\n## Finders / Query Parameters\n\n| Parameter | Type | Required | Default | Description |\n| --- | --- | --- | --- | --- |\n| `tableCode` | Path | Yes | — | UE table code (e.g. `CIITEM_K`, `PROJ_EXT`). |\n| `auditDate` | Query | No | — | Return only rows whose `UE__IU__CREATE_DATE` or `UE__IU__UPDATE_DATE` is on or after this date. Format must match `dateFormat`. |\n| `dateFormat` | Query | No | `YYYY-MM-DD` | Oracle date format mask used to parse `auditDate` and any date filter values in `whereVariables`. |\n| `whereVariables` | Query | No | — | Semicolon-delimited filter pairs: `FIELD=VALUE;FIELD=VALUE`. Accepts raw frontend field names **or** generic `objectKey1`–`objectKey10` slot names. |\n\n### `whereVariables` Filter Styles\n\n**Style 1 — Raw field names** (use exact frontend column names from the UE table):\n\n```\nwhereVariables=COMP_CODE=01;ITEM_CODE=BOLT-123\n\n ```\n\n**Style 2 — Generic objectKey slots** (resolved automatically via key mapping):\n\n```\nwhereVariables=objectKey1=01;objectKey2=BOLT-123\n\n ```\n\nBoth styles may be combined in one request. When `objectKey` values are present the endpoint performs a key-validation and resolution round-trip before executing the query.\n\n---\n\n## Attributes\n\n### Response Fields\n\n| Field | Type | Description | Example |\n| --- | --- | --- | --- |\n| `tableCode` | String | The UE table code that was queried | `CIITEM_K` |\n| `masterTableCode` | String | Parent object table; populated only when `objectKey` filters were used, otherwise `null` | `CIITEM` |\n| `count` | Integer | Number of rows returned | `2` |\n| `items` | Array | List of row maps; each map is a `{ \"COLUMN_NAME\": \"value\" }` object. Omitted when `count` is `0`. | — |\n| `message` | String | Informational message when no rows are found; omitted when rows are returned | `\"There is no data in this UE table.\"` |\n\n---\n\n## Examples\n\n### Request — filter by raw field names\n\n```\nGET {base_url}/sys-rest-api/jersey/v2/user-extension/CIITEM_K?whereVariables=COMP_CODE=01;ITEM_CODE=BOLT-123\nAuthorization: Basic {credentials}\n\n ```\n\n### Response — 200 OK (rows found)\n\n```\n{\n \"tableCode\": \"CIITEM_K\",\n \"masterTableCode\": null,\n \"count\": 1,\n \"items\": [\n {\n \"COMP_CODE\": \"01\",\n \"ITEM_CODE\": \"BOLT-123\",\n \"UE_CODE1\": \"STEEL\",\n \"UE_CODE2\": \"FASTENER\",\n \"UE_NUM1\": \"12.50\",\n \"UE_DATE1\": \"2025-01-15\"\n }\n ]\n}\n\n ```\n\n---\n\n### Request — filter by objectKey slots\n\n```\nGET {base_url}/sys-rest-api/jersey/v2/user-extension/CIITEM_K?whereVariables=objectKey1=01;objectKey2=BOLT-123\nAuthorization: Basic {credentials}\n\n ```\n\n### Response — 200 OK (rows found, objectKey resolution performed)\n\n```\n{\n \"tableCode\": \"CIITEM_K\",\n \"masterTableCode\": \"CIITEM\",\n \"count\": 1,\n \"items\": [\n {\n \"COMP_CODE\": \"01\",\n \"ITEM_CODE\": \"BOLT-123\",\n \"UE_CODE1\": \"STEEL\",\n \"UE_CODE2\": \"FASTENER\",\n \"UE_NUM1\": \"12.50\",\n \"UE_DATE1\": \"2025-01-15\"\n }\n ]\n}\n\n ```\n\n---\n\n### Request — with audit date filter\n\n```\nGET {base_url}/sys-rest-api/jersey/v2/user-extension/CIITEM_K?auditDate=2025-01-01&dateFormat=YYYY-MM-DD\nAuthorization: Basic {credentials}\n\n ```\n\n### Response — 200 OK (no rows found)\n\n```\n{\n \"tableCode\": \"CIITEM_K\",\n \"masterTableCode\": null,\n \"count\": 0,\n \"message\": \"There is no data in this UE table.\"\n}\n\n ```\n\n---\n\n### Error — Invalid Table Code (400)\n\n```\n{\n \"error\": \"SD-000376-ERR: Table code 'XYZ' is not valid or the object is not supported.\"\n}\n\n ```\n\n### Error — Malformed whereVariables (400)\n\n```\n{\n \"error\": \"Filter variable 'BADTOKEN' does not contain '=' delimiter.\"\n}\n\n ```\n\n---\n\n## Error Codes\n\n| HTTP | Error Code | Reason |\n| --- | --- | --- |\n| `400` | `SD-000375-ERR` | `tableCode` path parameter is blank or missing |\n| `400` | `SD-000376-ERR` | Table code does not exist or the parent object is not supported by the UE API |\n| `400` | — | `whereVariables` contains a token without an `=` delimiter |\n| `400` | — | No key mapping found in `ue_master_table_tn` for the resolved master table |\n| `500` | — | Unhandled server error |", "responses": { "200": { "description": "OK", "headers": { "Content-Type": { "schema": { "type": "string", "example": "application/json" } } }, "content": { "text/plain": { "schema": { "type": "string" }, "examples": { "example-0": { "summary": "getAllRecords", "value": "{\n \"tableCode\": \"CIITEM_K\",\n \"masterTableCode\": \"CIITEM\",\n \"count\": 20,\n \"items\": [\n {\n \"COMP_CODE\": \"ZZ\",\n \"ITEM_CODE\": \"DIESEL\",\n \"NUMBEROKEY\": \"8\",\n \"AAA\": \"Yash\",\n \"UE__IU__CREATE_DATE\": \"2026-05-28T13:22:25-04:00\",\n \"UE__IU__UPDATE_DATE\": null,\n \"CLTEST\": null\n },\n {\n \"COMP_CODE\": \"ZZ\",\n \"ITEM_CODE\": \"DIESEL\",\n \"NUMBEROKEY\": \"9\",\n \"AAA\": \"Yash\",\n \"UE__IU__CREATE_DATE\": \"2026-05-28T13:22:35-04:00\",\n \"UE__IU__UPDATE_DATE\": null,\n \"CLTEST\": null\n },\n {\n \"COMP_CODE\": \"ZZ\",\n \"ITEM_CODE\": \"DIESEL\",\n \"NUMBEROKEY\": \"20\",\n \"AAA\": \"YashBhavsar@\",\n \"UE__IU__CREATE_DATE\": \"2026-06-22T23:56:15-04:00\",\n \"UE__IU__UPDATE_DATE\": null,\n \"CLTEST\": null\n },\n {\n \"COMP_CODE\": \"ZZ\",\n \"ITEM_CODE\": \"DIESEL\",\n \"NUMBEROKEY\": \"15\",\n \"AAA\": \"YashBhavsar@\",\n \"UE__IU__CREATE_DATE\": \"2026-05-29T11:38:31-04:00\",\n \"UE__IU__UPDATE_DATE\": null,\n \"CLTEST\": null\n },\n {\n \"COMP_CODE\": \"ZZ\",\n \"ITEM_CODE\": \"DIESEL\",\n \"NUMBEROKEY\": \"3\",\n \"AAA\": \"Yash\",\n \"UE__IU__CREATE_DATE\": \"2026-05-27T20:13:27-04:00\",\n \"UE__IU__UPDATE_DATE\": null,\n \"CLTEST\": null\n },\n {\n \"COMP_CODE\": \"ZZ\",\n \"ITEM_CODE\": \"DIESEL\",\n \"NUMBEROKEY\": \"14\",\n \"AAA\": \"YashBhavsar@\",\n \"UE__IU__CREATE_DATE\": \"2026-05-29T11:38:20-04:00\",\n \"UE__IU__UPDATE_DATE\": null,\n \"CLTEST\": null\n },\n {\n \"COMP_CODE\": \"ZZ\",\n \"ITEM_CODE\": \"DIESEL\",\n \"NUMBEROKEY\": \"18\",\n \"AAA\": \"YashBha\",\n \"UE__IU__CREATE_DATE\": \"2026-06-02T12:01:09-04:00\",\n \"UE__IU__UPDATE_DATE\": \"2026-06-23T00:02:11-04:00\",\n \"CLTEST\": null\n },\n {\n \"COMP_CODE\": \"CL02\",\n \"ITEM_CODE\": \"SAND\",\n \"NUMBEROKEY\": \"10\",\n \"AAA\": \"TestValue\",\n \"UE__IU__CREATE_DATE\": \"2026-05-22T14:33:45-04:00\",\n \"UE__IU__UPDATE_DATE\": null,\n \"CLTEST\": \"SomeData\"\n },\n {\n \"COMP_CODE\": \"ZZ\",\n \"ITEM_CODE\": \"DIESEL\",\n \"NUMBEROKEY\": \"19\",\n \"AAA\": \"YashBhavsar@\",\n \"UE__IU__CREATE_DATE\": \"2026-06-03T11:20:28-04:00\",\n \"UE__IU__UPDATE_DATE\": null,\n \"CLTEST\": null\n },\n {\n \"COMP_CODE\": \"ZZ\",\n \"ITEM_CODE\": \"DIESEL\",\n \"NUMBEROKEY\": \"2\",\n \"AAA\": \"Yash\",\n \"UE__IU__CREATE_DATE\": \"2026-05-27T16:48:25-04:00\",\n \"UE__IU__UPDATE_DATE\": null,\n \"CLTEST\": null\n },\n {\n \"COMP_CODE\": \"CL02\",\n \"ITEM_CODE\": \"1010209\",\n \"NUMBEROKEY\": \"1\",\n \"AAA\": \"Carrie\",\n \"UE__IU__CREATE_DATE\": \"2026-05-15T15:07:54-04:00\",\n \"UE__IU__UPDATE_DATE\": null,\n \"CLTEST\": null\n },\n {\n \"COMP_CODE\": \"CL02\",\n \"ITEM_CODE\": \"1010209\",\n \"NUMBEROKEY\": \"2\",\n \"AAA\": \"Test 2\",\n \"UE__IU__CREATE_DATE\": \"2026-05-15T15:07:54-04:00\",\n \"UE__IU__UPDATE_DATE\": null,\n \"CLTEST\": null\n },\n {\n \"COMP_CODE\": \"CL02\",\n \"ITEM_CODE\": \"ACTU0026\",\n \"NUMBEROKEY\": \"1\",\n \"AAA\": \"API Test 1\",\n \"UE__IU__CREATE_DATE\": \"2026-05-15T15:09:39-04:00\",\n \"UE__IU__UPDATE_DATE\": null,\n \"CLTEST\": null\n },\n {\n \"COMP_CODE\": \"CL02\",\n \"ITEM_CODE\": \"ACTU0026\",\n \"NUMBEROKEY\": \"2\",\n \"AAA\": \"API Test 2\",\n \"UE__IU__CREATE_DATE\": \"2026-05-15T15:09:39-04:00\",\n \"UE__IU__UPDATE_DATE\": null,\n \"CLTEST\": null\n },\n {\n \"COMP_CODE\": \"ZZ\",\n \"ITEM_CODE\": \"DIESEL\",\n \"NUMBEROKEY\": \"4\",\n \"AAA\": \"Yash\",\n \"UE__IU__CREATE_DATE\": \"2026-05-27T23:47:32-04:00\",\n \"UE__IU__UPDATE_DATE\": null,\n \"CLTEST\": null\n },\n {\n \"COMP_CODE\": \"ZZ\",\n \"ITEM_CODE\": \"DIESEL\",\n \"NUMBEROKEY\": \"5\",\n \"AAA\": \"Yash\",\n \"UE__IU__CREATE_DATE\": \"2026-05-27T23:47:56-04:00\",\n \"UE__IU__UPDATE_DATE\": null,\n \"CLTEST\": null\n },\n {\n \"COMP_CODE\": \"ZZ\",\n \"ITEM_CODE\": \"DIESEL\",\n \"NUMBEROKEY\": \"6\",\n \"AAA\": \"Yash\",\n \"UE__IU__CREATE_DATE\": \"2026-05-27T23:50:48-04:00\",\n \"UE__IU__UPDATE_DATE\": null,\n \"CLTEST\": null\n },\n {\n \"COMP_CODE\": \"ZZ\",\n \"ITEM_CODE\": \"DIESEL\",\n \"NUMBEROKEY\": \"7\",\n \"AAA\": \"Yash\",\n \"UE__IU__CREATE_DATE\": \"2026-05-27T23:53:22-04:00\",\n \"UE__IU__UPDATE_DATE\": null,\n \"CLTEST\": null\n },\n {\n \"COMP_CODE\": \"ZZ\",\n \"ITEM_CODE\": \"DIESEL\",\n \"NUMBEROKEY\": \"10\",\n \"AAA\": \"YashBhavsar\",\n \"UE__IU__CREATE_DATE\": \"2026-05-28T13:44:26-04:00\",\n \"UE__IU__UPDATE_DATE\": \"2026-05-28T14:09:13-04:00\",\n \"CLTEST\": null\n },\n {\n \"COMP_CODE\": \"ZZ\",\n \"ITEM_CODE\": \"DIESEL\",\n \"NUMBEROKEY\": \"17\",\n \"AAA\": \"YashBhavsar@\",\n \"UE__IU__CREATE_DATE\": \"2026-05-29T18:44:57-04:00\",\n \"UE__IU__UPDATE_DATE\": null,\n \"CLTEST\": null\n }\n ],\n \"message\": null\n}" }, "example-1": { "summary": "getSpecificRecord", "value": "{\n \"tableCode\": \"POSUMM\",\n \"masterTableCode\": \"POSUMMARY\",\n \"count\": 1,\n \"items\": [\n {\n \"POPF1\": \"yash\",\n \"POPF2\": null,\n \"UE__IU__CREATE_DATE\": \"2026-06-25T14:06:38-04:00\",\n \"UE__IU__UPDATE_DATE\": null\n }\n ],\n \"message\": null\n}" } } } } } } } } }, "components": { "securitySchemes": { "cmicBasicAuth": { "type": "http", "scheme": "basic", "description": "Basic authentication" } } } } ````