[Extension] How to connect the MySQL database in Blip Smart Contacts

1. Introduction

2. Features

3. Installation and configuration

4. User manual

5. Dependencies

6. Support

The MySQL for Blip extension is here to make developers’ lives easier. Connect Blip directly to your MySQL database without the need for intermediary APIs. With MySQL for Blip, enter your connection credentials and run database queries and operations directly in Builder or Studio.

Keywords: MySQL, database, integration, MySQL, connection, queries, SQL, API, router, Blip extension, efficiency.

Introduction

MySQL for Blip, developed by Sharkdev, is an extension that allows you to connect Blip directly to your MySQL database using connection details, eliminating the need to build and maintain an intermediary API.

As a practical example, you can use the extension directly in Builder or Studio to check the status of an order in your company’s database and display this information to the customer in real time during the conversational flow. 
 

Features

The MySQL for Blip extension was developed to allow developers to access databases directly through Builder or Studio, without the need for an intermediary API.
The following features are available:

• Database connection;

• Execution of SQL statements on the database through HTTP requests;

• Viewing SQL statements executed on the database during the last 30 days;

Installation and configuration

To use the MySQL for Blip extension, you need to access the contract where you want to install it, and then access the Router bot. After that, go to the extensions section, which will open the Blip Store, and search for “MySQL for Blip”. Once you find it, you need to activate and install it.

After it has been activated and installed and the terms have been accepted, a small configuration is required before you can start using it. Follow the step-by-step instructions below.

1) Connecting to the database

On the extension’s main page, enter name, host, port, user and password in the connection form and click "Connect".

If the connection is successful, you will quickly see the message "Database connected". If it is unsuccessful, we suggest reviewing the connection details entered in the form.

2) Defining the token in the bots’ configuration variables

For your bot to use the extension, the authorization token must be provided when making the request.

Therefore, we suggest that you. 

* This step is not mandatory, but it is suggested to help maintain the Smart Contact.

3) Now you’re ready to use it!

At this point, the extension is configured and you can start using it. To do so, learn about the concept of commands in the “User manual”.
 

User manual

• SQL statements

Follow the instructions below to communicate with the extension through Builder:

Basic information

Base URL: https://mysqlforblip.blip.sharkdev.com.br/query

Authorization token: {{config.token}} or Authentication header (Authorization)

How to execute a command

To execute a command, configure an HTTP Request, using the POST method, to the URL provided in Base URL, providing the Authorization token in the "Authorization" key of the header. For convenience, see the image below:

Now, you need to define the request body. To do so, the JSON sent must include the attributes below:

Dependencies

For this extension to work correctly, you must subscribe to it through the Blip Store by accessing Blip with a paying account. In addition, you must use your own database.
 

Support

If you have any questions or encounter any issues with the extension, contact us by email at blippartner@sharkdev.com.br or by phone at +55 (35) 98802-9321.

Need more help? Explore our content on Blip Academy or Blip Community, watch tutorials on our YouTube channel or get your questions answered through our support channel 😃