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
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. https://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.