SQL Server - Stored Procedure - Parameters list

(0) Share

Report

Posted on by MsKautha

Hello again,

I'll get straight to the point without pleasantries.

I am trying to execute a SQL Server stored procedure from a flow. The procedure cannot be selected directly from the dropdown because there are 50+ procedures and which one to be run depends on a condition. So I used a variable for procedure name.

There is only one parameter that I need to pass regardless of the procedure name. I tried using a variable but ran into an error. The screenshots of the error message and my flow are below. Please take a look and let me know if the format in which I am passing the parameter is wrong.

Thank you,

Chandrika Kautha

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

MsKautha 42 on at

Like (0)

Report

Can this topic be moved to "Building flows"? I wrongly selected "Using Flows".

Was this reply helpful? Yes No
Verified answer

MsKautha 42 on at

Like (0)

Report

You can pass the parameters list in a json format:
{"<Parameter Name>":"<Value>"}
First compose the parameterslist using data operation and then use it in Execute SQL proc action.

Was this reply helpful? Yes No
PS-28031948-0 4 on at

Like (0)

Report

Hi Chandrika,

I have the same scenario. I am trying to parameterize the DBName, Server Names.

Is the parameters list working? When I try to pass the parameter list using JSON Format like below, it executes successfully,

but the parameter values are not passed/set to input parameters of SP. It just shows NULL.

[{"in_ReportName": "DMI RCC Report"}, {"in_Subsc_Type": "Email"}, {"in_Status": "Started"}]

If the issue is resolved, can you please comment on how its resolved?

Was this reply helpful? Yes No