REST API for your SQL Server
Create a REST API in minutes with simple Stored Procedures
Download installer!
Modern apps needs a backend with an API. If your customer has a SQL Server database on site you should try Apir.io
With Apir you will spend most of your development time on your app, not the backend. The API will use the latest ASP.NET WebAPI technology. You will only write short SQL Stored procedures.
Our relay hosting is the magic that gives you a cloud endpoint without changing any hardware or firewall settings
Define API resources
What data does your app need? Knowing your app and the database schema you can define the data objects needed
Resources are defined by rows returned from a simple SELECT
Write simple stored procedures
Apir can generate API procedures from database tables or you can write them by hand. The procedures may be as simple as.
CREATE PROCEDURE API_Products_GET AS
SELECT ProductID,ProductName FROM Products
Test and host your API
A test harness will give you the tools to try your API.
Hosting is done by the app itself, by Internet Information Server or by our firewall friendly relay host