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

All responses (3)

Answers (1)

PS-28031948-0 4 on at

Like (0)

Report

SQL Server - Stored Procedure - Parameters list

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?
Verified answer

MsKautha 42 on at

Like (0)

Report

Re: SQL Server - Stored Procedure - Parameters list

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.
MsKautha 42 on at

Like (0)

Report

Re: SQL Server - Stored Procedure - Parameters list

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