Format for inserting data through a stored procedure - Using the Postman Chrome Extension

Another Update:

I was able to get everything to work. Here’s some notes, in case it’s helpful to someone else.

I am using the “Postman” google chrome extension to send the http:// request to my DSP that I’ve setup a stored procedure on.

I used this site as a reference for setting up the Postman request:
http://stackoverflow.com/questions/26705782/sending-nested-json-object-using-postman

After setting up the URL:
http://localhost/rest/db/_proc/my_proc/?app_name=my_app
The settings for the json object were:
Body, raw, JSON(application/json)

I also used this post as a reference for setting up the stored procedure in the MySQL DB. The post from Harry was key. Notice how it sets up the stored procedure to return a value, based on whether the insert was a success or not:
https://community.dreamfactory.com/t/db-how-could-call-a-db-function/447/11

After I figured out the CORS issue above, I was still getting errors. I changed the input json to look like this and it worked! ** Note: the value for the schema result had to match exactly to the type being returned (i.e. “string”). I had it set to integer and it was failing with an error that didn’t indicate that**

{
“params”:[
{
“name”:“my_parameter”,
“param_type”:“IN”,
“value”:“my_value”
}
],

"schema": {
"result": "string"
},

"wrapper": "proc_result"

}

Hope that helps someone!

-Brian

1 Like