Postmarkapp

Tables in the Postmarkapp connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	server	22
2	servers	22	ID	Full Refresh		API Reference
3	deliverystats	2	Name	Full Refresh
4	templates	2
5	messages	16	MessageID	Full Refresh
6	domains	6	ID	Full Refresh		API Reference
7	outbound-stats	17
8	bounces	17	ID	Full Refresh
9	message-streams	10	ID	Full Refresh		API Reference

Table: server

No	Column Name	Type	Notes
1	ClickHookUrl	VARCHAR
2	EnableSmtpApiErrorHooks	BOOLEAN
3	ApiTokens	VARCHAR
4	ServerLink	VARCHAR
5	Color	VARCHAR
6	DeliveryHookUrl	VARCHAR
7	RawEmailEnabled	BOOLEAN
8	TrackLinks	VARCHAR
9	InboundHash	VARCHAR
10	OpenHookUrl	VARCHAR
11	InboundSpamThreshold	INTEGER
12	BounceHookUrl	VARCHAR
13	Name	VARCHAR
14	InboundAddress	VARCHAR
15	InboundHookUrl	VARCHAR
16	TrackOpens	BOOLEAN
17	IncludeBounceContentInHook	BOOLEAN
18	PostFirstOpenOnly	BOOLEAN
19	ID	INTEGER
20	InboundDomain	VARCHAR
21	SmtpApiActivated	BOOLEAN
22	DeliveryType	VARCHAR

Table: servers

No	Column Name	Type	Notes
1	ClickHookUrl	VARCHAR
2	EnableSmtpApiErrorHooks	BOOLEAN
3	ApiTokens	VARCHAR
4	ServerLink	VARCHAR
5	Color	VARCHAR
6	DeliveryHookUrl	VARCHAR
7	RawEmailEnabled	BOOLEAN
8	TrackLinks	VARCHAR
9	InboundHash	VARCHAR
10	OpenHookUrl	VARCHAR
11	InboundSpamThreshold	INTEGER
12	BounceHookUrl	VARCHAR
13	Name	VARCHAR
14	InboundAddress	VARCHAR
15	InboundHookUrl	VARCHAR
16	TrackOpens	BOOLEAN
17	IncludeBounceContentInHook	BOOLEAN
18	PostFirstOpenOnly	BOOLEAN
19	ID	INTEGER	Primary Key
20	InboundDomain	VARCHAR
21	SmtpApiActivated	BOOLEAN
22	DeliveryType	VARCHAR

Table: deliverystats

No	Column Name	Type	Notes
1	Count	INTEGER
2	Name	VARCHAR	Primary Key

Table: templates

No	Column Name	Type	Notes
1	TotalCount	INTEGER
2	Templates	VARCHAR

Table: messages

No	Column Name	Type	Notes
1	Cc	VARCHAR
2	Status	VARCHAR
3	Bcc	VARCHAR
4	Recipients	VARCHAR
5	Metadata	VARCHAR
6	TrackLinks	VARCHAR
7	From	VARCHAR
8	Sandboxed	BOOLEAN
9	Attachments	VARCHAR
10	Subject	VARCHAR
11	TrackOpens	BOOLEAN
12	MessageStream	VARCHAR
13	Tag	VARCHAR
14	To	VARCHAR
15	ReceivedAt	VARCHAR
16	MessageID	VARCHAR	Primary Key

Table: domains

No	Column Name	Type	Notes
1	DKIMVerified	BOOLEAN
2	WeakDKIM	BOOLEAN
3	SPFVerified	BOOLEAN
4	ID	INTEGER	Primary Key
5	ReturnPathDomainVerified	BOOLEAN
6	Name	VARCHAR

Table: outbound-stats

No	Column Name	Type	Notes
1	TotalClicks	INTEGER
2	Opens	INTEGER
3	WithPlatformRecorded	INTEGER
4	WithLinkTracking	INTEGER
5	WithOpenTracking	INTEGER
6	SpamComplaints	INTEGER
7	UniqueOpens	INTEGER
8	WithClientRecorded	INTEGER
9	SpamComplaintsRate	DOUBLE
10	WithReadTimeRecorded	INTEGER
11	BounceRate	DOUBLE
12	Tracked	INTEGER
13	TotalTrackedLinksSent	INTEGER
14	Bounced	INTEGER
15	UniqueLinksClicked	INTEGER
16	SMTPApiErrors	INTEGER
17	Sent	INTEGER

Table: bounces

No	Column Name	Type	Notes
1	Description	VARCHAR
2	Email	VARCHAR
3	TypeCode	INTEGER
4	DumpAvailable	BOOLEAN
5	From	VARCHAR
6	Subject	VARCHAR
7	Name	VARCHAR
8	Type	VARCHAR
9	ServerID	INTEGER
10	Details	VARCHAR
11	MessageStream	VARCHAR
12	BouncedAt	VARCHAR
13	Inactive	BOOLEAN
14	ID	INTEGER	Primary Key
15	Tag	VARCHAR
16	MessageID	VARCHAR
17	CanActivate	BOOLEAN

Table: message-streams

No	Column Name	Type	Notes
1	ServerID	INTEGER
2	Description	VARCHAR
3	ArchivedAt	VARCHAR
4	ExpectedPurgeDate	VARCHAR
5	SubscriptionManagementConfiguration	VARCHAR
6	CreatedAt	VARCHAR
7	MessageStreamType	VARCHAR
8	ID	VARCHAR	Primary Key
9	UpdatedAt	VARCHAR
10	Name	VARCHAR

External Resources

• Postmarkapp Api
• Postmarkapp Dashboard
• Bounces: Deliverystats
• Outbound Stats
• Sender Signatures

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.