The Universal API for MySQL/Maria provides a standardized and secure way to interact with MySQL or MariaDB instances. Developers can easily authenticate, execute SQL queries such as SELECT, INSERT, UPDATE, and DELETE, and manage schemas without worrying about database-specific connection details. Leveraging OAuth 2.0, this API ensures safe and efficient access for analytics, reporting, and application operations.
POST Token
{{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 MySQL/Maria
{{base_url}}/universalAPI?db_name=MySQL/Maria&db_version=Latest
This endpoint allows access to the Universal API of the BizData360 platform for interacting with a MySQL/Maria database.
Authorization
OAuth 2.0
Query Parameters
- db_name: MySQL/Maria
- db_version: Latest
Body (raw JSON)
{
"username": "{{username}}",
"password": "{{password}}",
"query": "{{SELECT/INSERT QUERY}}",
"schema_name": "{{schema_name}}",
"hostname": "{{host_name}}",
"portnumber": {{port_number}}
}
