Connecting to EmailOctopus
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.
EmailOctopus-Specific Features and Limitations
EmailOctopus contacts can be accessed only via their lists. EmailOctopus API requires a ListID value to query contacts from a list, and does not allow just querying all the contacts directly. Skyvia does not require specifying ListID values for querying contacts.
If you don’t specify ListID values (for example, in a filter), Skyvia queries all the Lists records first, takes their IDs and then queries Contacts records for each List record. This allows querying child objects without knowing their parents, but this method takes more time and consumes more API calls. It uses at least one API call for every Lists record.
Because of this, it is recommended to use filters on the Lists object fields when querying data from Contacts. This reduces the number of lists, for which Contacts data must be queried.
Skyvia has the following limitations for EmailOctopus:
Skyvia does not support the ListFields object. List fields, however, are available via the Fields column of the List objects as a JSON array.
Only two EmailOctopus objects support writing: Lists and Contacts. Other objects are read-only, so you cannot import data to them or sync or restore their data from the backup.
Synchronization is not supported for EmailOctopus.
Since EmailOctopus objects don’t have fields, storing record modification time, replication with incremental updates cannot detect updating an existing record. Moreover, only Lists and Contacts objects have the CreatedDate field that stores record creation time, and only they support replication with incremental updates.
Don’t put EmailOctopus List ID values in curly brackets in filters, expressions, etc.
To connect to EmailOctopus, you need to specify your API Key.
- API Key is an automatically generated REST API key used for connecting to EmailOctopus. Check the following link in the EmailOctopus documentation to know how to get API Key and URL.
Supported Actions and Actions Specifics
EmailOctopus 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.