Bizdata Universal API- Databases
Bizdata Universal APIs are a comprehensive collection of flexible and adaptable application programming interfaces (APIs) designed to facilitate efficient connectivity and seamless access to a wide range of databases. These APIs serve as a unified gateway, enabling users to establish connections with various platforms such as Oracle Database, Microsoft SQL Server, MySql/MariaDB, Snowflake, Amazon Redshift, Amazon Aurora Database, and Postgres SQL.
POSTToken
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.
POSTBizdata Universal API- Oracle Data base
This endpoint allows access to the Universal API of the BizData360 platform for interacting with an Oracle Database.
{
"username":"{{username}}",
"password":"{{password}}",
"query":"{{SELECT/INSERT QUERY}}",
"schema_name":"{{schema_name}}",
"hostname":"{{host_name}}",
"portnumber":{{port_number}}
}
POSTBizdata Universal API- MS-SQL
This endpoint allows access to the Universal API of the BizData360 platform for interacting with Microsoft SQL Server database
{
"username":"{{username}}",
"password":"{{password}}",
"query":"{{SELECT/INSERT QUERY}}",
"schema_name":"{{schema_name}}",
"hostname":"{{host_name}}",
"portnumber":{{port_number}}
POSTBizdata Universal API- MySql/Maria
This endpoint allows access to the Universal API of the BizData360 platform for interacting with MySQL/Maria database
{
"username":"{{username}}",
"password":"{{password}}",
"query":"{{SELECT/INSERT QUERY}}",
"schema_name":"{{schema_name}}",
"hostname":"{{host_name}}",
"portnumber":{{port_number}}
}
POSTBizdata Universal API- Snowflake
This endpoint allows access to the Universal API of the BizData360 platform for interacting with Snowflake database
{
"username":"{{username}}",
"password":"{{password}}",
"query":"{{SELECT/INSERT QUERY}}",
"schema_name":"{{schema_name}}",
"hostname":"{{host_name}}",
"portnumber":{{port_number}}
}
POSTBizdata Universal API- Amazon Redshift
This endpoint allows access to the Universal API of the BizData360 platform for interacting with Amazon Redshift database
{
"username":"{{username}}",
"password":"{{password}}",
"query":"{{SELECT/INSERT QUERY}}",
"schema_name":"{{schema_name}}",
"hostname":"{{host_name}}",
"portnumber":{{port_number}}
}
POSTBizdata Universal API- Amazon Aurora Database ( paid version of mysql)
This endpoint allows access to the Universal API of the BizData360 platform for interacting with Amazon Aurora database (MySQL/Maria)
{
"username":"{{username}}",
"password":"{{password}}",
"query":"{{SELECT/INSERT QUERY}}",
"schema_name":"{{schema_name}}",
"hostname":"{{host_name}}",
"portnumber":{{port_number}}
}
POSTBizdata Universal API- Postgres SQL
This endpoint allows access to the Universal API of the BizData360 platform for interacting with PostgreSQL database
{
"username":"{{username}}",
"password":"{{password}}",
"query":"{{SELECT/INSERT QUERY}}",
"schema_name":"{{schema_name}}",
"hostname":"{{host_name}}",
"portnumber":{{port_number}}
}
Note :
For Base URL, Username and Password or other queries related to Bizdata Universal API, please reach out to our support team at:
Email: support@bizdata360.com
