Calling SQL functions

1. 1. 1. Tutorial

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

1. 1. 1. API Endpoint

GET https://{url}/api/v2/{api_name}/_func/{function_name}

1. 1. 1. API Docs Screenshot

1. 1. 1. Example - GET data from a stored procedure

• Stored procedure name: my_function
• Function_name parameter in API call:

  my_function

• Request URL:

  https://foo.com/api/v2/db/_func/my_function