General - Get lookup list

API Url

Get master data lookup list for departments, groups, employees, users, etc.

GET

http://localhost:16010/ProMarkREST/web/General/lookup/{table}

Permissions: user

Path parameters

Field	Type	Description
table	String	Table mnemonic: "dept", "EmpGrp", "EmpList", "Usr", "division", etc.

Query parameters

Field	Type	Description
date`optional`	Date	Date for time-sensitive restrictions.
dynamicValues`optional`	Boolean	false=Exclude dynamic values (@@DEPT_ID, etc). Default: true.
empId`optional`	String	Employee ID for context-specific lookups.
inclInactive`optional`	Boolean	true=Include inactive records. Default: false.
options`optional`	String	Various options (parent id for cascading lookups).

Success 200

Field	Type	Description
lookupList	Object[]	List of lookup values.
bgColor	String	Background color (HEX).
desc	String	Description.
fgColor	String	Foreground color (HEX).
id	String	Unique identifier.
inactive	Boolean	true if record is inactive.
shortDesc	String	Short description.
sortId	String	Right-aligned id for sorting.

Success example for departments:

HTTP/1.1 200 OK
{
   "response": {
      "data": {
         "lookupList": [
            {
               "id": "PROD",
               "sortId": "!!!!PROD",
               "desc": "Production",
               "shortDesc": "Prod",
               "fgColor": "",
               "bgColor": "",
               "inactive": false
            },
            {
               "id": "ADMIN",
               "sortId": "!!!ADMIN",
               "desc": "Administration",
               "shortDesc": "Admin",
               "fgColor": "",
               "bgColor": "",
               "inactive": false
            }
         ]
      },
      "errorCode": 0,
      "errorMessage": ""
   }
}