SendInBlue Tables
The provider models the data in API into a list of tables that can be queried using standard SQL statements.
Generally, querying API tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
SendInBlue Tables
| Name | Description |
| Account | Get your account informations, plans and credits details |
| ContactDetails | Retrieves contact informations |
| ContactListDetails | Get the details of a list |
| ContactLists | Get all the lists |
| Contacts | Get all the contacts |
| ContactsAttributes | Lists all attributes |
| ContactsCampaignStats | Get the campaigns statistics for a contact |
| ContactsFolders | Get all the folders |
| ContactsFoldersLists | Get the lists in a folder |
| EmailCampaignDetail | Get campaign informations |
| EmailCampaigns | Return all your created campaigns |
| Ips | Return all the dedicated IPs for your account |
| Process | Return all the processes for your account |
| Reseller | Gets the list of all reseller's children accounts |
| SenderIps | Return all the dedicated IPs for a sender |
| Senders | Get the list of all your senders |
| SMSCampaignDetail | Get an SMS campaign |
| SMSCampaigns | Returns the informations for all your created SMS campaigns |
| SMTP | Get the list of SMTP templates |
| SmtpStatisticsAggregatedReport | Get your SMTP activity aggregated over a period of time |
| SmtpStatisticsEvents | Get all your SMTP activity (unaggregated events) |
| SmtpStatisticsReports | Get your SMTP activity aggregated per day |
| TransactionalSMS | Get all the SMS activity (unaggregated events) |
| TransactionalSMSStatisticsAggregatedReport | Get your SMS activity aggregated over a period of time |
| TransactionalSMSStatisticsReports | Get your SMS activity aggregated per day |
| Webhooks | Get all webhooks |