Nav

Lookup Tables

Anypoint Partner Manager (APM) enables you to create, populate and edit a lookup table. A lookup table is a table that facilitates transaction processing by associating values. For example, this page shows how to create a lookup table that associates internal partner product codes with customer product codes.

Get Started

These settings are editable for your company (as identified on the Partner Configuration Page) only.
  1. Start APM. When the Transaction Monitoring Page appears, return to this page and procede to the next step.

  2. In the left-hand navigation pane, click Administration. The Administration Page appears.

  3. If you want to create a lookup table or edit the name, fields or keys for an existing table, go to Administer a Lookup Table. The fields you add will become the columns of the table.

    If you want to enter data for a table, go to Working with Lookup Table Data. The data that you add for each field will populate the rows of the field.

Administer a Lookup Table

  1. In the ADMINISTRATION section of the left-hand navigation pane on the Company Information Page, click Lookup Tables Admin.

img-lookup-tables-admin
Figure 1. Lookup Tables Admin Page

Create a Lookup Table

This section shows you how to use the APM user interface to create a lookup table. Alternatively, you can create a lookup table through calls to the Anypoint Partner Manager API; see Create a Lookup Table. See Create a Lookup Table also for instructions for querying a table.

To Create a Lookup Table

  1. On the Lookup Tables Admin Page, click New. The Lookup Table Page appears.

img-lookup
Figure 2. Lookup Table Page
  1. On the Lookup Table Page, in the Name box, enter a name for this lookup table, then click Save.

    The Add Field and Add Key bars appear.

    Because a lookup table must have at least one field before you can add a key to it, go to Add a Field.

Administer an Existing Lookup Table

  1. On the Lookup Tables Admin Page, click the table with which you want to work.

    The Lookup Table Page for the table appears.

    You can now:

Add a Field

  1. On the Lookup Tables Admin Page, click the table with which you want to work.

    The Lookup Table Page for the table appears.

  2. Click Add Field.

    The Add Lookup Table Field box appears; enter a name for a field you want to add, then click Save Field.

    The Add Lookup Table Field box closes.

    The Lookup Table Page displays the key or keys you have addded. The new field name appears in the Name column of the table.

    To add another field, repeat this step.

    To add a key, go to Add a Key.

Add a Key

  1. On the Lookup Tables Admin Page, click the table with which you want to work.

    The Lookup Table Page for the table appears.

  2. Click Add Key.

    The Add Lookup Table Key box appears.

  3. In the Key Name box, enter a name for the key you want to add.

  4. In the Field dropdown listbox, click the down arrow.

    Any fields added for this table appear.

  5. Click a field that you want to be part of a key, then click Add Field To Key.

  6. Repeat the previous step to add another key. When the key is complete, click Save Key

    The Add Lookup Table Key box closes.

    The Lookup Table Page displays the key or keys you have addded.

Working with Lookup Table Data

  1. In the ADMINISTRATION section of the left-hand navigation pane on the Company Information Page, click Lookup Tables Data Entry.

img-lookup-tables-data-entry
Figure 3. Lookup Tables Data Entry Page
  1. In the Lookup Tables dropdown listbox, click the Down Arrow, then click the table for which you want to add or edit data.

Add Data

  1. Perform the steps in Working with Lookup Table Data to select the table with which you want to work.

  2. On the Lookup Tables Data Entry Page, click Add Entry.

    The Add Lookup Table Entry box appears.

  3. In the field boxes, enter data that corresponds to table fields. When you have entered a set of data, click Add Lookup Table Entry.

    The Add Lookup Table Entry box closes.

    The Lookup Tables Data Entry Page displays the data you have added as a new row. To add another row, repeat the preceding steps.

Duplicate, Edit, or Delete Data

  1. Perform the steps in Working with Lookup Table Data to select the table with which you want to work.

  2. On the Lookup Tables Data Entry Page, identify the row with which you want to work.

    To duplicate the row, click the Duplicate icon (the leftmost of the three icons at the right end of the row.)

    To edit the row, click the Edit icon (the middle of the three icons.)

    To delete the row, click X (the rightmost of the three icons.) .