Windsor brings all your Notion data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Notion Field Reference
Fields
| Id | Type | Name | Description | Report |
|---|---|---|---|---|
| blocks__archived | BOOLEAN | blocks.archived | blocks.archived | blocks |
| blocks__bookmark | OBJECT | blocks.bookmark | blocks.bookmark | blocks |
| blocks__breadcrumb | OBJECT | blocks.breadcrumb | blocks.breadcrumb | blocks |
| blocks__bulleted_list_item | OBJECT | blocks.bulleted_list_item | blocks.bulleted_list_item | blocks |
| blocks__callout | OBJECT | blocks.callout | blocks.callout | blocks |
| blocks__child_database | OBJECT | blocks.child_database | blocks.child_database | blocks |
| blocks__child_page | OBJECT | blocks.child_page | blocks.child_page | blocks |
| blocks__code | OBJECT | blocks.code | blocks.code | blocks |
| blocks__column | OBJECT | blocks.column | blocks.column | blocks |
| blocks__column_list | OBJECT | blocks.column_list | blocks.column_list | blocks |
| blocks__created_by | OBJECT | blocks.created_by | blocks.created_by | blocks |
| blocks__created_time | TEXT | blocks.created_time | blocks.created_time | blocks |
| blocks__divider | OBJECT | blocks.divider | blocks.divider | blocks |
| blocks__embed | OBJECT | blocks.embed | blocks.embed | blocks |
| blocks__equation | OBJECT | blocks.equation | blocks.equation | blocks |
| blocks__file | OBJECT | blocks.file | blocks.file | blocks |
| blocks__has_children | BOOLEAN | blocks.has_children | blocks.has_children | blocks |
| blocks__heading_1 | OBJECT | blocks.heading_1 | blocks.heading_1 | blocks |
| blocks__heading_2 | OBJECT | blocks.heading_2 | blocks.heading_2 | blocks |
| blocks__heading_3 | OBJECT | blocks.heading_3 | blocks.heading_3 | blocks |
| blocks__id | TEXT | blocks.id | blocks.id | blocks |
| blocks__image | OBJECT | blocks.image | blocks.image | blocks |
| blocks__last_edited_by | OBJECT | blocks.last_edited_by | blocks.last_edited_by | blocks |
| blocks__last_edited_time | TEXT | blocks.last_edited_time | blocks.last_edited_time | blocks |
| blocks__link_preview | OBJECT | blocks.link_preview | blocks.link_preview | blocks |
| blocks__link_to_page | OBJECT | blocks.link_to_page | blocks.link_to_page | blocks |
| blocks__numbered_list_item | OBJECT | blocks.numbered_list_item | blocks.numbered_list_item | blocks |
| blocks__object | TEXT | blocks.object | blocks.object | blocks |
| blocks__paragraph | OBJECT | blocks.paragraph | blocks.paragraph | blocks |
| blocks__parent | OBJECT | blocks.parent | blocks.parent | blocks |
| blocks__pdf | OBJECT | blocks.pdf | blocks.pdf | blocks |
| blocks__quote | OBJECT | blocks.quote | blocks.quote | blocks |
| blocks__synced_block | OBJECT | blocks.synced_block | blocks.synced_block | blocks |
| blocks__table | OBJECT | blocks.table | blocks.table | blocks |
| blocks__table_of_contents | OBJECT | blocks.table_of_contents | blocks.table_of_contents | blocks |
| blocks__table_row | OBJECT | blocks.table_row | blocks.table_row | blocks |
| blocks__template | OBJECT | blocks.template | blocks.template | blocks |
| blocks__to_do | OBJECT | blocks.to_do | blocks.to_do | blocks |
| blocks__toggle | OBJECT | blocks.toggle | blocks.toggle | blocks |
| blocks__type | TEXT | blocks.type | blocks.type | blocks |
| blocks__unsupported | OBJECT | blocks.unsupported | blocks.unsupported | blocks |
| blocks__video | OBJECT | blocks.video | blocks.video | blocks |
| comments__created_by | OBJECT | comments.created_by | comments.created_by | comments |
| comments__created_time | TEXT | comments.created_time | comments.created_time | comments |
| comments__discussion_id | TEXT | comments.discussion_id | comments.discussion_id | comments |
| comments__id | TEXT | comments.id | comments.id | comments |
| comments__last_edited_time | TEXT | comments.last_edited_time | comments.last_edited_time | comments |
| comments__object | TEXT | comments.object | comments.object | comments |
| comments__page_last_edited_time | TEXT | comments.page_last_edited_time | comments.page_last_edited_time | comments |
| comments__parent | OBJECT | comments.parent | comments.parent | comments |
| comments__rich_text | OBJECT | comments.rich_text | comments.rich_text | comments |
| databases__archived | BOOLEAN | databases.archived | databases.archived | databases |
| databases__cover | OBJECT | databases.cover | databases.cover | databases |
| databases__created_by | OBJECT | databases.created_by | databases.created_by | databases |
| databases__created_time | TEXT | databases.created_time | databases.created_time | databases |
| databases__description | OBJECT | databases.description | databases.description | databases |
| databases__icon | TEXT | databases.icon | databases.icon | databases |
| databases__id | TEXT | databases.id | databases.id | databases |
| databases__is_inline | BOOLEAN | databases.is_inline | databases.is_inline | databases |
| databases__last_edited_by | OBJECT | databases.last_edited_by | databases.last_edited_by | databases |
| databases__last_edited_time | TEXT | databases.last_edited_time | databases.last_edited_time | databases |
| databases__object | TEXT | databases.object | databases.object | databases |
| databases__parent | OBJECT | databases.parent | databases.parent | databases |
| databases__properties | OBJECT | databases.properties | databases.properties | databases |
| databases__public_url | TEXT | databases.public_url | databases.public_url | databases |
| databases__title | OBJECT | databases.title | databases.title | databases |
| databases__url | TEXT | databases.url | databases.url | databases |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| pages__archived | BOOLEAN | pages.archived | pages.archived | pages |
| pages__cover | OBJECT | pages.cover | pages.cover | pages |
| pages__created_by | OBJECT | pages.created_by | pages.created_by | pages |
| pages__created_time | TEXT | pages.created_time | pages.created_time | pages |
| pages__icon | TEXT | pages.icon | pages.icon | pages |
| pages__id | TEXT | pages.id | pages.id | pages |
| pages__last_edited_by | OBJECT | pages.last_edited_by | pages.last_edited_by | pages |
| pages__last_edited_time | TEXT | pages.last_edited_time | pages.last_edited_time | pages |
| pages__object | TEXT | pages.object | pages.object | pages |
| pages__parent | OBJECT | pages.parent | pages.parent | pages |
| pages__properties | OBJECT | pages.properties | pages.properties | pages |
| pages__public_url | TEXT | pages.public_url | pages.public_url | pages |
| pages__url | TEXT | pages.url | pages.url | pages |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| users__avatar_url | TEXT | users.avatar_url | users.avatar_url | users |
| users__bot | OBJECT | users.bot | users.bot | users |
| users__id | TEXT | users.id | users.id | users |
| users__name | TEXT | users.name | users.name | users |
| users__object | TEXT | users.object | users.object | users |
| users__person | OBJECT | users.person | users.person | users |
| users__type | TEXT | users.type | users.type | users |