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