Dynamic/Static Variables in API Data Integrations | Vantage Analyst - Dynamic and Static Parameters - Teradata Analytic Apps - Vantage Analyst

Vantage Analyst User Guide

Product
Teradata Analytic Apps
Vantage Analyst
Release Number
1.4.1
Published
May 2022
Language
English (United States)
Last Update
2022-05-09
dita:mapPath
ufz1626905554941.ditamap
dita:ditavalPath
wsp1565965728073.ditaval
dita:id
B035-3805
Product Category
Teradata Applications

Dynamic

Use dynamic path and query parameters when you need to use different parameters for an API endpoint with each call. You can store the dynamic parameters for inbound and outbound API data integrations in a database table. When the workflow executes, the substitutes the dynamic path and appends the query parameters to the call.

See the Request page in Creating or Editing an API Data Integration.

Store your dynamic parameter in a database table created using the following schema:
CREATE MULTISET TABLE ${databaseName}.${tableName} (
     Object_Id VARCHAR(40) NOT NULL,
     Object_Order INTEGER,
     Param_Name VARCHAR(32000) NOT NULL,
     Param_Value VARCHAR(32000),
     Param_Type_Cd BYTEINT NOT NULL
) PRIMARY INDEX (Object_Id);
When populating the dynamic parameter table, be aware of the following:
  • Use the Object_Order to determine the order in which query parameters are added to the call. If null, the parameter is not used.
  • The Param_Name must match the parameter name entered on the Endpoint page when creating the API Connection. See Creating or Editing an API Connection.
  • For Param_Type_Cd, use 0 for query parameter or 1 for path parameter.

To use dynamic path parameters, add the parameter syntax to the endpoint URL when creating the API Connection. Do not add dynamic query parameters, which are automatically be appended to the endpoint URL when the workflow processes the data integration.

For example:
/api/v3/${dynamicParameter1}

Static

Use static path and query parameters to include the same parameters for an API end point with each call. You can add the static path and query parameters directly to the Endpoint URL when configuring the connection used by the data integration.

For example:
/api/v3/staticParameter1?staticQueryParameter1=value1

See the Endpoint page in Creating or Editing an API Connection.