Skip to content

Latest commit

 

History

History
82 lines (58 loc) · 2.22 KB

README.md

File metadata and controls

82 lines (58 loc) · 2.22 KB
Raw

Sendinblue Handler

Sendinblue handler for MindsDB provides interfaces to connect to Sendinblue via APIs and pull repository data into MindsDB.

Table of Contents

About Sendinblue

Sendinblue is the only all-in-one digital marketing platform empowering B2B and B2C businesses, ecommerce sellers and agencies to build customer relationships through end to end digital marketing campaigns, transactional messaging, and marketing automation.
https://www.sendinblue.com/about/

Sendinblue Handler Implementation

This handler was implemented using sib-api-v3-sdk, the Python SDK for Sendinblue.

Sendinblue Handler Initialization

The Sendinblue handler is initialized with the following parameters:

  • api_key: a required Sendinblue API key to use for authentication

Read about creating a Sendinblue API key here.

Implemented Features

  • Sendinblue Email Campaigns Table for a given Repository
    • Support SELECT
      • Support LIMIT
      • Support WHERE
      • Support ORDER BY
      • Support column selection

TODO

  • Support INSERT, UPDATE and DELETE for Email Campaigns table
  • Sendinblue Contacts table
  • Sendinblue Companies table
  • Sendinblue Conversations table
  • Sendinblue Deals table
  • Many more

Example Usage

The first step is to create a database with the new sendinblue engine by passing in the required api_key parameter:

CREATE DATABASE sib_datasource
WITH ENGINE = 'sendinblue',
PARAMETERS = {
  "api_key": "xkeysib-..."
};

Use the established connection to query your database:

SELECT * FROM sib_datasource.email_campaigns

Run more advanced queries:

SELECT  id, name
FROM sib_datasource.email_campaigns
WHERE status = 'sent'
ORDER BY name
LIMIT 5