How to get response when I POST using sql store procedure


I have a SP where I am inserting a set of records based on the input JSON value. I would to get the response of each and every record as JSON response from the stored procedure.

I just wanted to know how to use Output parameter in the JSON object in the dreamfactory web URL.

Kindly assist

Can make one json return with Multiple rows

Output parameters are usually single values. For example I may have a procedure that does some calculations based on the data in my database, and I want to return the value of that calculation. I will store it in an output parameter and use the documented procedure for requesting the output parameter from the API.

If your stored procedure includes a SELECT statement, the results of that statement will be included in the returned API data by default. No need to use an OUT param.