The Universal API for MS-SQL Database provides a unified interface to interact with MS-SQL Database instances. Using this API, you can securely authenticate and execute SQL queries, including SELECT, INSERT, UPDATE, and DELETE operations, without worrying about database-specific connection details.
This API leverages OAuth 2.0 for secure authentication, enabling developers to focus on data analytics, reporting, and application logic while maintaining full control over Microsoft SQL Server operations. Whether you are retrieving data or performing schema updates, the Universal API simplifies and standardizes database interactions.
Below are the endpoints and usage details to get started with Microsoft SQL Server operations using the Universal API:
POST Token
Endpoint: {{base_url}}/token
This endpoint is used to retrieve an authentication token from the API. The token serves as an authorization mechanism to access and interact with the various API endpoints.
Body (form-data)
- username: {{Username}}
- password: {{Password}}
POST – API for MS-SQL Database
Endpoint: {{base_url}}/universalAPI?db_name=Microsoft SQL Server&db_version=All
This endpoint allows access to the Universal API of the BizData360 platform for interacting with Microsoft SQL Server databases securely and efficiently.
Authorization
OAuth 2.0
Query Parameters
- db_name: Microsoft SQL Server
- db_version: All
Body (raw JSON)
{
"username": "{{username}}",
"password": "{{password}}",
"query": "{{SELECT/INSERT QUERY}}",
"schema_name": "{{schema_name}}",
"hostname": "{{host_name}}",
"portnumber": {{port_number}}
}
