Dynamic Parameters

Dynamic parameters are placeholder texts whose values are dynamically set. Use the dynamic parameters to propagate client-specific parameters to all or selected data load schedules.

ParameterTypeDescription
param_name_columnstringThe parameter name to use instead of the default one, param_name
param_value_columnstringThe parameter value to use instead of the default one, param_value
schedule_title_columnstring

The schedule title to use instead of the default one, schedule_title

If not explicitly specified, all schedules in the project are affected.

client_id_columnstring

The client ID to use instead of the default one, client_id

If not explicitly specified, all projects in the domain are affected.

dynamic_paramsJSON

An input data source that is mapped to the defined dynamic parameters

The query to the input data source must contain the param_name_column and param_value_column parameters. All other parameters can be omitted, and the meaning of the query will be changed.

You encode the dynamic parameters using the gd_encoded_params parameter (see Specifying Complex Parameters).

Example:

"gd_encoded_params": {
  "param_name_column": "name",
  "param_value_column": "value",
  "schedule_title_column": "schedule_name",
  "client_id_column": "client",
  "dynamic_params": {
    "input_source": {
	  "type": "ads",
	  "query": "select 'MODE' as name, 'specific mode' as value, 'main.rb' as schedule_name, 'client_1' as client"
	}
  }
}