Body parameter on Execute Stored Procedure (V2) task

Question

I need to set “Database name” dynamically, but when I use a variable, the task need a “Body” parameter. What I need to put in Body?

Answer 1

Hi Franklim,

When you use the default as in your first image, then the logic apps agent "know" what is the structure of the returned SETs since it check the specific stored procedure in the specific database in the specific server using the connector you configured.

But when you use a dynamic source of the data, then the logic app must get from you the structure of the returned SET which you want to use. This is the meaning of the body - it is the body structure.

For example, if my ST returns a single column name n then the body can be : [ { "n": 1 }]

Here is a full working demo:

This is my SP :

create OR ALTER procedure RonenSP as select n = 1 UNION ALL SELECT n = 3  
GO  

This is the Logic apps: