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.
This 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.