Call a Stored Procedure From REST API
Although the DreamFactory platform can do many things, its ability to generate full-featured REST APIs for twenty databases (MySQL, SQL Server, and MongoDB, among others) is undoubtedly the most popular feature. Once generated, developers can review the API using companion Swagger documentation made available through the platform's administrative interface. Endpoints are available for carrying out the typical CRUD (create, retrieve, update, and delete) operations, inspecting the schema, and executing stored procedures. The URI signature looks like this:
/_proc/{procedure_name}
Therefore if the stored procedure name is getCustomers
, you can call the following URI:
/_proc/getCustomers
Many stored procedures accept input parameters. DreamFactory supports this functionality as well. You can pass the parameter along as a URL parameter, like this:
/_proc/getCustomerByLastName?LastName=Moreno