Querying stored procedures

From DreamFactory
Jump to: navigation, search
DreamFactoryTutorialsQuerying stored procedures
 
Line 1: Line 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.
 
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.
  

Latest revision as of 20:14, 22 June 2016

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

GET https://{url}/api/v2/{api_name}/_proc/{procedure_name}

API Docs Screenshot

Swagger-stored-procedure.png

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