EmailOctopus is an easy-to-use and inexpensive email marketing platform for anyone.
Data integration: Skyvia supports importing data to and from EmailOctopus, exporting EmailOctopus data to CSV files, and replicating EmailOctopus data to relational databases.
Backup: Skyvia Backup supports EmailOctopus backup.
Query: Skyvia Query supports EmailOctopus.
To create a connection with EmailOctopus, you need to specify an API Key.
To locate the API Key, perform the following steps:
- Sign in with your EmailOctopus account.
- Click the user icon and select Integrations & API.
Click Manage near the API.
Click Create key.
- Enter the API Key name.
- Copy or download the API Key.
The API Key is available only once when you create it. We recommend downloading the API Key and keeping it somewhere safe.
Specify the obtained API Key in the corresponding box in the Connection Editor.
EmailOctopus Contacts object is related to the Lists object as a child. You can query EmailOctopus contacts only by specifying the list that stores these contacts. EmailOctopus API requires a ListID value to query contacts from a list, for example, using a filter by ListID.
Skyvia does not require specifying ListID values for querying contacts. If you don’t specify ListID values, Skyvia queries all the Lists records first, takes their IDs, and then queries Contacts records for each Lists record. This method takes more time and consumes more API calls. It uses at least one API call for every Lists record.
Skyvia does not support the ListFields object. Lists fields are stored as a JSON arrays in the Fields column of the List object.
You can only import data into the Lists and Contacts objects. Other objects are read-only. You cannot import data to them or sync or restore their data from the backup.
Incremental Replication and Synchronization
Skyvia does not support Synchronization for EmailOctopus.
Since none of the EmailOctopus objects has the UpdatedDate field, Replication with Incremental Updates cannot detect the updated records. Only Lists and Contacts objects support Incremental Replication. These objects have the CreatedDate field. Thus Incremental Replication can detect only new records for these objects.
DML Operations Support
|INSERT, UPDATE, DELETE||Contact, Lists|
Skyvia supports all the common actions for EmailOctopus.