SQL-Portal-Api
Execute SQL Queries on Remote Database Server (MS-SQL or MySQL) and get results on different formats (CSV, XML, HTML, JSON). API POST body v1 is a JSON object contains two props: connectionString queryString { "connectionString": "string", "queryString": "string" } API POST body v2 is a JSON object contains six props: server : server DNS or Public-IP port : port number (SQL-Server Default: 1433,…
SQL-Portal-Api endpoints
| Method | Endpoint | Description |
|---|---|---|
| MSSQL | ||
| POST |
MSSQL.QueryToCsv V2 /api/MSSQL/ver2/querytocsv |
Execute SQL Query on Remote MS-SQL Server and Convert Query Result to CSV. |
| POST |
MSSQL.QueryToHtml V2 /api/MSSQL/ver2/querytohtml |
Execute SQL Query on Remote MS-SQL Server and Convert Query Result to HTML-Table. |
| POST |
MSSQL.QueryToJson V2 /api/MSSQL/ver2/querytojson |
Execute SQL Query on Remote MS-SQL Server and Convert Query Result to JSON. |
| POST |
MSSQL.QueryToXml V2 /api/MSSQL/ver2/querytoxml |
Execute SQL Query on Remote MS-SQL Server and Convert Query Result to XML-Dataset. |
| POST |
MSSQL.QueryToCsv V1 /api/MSSQL/querytocsv |
Execute SQL Query on Remote MS-SQL Server and Convert Query Result to CSV. |
| POST |
MSSQL.QueryToHtml V1 /api/MSSQL/querytohtml |
Execute SQL Query on Remote MS-SQL Server and Convert Query Result to HTML-Table. |
| POST |
MSSQL.QueryToJson V1 /api/MSSQL/querytojson |
Execute SQL Query on Remote MS-SQL Server and Convert Query Result to JSON. |
| POST |
MSSQL.QueryToXml V1 /api/MSSQL/querytoxml |
Execute SQL Query on Remote MS-SQL Server and Convert Query Result to XML-Dataset. |
| MySQL | ||
| POST |
MySQL.QueryToCsv V2 /api/MySQL/ver2/querytocsv |
Execute SQL Query on Remote MySQL Server and Convert Query Result to CSV. |
| POST |
MySQL.QueryToHtml V2 /api/MySQL/ver2/querytohtml |
Execute SQL Query on Remote MySQL Server and Convert Query Result to HTML-Table. |
| POST |
MySQL.QueryToJson V2 /api/MySQL/ver2/querytojson |
Execute SQL Query on Remote MySQL Server and Convert Query Result to JSON. |
| POST |
MySQL.QueryToXml V2 /api/MySQL/ver2/querytoxml |
Execute SQL Query on Remote MySQL Server and Convert Query Result to XML-Dataset. |
| POST |
MySQL.QueryToCsv V1 /api/MySQL/querytocsv |
Execute SQL Query on Remote MySQL Server and Convert Query Result to CSV. |
| POST |
MySQL.QueryToHtml V1 /api/MySQL/querytohtml |
Execute SQL Query on Remote MySQL Server and Convert Query Result to HTML-Table. |
| POST |
MySQL.QueryToJson V1 /api/MySQL/querytojson |
Execute SQL Query on Remote MySQL Server and Convert Query Result to JSON. |
| POST |
MySQL.QueryToXml V1 /api/MySQL/querytoxml |
Execute SQL Query on Remote MySQL Server and Convert Query Result to XML-Dataset. |
| Other endpoints | ||
| POST |
MySql QueryToCsv /api/MySQL/querytocsv |
Execute SQL Query on Remote MySQL Server and Convert Query Result to CSV. |
| POST |
MS-SQL QueryToCsv /api/MSSQL/querytocsv |
Execute SQL Query on Remote MS-SQL Server and Convert Query Result to CSV. |
| POST |
MySql QueryToHtml /api/MySQL/querytohtml |
Execute SQL Query on Remote MySQL Server and Convert Query Result to HTML-Table. |
| POST |
MS-SQL QueryToHtml /api/MSSQL/querytohtml |
Execute SQL Query on Remote MS-SQL Server and Convert Query Result to HTML-Table. |
| POST |
MySql QueryToJson /api/MySQL/querytojson |
Execute SQL Query on Remote MySQL Server and Convert Query Result to JSON. |
| POST |
MS-SQL QueryToJson /api/MSSQL/querytojson |
Execute SQL Query on Remote MS-SQL Server and Convert Query Result to JSON. |
| POST |
MySql QueryToXml /api/MySQL/querytoxml |
Execute SQL Query on Remote MySQL Server and Convert Query Result to XML-Dataset. |
| POST |
MS-SQL QueryToXml /api/MSSQL/querytoxml |
Execute SQL Query on Remote MS-SQL Server and Convert Query Result to XML-Dataset. |
SQL-Portal-Api pricing
| Plan | Price | Rate limit | Quotas |
|---|---|---|---|
| BASIC | Free | — |
|
| PRO Recommended | $2 / month | — |
|
| ULTRA | $5 / month | — |
|
| MEGA | $9 / month | — |
|