API Connectors

users-love-us medal soc2
Send your EmailOctopus data to
Data StudioGoogle SheetsChatGPTClaudePower BIExcelTableauGoogle BigQueryAmazon S3Azure Blob StorageSnowflakeMySQLPostgreSQLPythonAzure SQLAmazon RedshiftDatabricksWindsor MCPMicrosoft FabricCopilot AgentPerplexityLovableAntigravitySupabase

EmailOctopus Connector Reference

19 dimensions
Fields

The EmailOctopus connector exposes 19 fields (0 metrics, 19 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


EmailOctopus Fields

EmailOctopus campaigns fields

The campaigns report of the EmailOctopus connector includes 8 fields.

ID Type Name Description
campaigns__created_at TEXT campaigns.created_at campaigns.created_at
campaigns__from OBJECT campaigns.from campaigns.from
campaigns__id TEXT campaigns.id campaigns.id
campaigns__name TEXT campaigns.name campaigns.name
campaigns__sent_at TEXT campaigns.sent_at campaigns.sent_at
campaigns__status TEXT campaigns.status campaigns.status
campaigns__subject TEXT campaigns.subject campaigns.subject
campaigns__to OBJECT campaigns.to campaigns.to

EmailOctopus lists fields

The lists report of the EmailOctopus connector includes 6 fields.

ID Type Name Description
lists__counts OBJECT lists.counts lists.counts
lists__created_at TEXT lists.created_at lists.created_at
lists__double_opt_in BOOLEAN lists.double_opt_in lists.double_opt_in
lists__fields OBJECT lists.fields lists.fields
lists__id TEXT lists.id lists.id
lists__name TEXT lists.name lists.name

EmailOctopus other fields

The EmailOctopus connector has 5 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID Type Name Description Report
data_fetched_at TIMESTAMP Data fetched at UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource TEXT Data Source The name of the Windsor connector returning the row
now TIMESTAMP Now Current timestamp
source TEXT Source The name of the Windsor connector returning the row
today DATE Today Today's date