Querying stored procedures

From DreamFactory
Jump to: navigation, search
DreamFactoryTutorialsQuerying stored procedures
m
(Created page with "### 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. ### API End...")
Line 1: Line 1:
32 yr old Emergency Support Worker Francisco from Gravenhurst, has pastimes for example piano, rap beats for sale and fitness. Is a travel maniac and in recent years visited Giant's Causeway and Causeway Coast.<br><br>Also visit my weblog ... free r&b beats ([http://deca.cuc.edu.cn/Community/blogs/linweiguo/archive/2010/02/23/things-to-do-today.aspx deca.cuc.edu.cn])
+
### 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.
 +
 
 +
### API Endpoint
 +
 
 +
<pre>GET https://{url}/api/v2/{api_name}/_proc/{procedure_name}</pre>
 +
 
 +
### API Docs Screenshot
 +
 
 +
[[File:Swagger-stored-procedure.png|1000px]]
 +
 
 +
### Example - GET data from a stored procedure
 +
 
 +
* Stored procedure name: my_stored_procedure
 +
* Request URL: <pre>https://foo.com/api/v2/db/_proc/my_stored_procedure</pre>

Revision as of 21:28, 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 stored procedure
  • Stored procedure name: my_stored_procedure
  • Request URL:
    https://foo.com/api/v2/db/_proc/my_stored_procedure