Rest API Stored procedure with IN parameters
|6/27/2022 5:58:05 PM|
|PHPRunner General questions|
dageci authorDevClub member
After following the great video https://www.youtube.com/watch?v=MHr67SWh8xU
I was able to create the SP, create the custom SQL View and in Running the SQL I get asked for the parameters and when putting them in I get the result back.
I think that I'm doing something wrong in the Custom SQL View.
I have only the list view with this:
The url is:
The response is:
I have returned the varcarduid so that I can see what is the parameter value inside the stored procedure. As you can see in url is 2222 and from the results from the SP it is 0
And here is the code for the MySQL SP:
If you want to use the URL parameters in your SQL , use this syntax:
|Craig Smith 6/29/2022|
Brilliant !!! - this is exactly what I was looking for today.
Thanks for the question and response.