# API Lookups

{% hint style="warning" %}
**Limited Support/End of Life Capabilities**

The Classic API has been replaced by the Alemba RestFul API.  While we will continue to support the Classic API for clients that are still using it, no further development will be done.

If you need to request a hotfix or support for these features, please contact [<mark style="color:blue;">**Alemba Support**</mark>](https://alemba.help/production/Portal.aspx)
{% endhint %}

ASM has two Application Programming Interfaces (or APIs), which enable you to develop programs that automate many common ASM transactions. This section of the documentation deals with the Classic API.&#x20;

All lookup input fields in the API are declared with the prefix “l”; for example,

`InputParams.lCustomer`.

Every lookup field can be used to search by a ref or name. If the input value begins with a tilde (\~), the search will be performed by ref. Otherwise, the search will be performed by name. The name that can be used in the lookup is specific to each lookup.

> If lCustomer = `~20`, the API will search for Users where **REF=20**. If lCustomer = `joeBloggs@alemba.com`, the API will search for Users where **EMAIL\_ID=<joeBloggs@alemba.com>**. If lCustomer = `~joeBloggs`, the API will return an error.

> If lOfficer = `~20`, then API will search for Analysts where **REF=20**. If lOfficer = `JoeB12`, the API will search for Analysts where **USER\_ID=JoeB12**. If lOfficer = `joeBloggs@alemba.com`, the API will return an error.

> If lSentBy = `~2`0, the API will search for Person records where **REF=20**. If lSentBy = `Joe Bloggs`, the API will search for Person records where **DISPLAY=Joe Bloggs**. If lSentBy = `JoeB12`, the API will return an error.

The tables below list the ref and name fields (Ref Field and Value Field respectively) in each table that can be used in each type of lookup.

### CMDB Item Lookups

#### Class

<table data-header-hidden><thead><tr><th width="201"></th><th></th></tr></thead><tbody><tr><td>Table:</td><td>AR_CLASS</td></tr><tr><td>Ref Field:</td><td>REF</td></tr><tr><td>Value Field:</td><td>NAME</td></tr></tbody></table>

#### Criticality

<table data-header-hidden><thead><tr><th width="201"></th><th></th></tr></thead><tbody><tr><td>Table:</td><td>AR_CRITICALITY</td></tr><tr><td>Ref Field:</td><td>REF</td></tr><tr><td>Value Field:</td><td>NAME</td></tr></tbody></table>

#### Disposal Method

<table data-header-hidden><thead><tr><th width="206"></th><th></th></tr></thead><tbody><tr><td>Table:</td><td>AR_DISPOSAL_METHOD</td></tr><tr><td>Ref Field:</td><td>REF</td></tr><tr><td>Value Field:</td><td>NAME</td></tr></tbody></table>

#### Financial Category

| Table:       | AR\_FINANCIAL\_CATEGORY |
| ------------ | ----------------------- |
| Ref Field:   | REF                     |
| Value Field: | NAME                    |

#### Financial Status

| Table:       | AR\_FIN\_STATUS |
| ------------ | --------------- |
| Ref Field:   | REF             |
| Value Field: | NAME            |

#### Link Status

| Table:       | AR\_CRITICALITY |
| ------------ | --------------- |
| Ref Field:   | REF             |
| Value Field: | NAME            |

#### Manufacturer

| Table:       | AR\_MANUFACTURER |
| ------------ | ---------------- |
| Ref Field:   | REF              |
| Value Field: | NAME             |

#### Model

| Table:       | AR\_MODEL\_TYPES |
| ------------ | ---------------- |
| Ref Field:   | REF              |
| Value Field: | NAME             |

#### Physical Status

| Table:       | AR\_PHYSICAL\_STATUS |
| ------------ | -------------------- |
| Ref Field:   | REF                  |
| Value Field: | NAME                 |

#### Purchase Method

| Table:       | AR\_PURCHASE\_METHOD |
| ------------ | -------------------- |
| Ref Field:   | REF                  |
| Value Field: | NAME                 |

#### Service Level

| Table:       | AR\_USER\_CATEGORY |
| ------------ | ------------------ |
| Ref Field:   | REF                |
| Value Field: | DESCRIPTION        |

#### CMDB Item Type

| Table:       | SU\_ENTITY\_TYPE |
| ------------ | ---------------- |
| Ref Field:   | REF              |
| Value Field: | DISPLAY          |

#### CMDB Item

| Table:       | AR\_PRIMARY\_ASSET |
| ------------ | ------------------ |
| Ref Field:   | ITEM\_REF          |
| Value Field: | ASSET\_REF         |

#### Service Action

| Table:       | AR\_PRIMARY\_ASSET |
| ------------ | ------------------ |
| Ref Field:   | ITEM\_REF          |
| Value Field: | ASSET\_REF         |

#### Service Bundle

| Table:       | AR\_PRIMARY\_ASSET |
| ------------ | ------------------ |
| Ref Field:   | ITEM\_REF          |
| Value Field: | ASSET\_REF         |

#### Service

| Table:       | AR\_PRIMARY\_ASSET |
| ------------ | ------------------ |
| Ref Field:   | ITEM\_REF          |
| Value Field: | ASSET\_REF         |

#### Configuration Item

| Table:       | AR\_PRIMARY\_ASSET |
| ------------ | ------------------ |
| Ref Field:   | ITEM\_REF          |
| Value Field: | ASSET\_REF         |

### Organization (and External Supplier) Lookups

#### Organization

| Table:       | AR\_CLIENT\_COMPANY |
| ------------ | ------------------- |
| Ref Field:   | CLIENT\_CO\_REF     |
| Value Field: | CLIENT\_CO\_NAME    |

#### Location

| Table:       | AR\_CLIENT\_COMPANY |
| ------------ | ------------------- |
| Ref Field:   | CLIENT\_CO\_REF     |
| Value Field: | CLIENT\_CO\_NAME    |

#### Profile

| Table:       | AR\_INDUSTRIES |
| ------------ | -------------- |
| Ref Field:   | INDUSTRY\_REF  |
| Value Field: | INDUSTRY\_NAME |

#### Service Level

| Table:       | AR\_USER\_CATEGORY |
| ------------ | ------------------ |
| Ref Field:   | REF                |
| Value Field: | DESCRIPTION        |

#### External Supplier

| Table:       | AR\_CLIENT\_COMPANY |
| ------------ | ------------------- |
| Ref Field:   | CLIENT\_CO\_REF     |
| Value Field: | CLIENT\_CO\_NAME    |

#### External Supplier Status

| Table:       | AR\_ORGANIZATION\_STATUS |
| ------------ | ------------------------ |
| Ref Field:   | REF                      |
| Value Field: | NAME                     |

### Person Lookups

#### Person

<table data-header-hidden><thead><tr><th width="362"></th><th></th></tr></thead><tbody><tr><td>Table:</td><td>AR_PERSON</td></tr><tr><td>Ref Field:</td><td>REF</td></tr><tr><td>Value Field:</td><td>DISPLAY</td></tr></tbody></table>

#### User

| Table:       | AR\_PERSON |
| ------------ | ---------- |
| Ref Field:   | REF        |
| Value Field: | EMAIL\_ID  |

#### Email Format

| Table:       | HD\_FORMAT |
| ------------ | ---------- |
| Ref Field:   | REF        |
| Value Field: | NAME       |

#### Self Service Portal Role

| Table:       | SU\_CUSTOMER\_ROLE |
| ------------ | ------------------ |
| Ref Field:   | REF                |
| Value Field: | NAME               |

#### User Profile

| Table:       | AR\_DEPARTMENT |
| ------------ | -------------- |
| Ref Field:   | REF            |
| Value Field: | NAME           |

#### Service Level

| Table:       | AR\_USER\_CATEGORY |
| ------------ | ------------------ |
| Ref Field:   | REF                |
| Value Field: | DESCRIPTION        |

#### VIP Status

| Table:       | AR\_VIP\_STATUS |
| ------------ | --------------- |
| Ref Field:   | REF             |
| Value Field: | NAME            |

#### Location

| Table:       | AR\_LOCATIONS |
| ------------ | ------------- |
| Ref Field:   | REF           |
| Value Field: | NAME          |

#### Analyst

| Table:       | AR\_PERSON |
| ------------ | ---------- |
| Ref Field:   | REF        |
| Value Field: | USER\_ID   |

#### External Contact

| Table:       | AR\_PERSON |
| ------------ | ---------- |
| Ref Field:   | REF        |
| Value Field: | FULL\_NAME |

### Location Lookups

#### Location

| Table:       | AR\_LOCATIONS  |
| ------------ | -------------- |
| Ref Field:   | LOCATION\_REF  |
| Value Field: | LOCATION\_NAME |

### Contract Lookups

#### Contract

| Table:       | AR\_CONTRACTS     |
| ------------ | ----------------- |
| Ref Field:   | REF               |
| Value Field: | CO\_CONTRACT\_REF |

#### External Contract

| Table:       | AR\_CONTRACTS     |
| ------------ | ----------------- |
| Ref Field:   | REF               |
| Value Field: | CO\_CONTRACT\_REF |

#### Contract Type

| Table:       | SU\_ENTITY\_TYPE |
| ------------ | ---------------- |
| Ref Field:   | REF              |
| Value Field: | DISPLAY          |

### Cost Center Lookups

#### Cost Center

| Table:       | AR\_COST\_CENTRE |
| ------------ | ---------------- |
| Ref Field:   | REF              |
| Value Field: | NAME             |

#### Cost Center Link

| Table:       | AR\_COST\_CENTRE |
| ------------ | ---------------- |
| Ref Field:   | LINK\_REF        |
| Value Field: | NAME             |

#### Cost Center Category

| Table:       | AR\_COST\_CENTRE\_CATEGORY |
| ------------ | -------------------------- |
| Ref Field:   | REF                        |
| Value Field: | NAME                       |

### Subscriber Group Lookups

#### Subscriber Group

| Table:       | AR\_SUBSCRIBER\_GROUP |
| ------------ | --------------------- |
| Ref Field:   | REF                   |
| Value Field: | NAME                  |

### Jurisdiction Lookups

#### Jurisdiction

| Table:       | AR\_JURISDICTION |
| ------------ | ---------------- |
| Ref Field:   | REF              |
| Value Field: | NAME             |

### Administration Lookups

#### Security Profile

| Table:       | SU\_SECURITY\_PROFILE |
| ------------ | --------------------- |
| Ref Field:   | REF                   |
| Value Field: | NAME                  |

#### Partition

| Table:       | SU\_PARTITIONS |
| ------------ | -------------- |
| Ref Field:   | REF            |
| Value Field: | NAME           |

#### Source

| Table:       | IN\_SYS\_SOURCE |
| ------------ | --------------- |
| Ref Field:   | REF             |
| Value Field: | NAME            |

#### Format

| Table:       | HD\_FORMAT |
| ------------ | ---------- |
| Ref Field:   | REF        |
| Value Field: | NAME       |

#### Time Zone

| Table:       | SA\_TIMEZONE |
| ------------ | ------------ |
| Ref Field:   | REF          |
| Value Field: | NAME         |

### IPK Group Lookups

#### IPK Group

| Table:       | SU\_SUPPORT\_GROUP |
| ------------ | ------------------ |
| Ref Field:   | REF                |
| Value Field: | NAME               |

### Workflow Group Lookups

#### Workflow Group

| Table:       | CR\_GROUP |
| ------------ | --------- |
| Ref Field:   | REF       |
| Value Field: | NAME      |

### Bulletin Lookups

#### Bulletin

| Table:       | BB\_ENTRY     |
| ------------ | ------------- |
| Ref Field:   | BULLETIN\_REF |
| Value Field: | TITLE         |

#### Bulletin Priority

| Table:       | BB\_PRIORITY |
| ------------ | ------------ |
| Ref Field:   | REF          |
| Value Field: | NAME         |

### Workflow (Request) Lookups

#### Request

| Table:       | CR\_REQUEST    |
| ------------ | -------------- |
| Ref Field:   | REQUEST\_NO    |
| Value Field: | REQUEST\_TITLE |

#### Implementation Profile

| Table:       | CR\_IMPL\_PROFILE |
| ------------ | ----------------- |
| Ref Field:   | REF\_COMPOSITE    |
| Value Field: | NAME\_1           |

#### Implementation State

| Table:       | CR\_IMPLEMENTATION\_STATE |
| ------------ | ------------------------- |
| Ref Field:   | REF                       |
| Value Field: | NAME                      |

#### Priority

| Table:       | CR\_REQ\_PRIORITY |
| ------------ | ----------------- |
| Ref Field:   | REF               |
| Value Field: | NAME              |

#### Risk

| Table:       | CR\_REQ\_RISK |
| ------------ | ------------- |
| Ref Field:   | REF           |
| Value Field: | NAME          |

#### Status

| Table:       | CR\_REQ\_STATUS |
| ------------ | --------------- |
| Ref Field:   | REF             |
| Value Field: | NAME            |

#### Workflow Template

| Table:       | CR\_REQUEST    |
| ------------ | -------------- |
| Ref Field:   | REQUEST\_NO    |
| Value Field: | T\_PLATE\_NAME |

#### Type

| Table:       | CR\_REQ\_TYPE  |
| ------------ | -------------- |
| Ref Field:   | REF\_COMPOSITE |
| Value Field: | NAME\_1        |

#### Action Type

| Table:       | CR\_REQ\_ACTIVITY |
| ------------ | ----------------- |
| Ref Field:   | REF               |
| Value Field: | NAME              |

#### Phase

| Table:       | CR\_TASK\_PHASE |
| ------------ | --------------- |
| Ref Field:   | REF             |
| Value Field: | NAME            |

### Task Lookups

#### Task

| Table:       | CR\_TASK |
| ------------ | -------- |
| Ref Field:   | TASK\_NO |
| Value Field: | -        |

#### Task Type

| Table:       | CR\_TASK\_TYPE |
| ------------ | -------------- |
| Ref Field:   | REF            |
| Value Field: | NAME           |

#### Action Type

| Table:       | CR\_HIST\_ACTIVITY |
| ------------ | ------------------ |
| Ref Field:   | REF                |
| Value Field: | NAME               |

#### Task Phase

| Table:       | CR\_TASK\_PHASE |
| ------------ | --------------- |
| Ref Field:   | REF             |
| Value Field: | NAME            |

#### Task Priority

| Table:       | CR\_TASK\_PRIORITY |
| ------------ | ------------------ |
| Ref Field:   | REF                |
| Value Field: | NAME               |

#### Task Status

| Table:       | CR\_TASK\_STATUS |
| ------------ | ---------------- |
| Ref Field:   | REF              |
| Value Field: | NAME             |

### Call Lookups

#### Call

| Table:       | CL\_CALL\_LOGGING |
| ------------ | ----------------- |
| Ref Field:   | CALL\_NUMBER      |
| Value Field: | CALL\_REF         |

#### Action Type

| Table:       | CL\_HIST\_ACTIVITY |
| ------------ | ------------------ |
| Ref Field:   | REF                |
| Value Field: | NAME               |

#### Impact

| Table:       | CL\_IMPACT |
| ------------ | ---------- |
| Ref Field:   | REF        |
| Value Field: | NAME       |

#### Priority

| Table:       | SU\_CALL\_PRIORITY |
| ------------ | ------------------ |
| Ref Field:   | REF                |
| Value Field: | NAME               |

#### Reason

| Table:       | CL\_REASONS  |
| ------------ | ------------ |
| Ref Field:   | REF          |
| Value Field: | REASON\_NAME |

#### Call Status

| Table:       | CL\_CALL\_STATUS |
| ------------ | ---------------- |
| Ref Field:   | REF              |
| Value Field: | NAME             |

#### Call Template

| Table:       | CL\_CALL\_LOGGING |
| ------------ | ----------------- |
| Ref Field:   | CALL\_NUMBER      |
| Value Field: | T\_PLATE\_NAME    |

#### Call Screen

| Table:       | SU\_EDIT\_SCREENS |
| ------------ | ----------------- |
| Ref Field:   | SCREEN\_TYPE\_REF |
| Value Field: | NAME              |

#### Urgency

| Table:       | CL\_URGENCY |
| ------------ | ----------- |
| Ref Field:   | REF         |
| Value Field: | NAME        |

#### IPK Stream

| Table:       | CL\_IPK\_STREAM |
| ------------ | --------------- |
| Ref Field:   | REF             |
| Value Field: | NAME            |

#### IPK Status

| Table:       | CL\_IPK\_STATUS |
| ------------ | --------------- |
| Ref Field:   | REF             |
| Value Field: | NAME            |

#### Type

| Table:       | CL\_PROBLEM\_TYPE |
| ------------ | ----------------- |
| Ref Field:   | REF\_COMPOSITE    |
| Value Field: | NAME\_1           |

### Knowledge Lookups

#### Knowledge

| Table:       | KB\_ENTRY      |
| ------------ | -------------- |
| Ref Field:   | KNOWLEDGE\_REF |
| Value Field: | EXTERNAL\_REF  |

#### Profile

| Table:       | KB\_PROFILE |
| ------------ | ----------- |
| Ref Field:   | REF         |
| Value Field: | NAME\_1     |

#### Rating

| Table:       | KB\_RATING  |
| ------------ | ----------- |
| Ref Field:   | REF         |
| Value Field: | SHORT\_DESC |

#### Status

| Table:       | KB\_ENTRY\_STATUS |
| ------------ | ----------------- |
| Ref Field:   | REF               |
| Value Field: | NAME              |

#### Type

| Table:       | SU\_ENTITY\_TYPE |
| ------------ | ---------------- |
| Ref Field:   | REF              |
| Value Field: | DISPLAY          |

### Stakeholder Lookups

#### Stakeholder

| Table:       | SU\_ENTITY\_TYPE |
| ------------ | ---------------- |
| Ref Field:   | REF              |
| Value Field: | DISPLAY          |

#### Link Type

| Table:       | SU\_ENTITY\_TYPE |
| ------------ | ---------------- |
| Ref Field:   | REF              |
| Value Field: | DISPLAY          |

#### Link

| Table:       | SH\_LINK  |
| ------------ | --------- |
| Ref Field:   | LINK\_REF |
| Value Field: | -         |

### Attribute Lookups

#### Attribute Tier

| Table:       | HD\_ATTRIBUTE |
| ------------ | ------------- |
| Ref Field:   | REF           |
| Value Field: | NAME\_1       |

### Agreement Lookups

#### Agreement

| Table:       | SA\_AGREEMENT  |
| ------------ | -------------- |
| Ref Field:   | AGREEMENT\_NO  |
| Value Field: | AGREEMENT\_REF |

### Availability Lookups

#### Outage Type

| Table:       | AM\_OUTAGE\_TYPE    |
| ------------ | ------------------- |
| Ref Field:   | OUTAGE\_TYPE\_REF   |
| Value Field: | OUTAGE\_TYPE\_TITLE |