SubscriptionAccount: Sendinblue Subscription Account |
Get account detailsRetrieves details of your Brevo account.**Use this to:**- Get account information (email, name, company, address)- Check plan details (type, credits, expiration)- Get relay information (for transactional emails)- Check Marketing Automation status- Access organization and user identifiers**Key information returned:**- Complete account details (organization ID, user ID, company information)- Address and contact information- Plan configurations and credit allocations across different verticals- Marketing Automation settings and tracker key (when enabled)- SMTP relay configuration for transactional emails- Enterprise features availability status**Important considerations:**- Provides comprehensive account overview for billing and configuration management- Essential for understanding current plan limitations and feature availability- Marketing Automation key is only returned when Marketing Automation is enabled on the account- Plan verticals show detailed breakdown across Marketing, Chat, and CRM categories (only returned when plan verticals are available)- Relay configuration crucial for transactional email setup and deliverability- Enterprise status determines access to advanced features and sub-account management
Catalog: Brevo
Schema: Account
Label: Subscription Account
This is a read-only table. The Sendinblue API may not support changing the data or the Invantive UniversalSQL driver for Sendinblue does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Sendinblue API.
Table Columns
The columns of the table SubscriptionAccount are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
address_city |
varchar2 |
Address City |
☐ |
City information |
address_country |
varchar2 |
Address Country |
☐ |
Country information |
address_street |
varchar2 |
Address Street |
☐ |
Street information |
address_zipCode |
varchar2 |
Address Zip Code |
☐ |
Zip Code information |
companyName |
varchar2 |
Company Name |
☐ |
Name of the company |
varchar2 |
Email Address |
☐ |
Login Email |
|
enterprise |
char |
|
☐ |
Indicates if the account has enterprise features |
firstName |
varchar2 |
First Name |
☐ |
First Name |
lastName |
varchar2 |
Last Name |
☐ |
Last Name |
marketingAutomation_enabled |
char |
Marketing Automation Enabled |
☐ |
Status of Marketing Automation Plateform activationfor your account (true=enabled, false=disabled) |
marketingAutomation_key |
varchar2 |
Marketing Automation Key |
☐ |
Marketing Automation Tracker ID |
organization_id |
varchar2 |
|
☐ |
Unique identifier for the organization |
relay_data_port |
int64 |
Relay Data Port |
☐ |
Port used for SMTP Relay |
relay_data_relay |
varchar2 |
Relay Data Relay |
☐ |
URL of the SMTP Relay |
relay_data_userName |
varchar2 |
Relay Data Username |
☐ |
Email to use as login on transactional platform |
relay_enabled |
char |
Relay Enabled |
☐ |
Status of your transactional email Account(true=Enabled, false=Disabled) |
user_id |
int64 |
|
☐ |
Unique identifier for the user |
Sendinblue API Data Model