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)

Sort by

MsKautha 42 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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