Mailgun
Mailgun is an email delivery service. Mailgun’s email API for application-driven emails gives you an easy way to automate your sending based on user actions in your app or connect with any platform.
Data integration: Skyvia supports importing data to and from Mailgun, exporting Mailgun data to CSV files and replicating Mailgun data to relational databases.
Backup: Skyvia Backup does not support Mailgun.
Query: Skyvia Query supports Mailgun.
Mailgun-Specific Features and Limitations
Skyvia has the following limitations for Mailgun:
-
In the Data Integration product, Mailgun connections are supported only for packages, which use a new data integration runtime.
Make sure that the Use new runtime checkbox is selected on the tab bar if you want to use Mailgun in your package.
- Skyvia supports DML operations for such Mailgun objects:
- INSERT, UPDATE, DELETE: IPPools, ListMembers, MailingLists, Routes, Templates.
- INSERT, DELETE: Bounces, Compliants, Domains, Unsubscribes, Whitelists
- UPDATE, DELETE: Tags.
- INSERT: SeedLists.
- DELETE: SeedResults.
- Skyvia supports Replication with Incremental Updates for such Mailgun objects: Complaints, Domains, MailingLists, Routes, Templates, Unsubscribes, Whitelists.
- Synchronization is not supported for Mailgun.
-
_Events support peculiarities. A separate object has been created for each of the 9 types of events, since the object structure for each type is different. They are the following objects:
Events_Accepted, Events_Delivered, Events_Failed, Events_Opened, Events_Unsubscribed, Events_stored, Events_Rejected, Events_Clicked, Events_Complained.
-
SendMessages object and its peculiarities. The object is implemented through the stored procedure:
call SendMessage(:from, :to, :text, :html, :cc, :bcc, :subject, :amp-html, :template)
The required parameters are from and to, either text or html should be specified. You can use a call to the stored procedure, for example as a text of the command in the ExecuteCommand action in a Target component of a Data Flow.
Mailgun Connections
To create a connection to Mailgun, you simply need to specify your Private API Key and Domain. To start creating a connection, follow the below steps:
- Click +NEW in the top menu.
- Click Connection in the menu on the left to open the Select Connector page.
- In the opened pane, click Mailgun.
- In the Connection Editor page, in the Untitled field, specify a connection name that will be used to identify the connection.
-
Select API Region from the drop-down list.
- Paste your private API Key.
- Specify your domain. Please note that you should enter your domain in the following way to receive data correctly: sandbox355fba5b89c0467b8651c98273013e4d.mailgun.org.
-
Finally, use the Test Connection button to make sure that the connection is successful and then click Create Connection.
Supported Actions and Actions Specifics
Mailgun connector supports the following actions:
- Execute Command in Source, Lookup, and Target Data Flow components and in Import and Export tasks in the Advanced mode.
-
Execute Query in Source Data Flow components and in Import and Export tasks in the Advanced mode.
- Lookup in Lookup Data Flow components.
- Insert in Target Data Flow components.
- Update in Target Data Flow components.
- Delete in Target Data Flow components.