Forum Discussion

amaaiia's avatar
amaaiia
Skilled Sharer
2 years ago
Solved

Set Stored Procedure parameter name as variable

Is there any way to set a stored procedure parameters name as input variables and not as fixed strings? I'd like to pass @item().param_name as variable as follows: I've seen a possible soluti...
Data Engineering
  • amaaiia's avatar
    amaaiia
    2 years ago

    Missing ending .params:

    @json(string(concat('{"Params":{"',variables('par_name'),'":{"value":"',variables('par_value'),'","type":"String"}}}'))).params
amaaiia's avatar
amaaiia
Skilled Sharer
2 years ago

Missing ending .params:

@json(string(concat('{"Params":{"',variables('par_name'),'":{"value":"',variables('par_value'),'","type":"String"}}}'))).params