Skip to main content

Bizdata Universal API for Database

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


{{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.

Bodyform-data
username
{{Username}}
password
{{Password}}

POSTBizdata Universal API- Oracle Data base


{{base_url}}/universalAPI?db_name=Oracle Database&db_version=All

This endpoint allows access to the Universal API of the BizData360 platform for interacting with an Oracle Database.

AuthorizationOAuth 2.0

Query Params
db_name
Oracle Database
db_version
All
Bodyraw (json)
json

{
"username":"{{username}}",
"password":"{{password}}",
"query":"{{SELECT/INSERT QUERY}}",
"schema_name":"{{schema_name}}",
"hostname":"{{host_name}}",
"portnumber":{{port_number}}
}

POSTBizdata Universal API- MS-SQL


{{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 database

AuthorizationOAuth 2.0

Query Params
db_name
Microsoft SQL Server
db_version
All
Bodyraw (json)
json

{
"username":"{{username}}",
"password":"{{password}}",
"query":"{{SELECT/INSERT QUERY}}",
"schema_name":"{{schema_name}}",
"hostname":"{{host_name}}",
"portnumber":{{port_number}}
}

POSTBizdata Universal API- 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 MySQL/Maria database

AuthorizationOAuth 2.0

Query Params
db_name
MySQL/Maria
db_version
Latest
Bodyraw (json)
json

{
"username":"{{username}}",
"password":"{{password}}",
"query":"{{SELECT/INSERT QUERY}}",
"schema_name":"{{schema_name}}",
"hostname":"{{host_name}}",
"portnumber":{{port_number}}
}

POSTBizdata Universal API- Snowflake


{{base_url}}/universalAPI?db_name=Snowflake&db_version=All

This endpoint allows access to the Universal API of the BizData360 platform for interacting with Snowflake database

AuthorizationOAuth 2.0

Query Params
db_name
Snowflake
db_version
All
Bodyraw (json)
json

{
"username":"{{username}}",
"password":"{{password}}",
"query":"{{SELECT/INSERT QUERY}}",
"schema_name":"{{schema_name}}",
"hostname":"{{host_name}}",
"portnumber":{{port_number}}
}

POSTBizdata Universal API- Amazon Redshift


{{base_url}}/universalAPI?db_name=Amazon Red Shift&db_version=All

This endpoint allows access to the Universal API of the BizData360 platform for interacting with Amazon Redshift database

AuthorizationOAuth 2.0

Query Params
db_name
Amazon Red Shift
db_version
All
Bodyraw (json)
json

{
"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)


{{base_url}}/universalAPI?db_name=Amazon Aurora(MySQL/Maria)&db_version=Latest

This endpoint allows access to the Universal API of the BizData360 platform for interacting with Amazon Aurora database (MySQL/Maria)

AuthorizationOAuth 2.0

Query Params
db_name
Amazon Aurora(MySQL/Maria)
db_version
Latest
Bodyraw (json)
json

{
"username":"{{username}}",
"password":"{{password}}",
"query":"{{SELECT/INSERT QUERY}}",
"schema_name":"{{schema_name}}",
"hostname":"{{host_name}}",
"portnumber":{{port_number}}
}

POSTBizdata Universal API- Postgres SQL


{{base_url}}/universalAPI?db_name=PostgreSQL&db_version=All

This endpoint allows access to the Universal API of the BizData360 platform for interacting with PostgreSQL database

AuthorizationOAuth 2.0

Query Params
db_name
PostgreSQL
db_version
All
Bodyraw (json)
json

{
"username":"{{username}}",
"password":"{{password}}",
"query":"{{SELECT/INSERT QUERY}}",
"schema_name":"{{schema_name}}",
"hostname":"{{host_name}}",
"portnumber":{{port_number}}
}

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

Back to top