How to get response when I POST using sql store procedure


#1

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
#2

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. http://wiki.dreamfactory.com/DreamFactory/Features/Database/SQL/Stored_Procedures_And_Functions

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.