Configuring mapping tables in Management API

Prerequisites

Before you complete the procedures in this guide, perform the following action:

• Use a Connect API key with the following permissions:

  • Workspace: Read-only (workspace:read) to list mapping tables, value tables, and mapping entries.

  • Workspace: Write (workspace:write) to create, update, or delete mapping entries.

  Picking Write for a permission also gives the key its Read-only access. Without the permission a request needs, Management API returns HTTP 403. You cannot change the permissions of a key, so to add one, create a new key. For more information, see Creating a Connect API key in Adverity.

Listing mapping tables

To list all mapping tables present in your Adverity instance, follow these steps:

1. Create a GET request to the following endpoint:

   https://{{INSTANCE}}/api/mapping-tables
   

2. In the HTTP request header, include the parameter Authorization with value Bearer {{KEY}}.

3. Send the request.

Import the request example as raw text to your HTTP client (such as Postman). The cURL request example is the following:

curl --location -g --request GET 'https://{{INSTANCE}}/api/mapping-tables/' \
--header 'Authorization: Bearer {{KEY}}'

Listing mapping table entries

To list entries of a specific mapping table, follow these steps:

1. Create a GET request to the following endpoint:

   https://{{INSTANCE}}/api/mapping-tables/{{MAPPING_TABLE_ID}}/entries/
   

   Use MAPPING_TABLE_ID from the API response described in the previous section.

2. In the HTTP request header, include the parameter Authorization with value Bearer {{KEY}}.

3. Send the request.

Import the request example as raw text to your HTTP client (such as Postman). The cURL request example is the following:

curl --location -g --request GET 'https://{{INSTANCE}}/api/mapping-tables/{{MAPPING_TABLE_ID}}/entries/' \
--header 'Authorization: Bearer {{KEY}}'

Creating a new mapping table entry

To create a new mapping table entry, follow these steps:

1. Create a POST request to the following endpoint:

   https://{{INSTANCE}}/api/mapping-tables/{{MAPPING_TABLE_ID}}/entries/
   

2. In the HTTP request header, include the parameter Authorization with value Bearer {{KEY}}.

3. In the HTTP request header, include the parameter Content-Type with value application/json.

4. In the HTTP request body, include the parameter match with the source value and parameter value with the target value. For more information on source and target values in mapping tables, see Creating and applying mapping tables.

5. Send the request.

6. In the response, you receive the entry_id of the newly added mapping table entry. You can list it again with the call described in the previous section.

Import the request example as raw text to your HTTP client (such as Postman). The cURL request example is the following:

curl --location -g --request POST 'https://{{INSTANCE}}/api/mapping-tables/{{MAPPING_TABLE_ID}}/entries/' \
--header 'Authorization: Bearer {{KEY}}' \
--header 'Content-Type: application/json' \
--data-raw '{
    "match": "SOURCE_VALUE",
    "value": "TARGET_VALUE"
}'

Updating a mapping table entry

To update a mapping table entry, follow these steps:

1. Create a PATCH request to the following endpoint:

   https://{{INSTANCE}}/api/mapping-tables/{{MAPPING_TABLE_ID}}/entries/{{ENTRY_ID}}/
   

2. In the HTTP request header, include the parameter Authorization with value Bearer {{KEY}}.

3. In the HTTP request header, include the parameter Content-Type with value application/json.

4. In the HTTP request body, include the match or value parameters and their respective values to edit. For example, for the parameter value, change the value computer to desktop.

   {
       "value": "UPDATED_VALUE"
   }
   

5. Send the request.

Import the request example as raw text to your HTTP client (such as Postman). The cURL request example is the following:

curl --location -g --request PATCH 'https://{{INSTANCE}}/api/mapping-tables/{{MAPPING_TABLE_ID}}/entries/{{ENTRY_ID}}/' \
--header 'Authorization: Bearer {{KEY}}' \
--header 'Content-Type: application/json' \
--data-raw '{
    "value": "UPDATED_VALUE"
}'

Deleting a mapping table entry

To delete a mapping table entry, follow these steps:

1. Create a DELETE request to the following endpoint:

   https://{{INSTANCE}}/api/mapping-tables/{{MAPPING_TABLE_ID}}/entries/{{ENTRY_ID}}/
   

2. In the HTTP request header, include the parameter Authorization with value Bearer {{KEY}}.

3. Send the request.

Import the request example as raw text to your HTTP client (such as Postman). The cURL request example is the following:

curl --location -g --request DELETE 'https://{{INSTANCE}}/api/mapping-tables/{{MAPPING_TABLE_ID}}/entries/{{ENTRY_ID}}/' \
--header 'Authorization: Bearer {{KEY}}'

Listing value tables

To list all value tables present in your Adverity instance, follow these steps:

1. Create a GET request to the following endpoint:

   https://{{INSTANCE}}/api/value-tables
   

2. In the HTTP request header, include the parameter Authorization with value Bearer {{KEY}}.

3. Send the request.

Import the request example as raw text to your HTTP client (such as Postman). The cURL request example is the following:

curl --location -g --request GET 'https://{{INSTANCE}}/api/value-tables/' \
--header 'Authorization: Bearer {{KEY}}'