Mailjet Tables
The provider models the data in API as a list of tables in a relational database that can be queried using standard SQL statements.
Mailjet Tables
| Name | Description |
| ApiKey | Retrieve a list of all API Keys and their configuration settings. |
| BounceStatistics | Retrieve a single or list of all bounce events. |
| CampaignDraft | Retrieve details on the configuration of all campaign drafts. |
| CampaignOverview | Get the details of Campaign overview |
| Campaigns | Retrieve details about a list of sent campaigns. |
| CampaignsDetailedContents | To view the content of your campaign draft email |
| CampaignStatistics | Retrieve a list of overall stringd delivery and engagement statistics, grouped by contact. |
| ClickStatistics | Retrieve a list of all click events and details about them |
| ContactContactLists | Get all the list of contacts where the given contact is part of. |
| ContactData | Retrieve a list of contacts with all properties and respective values associated with those contacts. |
| ContactFilter | Retrieve a list of all segments and details on their configuration. |
| ContactMetaData | Retrieve a list of contact properties and their general settings - name and data type. |
| Contacts | Gets single or lists of contacts |
| ContactsLists | Retrieve details for all contact lists - name, subscriber count, creation timestamp, deletion status. |
| ContactsListSignup | Retrieve details about all contact list signup requests via a subscription widget. Provides details on signup and subscription confirmation IPs, timestamp, subscription source etc. |
| ContactStatistics | Retrieve a list of overall stringd delivery and engagement statistics, grouped by contact. |
| Dns | Retrieve the SPF and DKIM settings for all sender domains on this API Key. |
| EventCallBackUrl | Retrieve a list of all callback URL objects and their configuration settings. Whenever an action (e.g. email open) occurs, the information about it will be sent to the selected callback URL. You can then set up different automation workflows triggered by the tracked actions. |
| GeoStatistics | Retrieve aggregated open and click statistics, grouped by recipient country. |
| ListRecipient | Retrieve details on all list recipients, including the contact and list associated with them, as well as subscription status. |
| ListRecipientStatistics | Get aggregated statistics, grouped by list recipient or get aggregated statistics for a specific list recipient. |
| MessageHistory | Get the event history for a specific message. |
| MessageInformation | Retrieve sending / size / spam information about all messages. |
| Messages | Get a list of messages with specific information on the type of content, tracking, sending and delivery. |
| MetaSender | Retrieve a list of all metasenders and their configuration settings. A metasender is a sender available for use by the Master API Key and all sub-accounts. The e-mail address or domain has to be registered and validated before being used to send e-mails. Validation is done by contacting the Mailjet Support team. |
| MyProfile | Manage your user profile data such as address, payment information etc. |
| OpenInformation | Retrieve a single or list of all open events and details about them - message, campaign and contact IDs, timestamp etc. |
| ParseRoute | Retrieve a list of all parseroute instances and their configuration settings. |
| RecipientEsp | Get stringd delivery and engagement statistics, grouped by recipient Email Service Provider (ESP). |
| Senders | Get information on a list of sender email addresses and/or domains. |
| SenderStatistics | Retrieve a list of overall aggregated delivery and engagement statistics, grouped by sender ID. |
| SMS | Retrieve information about created / sent messages, including their sending status. |
| SMSCount | Retrieve the exact number of created messages. |
| StatCounters | Get aggregated statistics for a specific campaign, list, API Key or sender email address. Both message-based and event-based stats can be retrieved. |
| StatisticsLinkClick | Retrieve aggregated click statistics for a campaign, grouped by URL links. |
| TemplateDetailedContent | Templates are essential building blocks for your campaigns, transactional emails or automation workflows |
| Templates | Retrieve a list of all templates and their configuration settings. |
| TopLinkClicked | Retrieve a list of open or click statistics, grouped by web browser or email client. |
| User | Get general information on your user settings and activity. |
| UserAgentStatistics | Retrieve a list of overall aggregated click statistics, grouped by URL. |