How to Create a Microsoft SQL Data source using Bold BI REST API?

This article explains how to connect Microsoft SQL data source with Bold BI using REST API. This API applicable only for creating live mode connection.

Authentication

When you sign in to Bold BI, an authentication token is provided that should be attached in the request header (Authorization) for all subsequent API calls to authenticate the requests.

Refer to the following help documents to get the authorized token:

• Password Authentication
• Embed Secret Authentication

Create MS SQL data source using API

Use the following API endpoint to get published dashboard details with the site details in which the dashboard is published:

POST /v4.0/datasources

Sample URL: https://{yourdomain}/bi/api/site/<site_identifier>/v4.0/datasources

Request Body

You need to pass the below required parameters

{
 "Name": "Name",
 "Type": "sqlserver",
 "Description": "",
 "Connection": {
   "Servername": "servername",
   "IntegratedSecurity": "false",
   "Username": "username",
   "Password": "password",
   "Database": "database",
   "Schemaname": "schemaname",
   "Tablename": "tablename"
 }
}

For more information about this API, refer to this link.