The Lyftron Provider for Mailjet offers the most natural way to access Mailjet data from Lyftron with ease and also enables to connect with BI, MDM & ML tools, Data warehouses, Databases and other SAAS based applications with zero code and zero infrastructure requirements. The provider wraps the complexity of accessing Mailjet data into easy-to-integrate relational fully managed ANSI Sql format. Make faster and better business decisions with Lyftron’s Mailjet data provider and automatically build your data migration pipelines in minutes, not months
The provider hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.
- Comprehensive Delta load mechanism.
- Real-time access to Mailjet.
- Comprehensive full support of ANSI Sql to query data with ease.
- Collaborative query processing.
The user must have credentials for Mailjet, Lyftron and your destination data warehouse, lake or database to perform the data pipeline operation with Lyftron
Step1: Setup Drip account
1.1 Create account in Mailjet and login
1.2. After Login go to -> Account and click on -> New API Key to generate Api key
Establishing a Connection with Lyftron's Quickstart Steps
Create your Mailjet connection with Lyftron by following the 5 easy steps show below:
Step2 : Login to Lyftron
Start creating your connection
Step2.1Add your connection
Click on Connect section on the left panel → Click on Add Connection button In the connector selection panel, search and click Mailjet for your connection
Step2.2 Enter your connection details
In the Connection String section enter the values of the below parameters. The following connection string is required to establish Mailjet connection with Lyftron.Profile=Mailjet.apip;ProfileSettings='User=[your_api_key];Password=[your_APISecret];'
|Connection Name||Enter your connection details||Required|
|User||your Mailjet < API Key >||Required|
|Password||your Mailjet < API Secret >||Required|
|Logfile**||Use the logfile option to debug your job and provide your connection name to generate the log file. [ConnectionConfigurationPath]\Connection_name_log.tx||Optional|
|Verbosity**||Choose verbosity 1-5 based on the severity of debugging||Optional|
** For more information, check the Lyftron logging and debugging section.
If you want more detailed information about how to establish a connection with Lyftron, click on Lyftron Connection Quick Start guide.
Test your connection
Once you are done entering your connection details, simply click on the Test Connection button to test the connectivity. In case your connection fails, add Logfile and Verbosity parameters and check the Lyftron logging and debugging section, to debug the error.
Save your connection
Step3 : Normalize
Create data source
After establishing connection, datasource metadata import is needed and for that Lyftron automatically normalize your API & different SQL dialects data into ANSI SQL format and also gives you API sources into simple, code less out of the box data model.
3.1 Click on Normalize section from the left panel -> Click on Add Data Source button, Enter data source name -> Choose Mailjet from the existing connection list -> Click next
3.2 Choose the table you want to import and -> Click Create
The provider models the data in APIs into a list of tables that can be queried using standard SQL statements.
Generally, querying APIs 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.
|ApiKey||Tables||Retrieve a list of all API Keys and their configuration settings.|
|BounceStatistics||Tables||Retrieve a single or list of all bounce events.|
|CampaignDraft||Tables||Retrieve details on the configuration of all campaign drafts.|
|CampaignOverview||Tables||Get the details of Campaign overview|
|Campaigns||Tables||Retrieve details about a list of sent campaigns.|
|CampaignsDetailedContents||Tables||To view the content of your campaign draft email|
|CampaignStatistics||Tables||Retrieve a list of overall stringd delivery and engagement statistics, grouped by contact.|
|ClickStatistics||Tables||Retrieve a list of all click events and details about them|
|ContactData||Tables||Retrieve a list of contacts with all properties and respective values associated with those contacts.|
|ContactFilter||Tables||Retrieve a list of all segments and details on their configuration.|
|ContactManagement||Tables||Use the JobID generated after a POST /contact/managemanycontacts request to check its success, as well as any errors that might have occurred.|
|ContactMetaData||Tables||Retrieve a list of contact properties and their general settings - name and data type.|
|Contacts||Tables||Gets single or lists of contacts|
|ContactsLists||Tables||Retrieve details for all contact lists - name, subscriber count, creation timestamp, deletion status.|
|ContactsListSignup||Tables||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||Tables||Retrieve a list of overall stringd delivery and engagement statistics, grouped by contact.|
|Dns||Tables||Retrieve the SPF and DKIM settings for all sender domains on this API Key.|
|EventCallBackUrl||Tables||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||Tables||Retrieve aggregated open and click statistics, grouped by recipient country.|
|GetContactList||Tables||Get all the list of contacts in profile.|
|ListRecipient||Tables||Retrieve details on all list recipients, including the contact and list associated with them, as well as subscription status.|
|ListRecipientStatistics||Tables||Retrieve a list of overall stringd delivery and engagement statistics for all list recipients.|
|MessageHistory||Tables||Get the event history for a specific message.|
|MessageInformation||Tables||Retrieve sending / size / spam information about all messages.|
|Messages||Tables||Get a list of messages with specific information on the type of content, tracking, sending and delivery.|
|MetaSender||Tables||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||Tables||Manage your user profile data such as address, payment information etc.|
|OpenInformation||Tables||Retrieve a single or list of all open events and details about them - message, campaign and contact IDs, timestamp etc.|
|ParseRoute||Tables||Retrieve a list of all parseroute instances and their configuration settings.|
|RecipientEsp||Tables||Get stringd delivery and engagement statistics, grouped by recipient Email Service Provider (ESP).|
|Senders||Tables||Get information on a list of sender email addresses and/or domains.|
|SenderStatistics||Tables||Retrieve a list of overall stringd delivery and engagement statistics, grouped by sender ID.|
|SMS||Tables||Retrieve information about created / sent messages, including their sending status.|
|SMSCount||Tables||Retrieve the exact number of created messages.|
|SMSExport||Tables||Retrieve information about an export request of SMS messages.|
|StatCounters||Tables||Retrieve aggregated open and click statistics, grouped by recipient country.|
|StatisticsLinkClick||Tables||Retrieve aggregated click statistics for a campaign, grouped by URL links.|
|TemplateDetailedContent||Tables||Templates are essential building blocks for your campaigns, transactional emails or automation workflows|
|Templates||Tables||Retrieve a list of all templates and their configuration settings.|
|TopLinkClicked||Tables||Retrieve a list of open or click statistics, grouped by web browser or email client.|
|User||Tables||Get general information on your user settings and activity.|
|UserAgentStatistics||Tables||Retrieve a list of overall aggregated click statistics, grouped by URL.|
Step 4: Analyze
Querying the data source data
Lyftron allows you to query the source data by simply writing the ANSI Sql query. Please keep in mind as the data is coming directly from API so, there’s a limit to API calls and performance delay from the Stripe API side which Lyftron can’t control so, don’t expect to pull millions of records in just fraction of seconds. If you have heavy data loads, create the pipeline to unload that data into the Lyftron warehouse and query from it.
4.1. Click on the analyze section on the left panel -> Choose data source from the list. Drag and drop the table -> Choose your querying options
4.2. Click on -> EXECUTE and selected query will return data successfully
To view a detailed advanced settings options, go to Mailjet Advanced Settings. Complete list of the parameters you can configure in the connection string can be found by clicking Connection String Parameters.