Querying stored procedures

From DreamFactory
Jump to: navigation, search
DreamFactoryTutorialsQuerying stored procedures
Line 11: Line 11:
 
[[File:Swagger-stored-procedure.png|1000px]]
 
[[File:Swagger-stored-procedure.png|1000px]]
  
### Example - GET data from a stored procedure
+
### Example - GET data from a SQL stored procedure
  
 
* Stored procedure name: my_stored_procedure
 
* Stored procedure name: my_stored_procedure
 
* Procedure_name parameter in API call:<pre>my_stored_procedure</pre>
 
* Procedure_name parameter in API call:<pre>my_stored_procedure</pre>
 
* Request URL: <pre>https://foo.com/api/v2/db/_proc/my_stored_procedure</pre>
 
* Request URL: <pre>https://foo.com/api/v2/db/_proc/my_stored_procedure</pre>

Revision as of 22:25, 15 October 2015

      1. Tutorial

GET data form a SQL stored procedure. Try these examples in the 'API Docs' tab of the DreamFactory Admin Console or from the command line with cURL.

      1. API Endpoint
GET https://{url}/api/v2/{api_name}/_proc/{procedure_name}
      1. API Docs Screenshot

Swagger-stored-procedure.png

      1. Example - GET data from a SQL stored procedure
  • Stored procedure name: my_stored_procedure
  • Procedure_name parameter in API call:
    my_stored_procedure
  • Request URL:
    https://foo.com/api/v2/db/_proc/my_stored_procedure