Linking Mailjet as a source
Contents
Alpha release
This source is currently in alpha. The interface and available tables may change.
Enter your Mailjet API key and secret key to pull your Mailjet data into the PostHog data warehouse.
Adding a data source
- Go to the sources tab of the data pipeline section in PostHog.
- Click + New source and then click Link next to Mailjet.
- Find your API key and Secret key on your Mailjet API key management page.
- Back in PostHog, enter the API key and secret key, then click Next.
- Select the tables you want to sync, set the sync method and frequency, then click Import.
Once the syncs are complete, you can start using Mailjet data in PostHog.
Available tables
| Table | Description | Sync method |
|---|---|---|
contact | Contacts | Full refresh |
contactslist | Contact lists | Full refresh |
listrecipient | Contact-to-list membership records | Full refresh |
campaign | Campaigns | Full refresh |
campaigndraft | Campaign drafts | Full refresh |
message | Messages | Full refresh |
contactmetadata | Contact metadata definitions | Full refresh |
template | Templates | Full refresh |
openinformation | Email open statistics | Incremental |
clickstatistics | Email click statistics | Incremental |
Incremental tables sync only new or updated records on each run. Full refresh tables reload all data on each sync.
Sync limitations
Only the statistics tables (openinformation and clickstatistics) support incremental syncing, using Mailjet's FromTS time-window filter. The list resources have no reliable server-side time filter and are full refresh only.
Configuration
| Option | Type | Required |
|---|---|---|
API key | password | Yes |
Secret key | password | Yes |