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, MySQL Default: 3306)
database : database name
userId : user id
password : password
queryString

{ "server":"string", "port":0, "database":"string", "userId":"string", "password":"string", "queryString":"string" }

MS-SQL Server Connection String

Template:

Server={ServerDNS_or_PublicIP,PortNO};Database={DbName};User Id={UserName};Password={UserPassword};

Examples:

Server=my-server.com,1433;Database=myDb;User Id=sa;Password=xx123;
Server=192.90.121.105,1433;Database=myDb;User Id=sa;Password=xx123;

Note: 1433 is the default port and you can ignore, but if your server use different port then you should set.
Reference: SQL Server connection strings

My-SQL Server Connection String

Template:

Server={ServerDNS_or_PublicIP};Port={PortNO};Database={DbName};Uid={UserName};Pwd={UserPassword};

Examples:

Server=my-server.com;Port=3306;Database=myDb;Uid=admin;Pwd=xx123;
Server=192.90.121.105;Port=3306;Database=myDb;Uid=admin;Pwd=xx123;

Note: 3306 is the default port.
Reference: MySQL connection strings

API Request / Response Example

REQUEST V1

curl --request POST \
	--url https://sql-portal-api.p.rapidapi.com/api/MSSQL/querytohtml \
	--header 'Content-Type: application/json' \
	--header 'x-rapidapi-host: sql-portal-api.p.rapidapi.com' \
	--header 'x-rapidapi-key: YOUR-KEY' \
	--data '{"connectionString":"Server=myserver.com;Database=myDB;User Id=sa;Password=xx123;","queryString":"select * from users"}'

REQUEST V2

curl --request POST \
	--url https://sql-portal-api.p.rapidapi.com/api/MSSQL/ver2/querytohtml \
	--header 'Content-Type: application/json' \
	--header 'x-rapidapi-host: sql-portal-api.p.rapidapi.com' \
	--header 'x-rapidapi-key: YOUR-KEY' \
	--data '{"server":"myserver.com","database":"myDB","userId":"sa","password":"xx123","queryString":"select * from users"}'

RESPONSE 200 OK



ID FirstName LastName Email
1 Ezzat Elbadrawy user1@dmoain.com
2 Ali Mohmed user2@dmoain.com
3 Alaa Bakr user3@dmoain.com

ID	FirstName	LastName	Email
1	Ezzat	Elbadrawy	user1@dmoain.com
2	Ali	Mohmed	user2@dmoain.com
3	Alaa	Bakr	user3@dmoain.com