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.
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);
- 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.
/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.
/api/v3/staticParameter1?staticQueryParameter1=value1
See the Endpoint page in Creating or Editing an API Connection.