Notion

Setting up the Notion connector

No	Item	Required	Example	Notes
1	Authenticate using	Yes		Pick an authentication method. Refer to the documentation in the form while using the connector OAuth2.0 Access Token

Tables in the Notion connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	blocks	27		Full Refresh, Incremental	last_edited_time	API Reference
2	users	0		Full Refresh		API Reference

Table: blocks

No	Column Name	Type	Notes
1	paragraph	VARCHAR
2	callout	VARCHAR
3	code	VARCHAR
4	numbered_list_item	VARCHAR
5	type	VARCHAR
6	archived	BOOLEAN
7	bulleted_list_item	VARCHAR
8	child_page	VARCHAR
9	quote	VARCHAR
10	file	VARCHAR
11	vidoe	VARCHAR
12	to_do	VARCHAR
13	id	VARCHAR
14	embed	VARCHAR
15	created_time	VARCHAR
16	image	VARCHAR
17	has_children	BOOLEAN
18	equation	VARCHAR
19	child_database	VARCHAR
20	toggle	VARCHAR
21	bookmark	VARCHAR
22	last_edited_time	VARCHAR	Incremental sync key
23	pdf	VARCHAR
24	heading_1	VARCHAR
25	heading_2	VARCHAR
26	heading_3	VARCHAR
27	object	VARCHAR

Table: users

| No | Column Name | Type | Notes || --- | ----------- | ---- | ----- |

External Resources

• My Integrations
• Capabilities
• Internal Integration
• Public Integration
• Notion Api
• Databases
• Pages
• Request Limits

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.