Notion

Creating the data source

Requirements

  1. Member access to the Workspace (not just as a guest)
  2. Full or edit access to the pages or databases to be integrated

Instructions

  1. Go to https://www.notion.com/my-integrations
  2. Click on New integration
  3. Give your integration a name and select the Workspace it will apply to
  4. Leave the type as Internal and click Save
  5. Click on Configure integration settings
  6. Locate Internal Integration Secret and click Show
  7. Click Copy
  8. Locate Capabilities, check the options below, and click Save
    1. Read Content
    2. Read Comments
    3. Read user information including email addresses
  9. At the top, locate Access
  10. Click Select pages
  11. Check the pages and databases you want to access and click Update access
    1. Attention: Whenever a new page or database is created, you must check it as accessible on this page
  12. On the Kondado platform, go to the Notion connector setup page and paste the integration secret obtained in step 6

The new object datasources and its child objects will not be returned

Pipelines

Summary

Relationship chart

Click to expand

Databases: records

Campo Tipo

object_id

text

[en] Internal ID of the object.

md_archived

boolean

[en] The archived status of the pages.

md_cover_external_url

text

[en] URL of the cover image used on the page.

md_cover_type

text

[en] Type of cover image, usually 'external' for external URLs.

md_created_by_id

text

[en] Identifier of the user who created the object.

md_created_by_object

text

[en] Object creator type, usually 'user'.

md_created_time

timestamp

[en] Date and time of creation of this page. Formatted as a date and time sequence.

md_icon_external_url

text

[en] URL of the icon used on the page.

md_icon_type

text

[en] Type of icon of the page, usually 'external' for external URLs.

md_in_trash

boolean

[en] If the page has been deleted.

md_last_edited_by_id

text

[en] Identifier of the user who made the last edition of the object.

md_last_edited_by_object

text

[en] Type of user who made the last edit, usually 'user'.

md_last_edited_time

timestamp

[en] Date and time this page was updated. Formatted as a date and time sequence.

md_object

text

[en] Always 'page'.

md_public_url

text

[en] The URL of the public page, if the page has been published on the web. Otherwise, null.

md_url

text

[en] The URL of the Notion page.

Databases: records: blocks

Main object

Campo Tipo

object_id

text

    Databases: records > > object_id

archived

boolean

[en] Indicates whether the block is archived in Notion.

created_by_id

text

[en] Identifier of the user who created the block.

created_by_object

text

[en] Type of the block creator, usually 'user'.

created_time

timestamp

[en] Date and time when the block was created.

has_children

boolean

[en] Indicates whether the block has nested child blocks.

in_trash

boolean

[en] Indicates whether the block has been moved to trash.

last_edited_by_id

text

[en] Identifier of the user who last edited the block.

last_edited_by_object

text

[en] Type of the user who last edited the block.

last_edited_time

timestamp

[en] Date and time of the last edit of the block.

object

text

[en] Type of object returned, always block.

parent_page_id

text

[en] Identifier of the parent page that contains the block.

parent_block_id

text

[en] Identifier of the parent block that contains the block.

parent_type

text

[en] Type of parent element to which the block belongs, such as 'page_id' or 'block_id'.

audio_external_url

text

[en] External URL of the audio file embedded in the block.

audio_file_url

text

[en] URL of the audio file embedded in the block.

audio_file_expiry_time

timestamp

[en] Expiration time of the audio file embedded in the block.

audio_type

text

[en] Type of the audio source, such as 'external' for external URLs.

bookmark_url

text

[en] URL of the bookmark (favorite) referenced in the block.

child_database_title

text

[en] Title of the child database embedded within the block.

child_page_title

text

[en] Title of the child page embedded in the block.

embed_url

text

[en] URL of embedded content, such as web pages or external apps.

equation_expression

text

[en] Mathematical expression written using LaTeX notation.

image_file_expiry_time

timestamp

[en] Expiration date and time for the temporary image URL hosted by Notion.

image_file_url

text

[en] URL of the image file uploaded directly to Notion.

image_type

text

[en] Type of image source (e.g., 'file' or 'external').

link_preview_url

text

[en] URL used for generating the link preview block.

pdf_external_url

text

[en] URL of the PDF document embedded in the block.

pdf_file_url

text

[en] URL of the PDF file embedded in the block.

pdf_file_expiry_time

timestamp

[en] Expiration time of the PDF file in the block.

pdf_type

text

[en] Source type of the PDF document (e.g., 'external' for external link).

table_has_column_header

boolean

[en] Indicates whether the table has a column header.

table_has_row_header

boolean

[en] Indicates whether the table has a row header.

table_table_width

float

[en] Number of columns in the table.

table_of_contents_color

text

[en] Color used for the table of contents block.

video_external_url

text

[en] URL of the external video embedded in the block.

video_type

text

[en] Type of the embedded video, such as 'external'.

file_external_url

text

[en] URL of the externally hosted file embedded in the block.

file_url

text

[en] URL of the file embedded in the block.

file_expiry_time

text

[en] Expiration date for the file URL.

file_name

text

[en] Name of the file displayed in the block.

file_type

text

[en] Type of the file source, typically 'external' or 'file'.

callout_color

text

[en] Background color or theme color used in the callout block.

callout_icon_emoji

text

[en] Emoji used as the icon in the callout block.

callout_icon_file_expiry_time

timestamp

[en] Expiration date for the file URL used as an icon.

callout_icon_file_url

text

[en] URL of the icon file used in the callout block (if not an emoji).

code_language

text

[en] Programming language used for syntax highlighting in the code block.

numbered_list_item_color

text

[en] Text color or background color of the numbered list item.

to_do_checked

boolean

[en] Indicates whether the to-do item is checked (completed) or not.

to_do_color

text

[en] Text or background color of the to-do item.

column_width_ratio

float

[en] Width ratio of the columns, should add up to 1.

notion_dummy_database_name_blocks_heading_1_rich_text

Campo Tipo

object_id

text

annotations_italic

boolean

[en] Indicates whether the rich text is italicized.

text_content

text

[en] Main content inside the rich text block.

annotations_code

boolean

[en] Indicates whether the rich text is formatted as code.

text_link_url

text

[en] Link associated with the rich text content, if any.

annotations_color

text

[en] Color applied to the rich text annotation.

parent_page_id

text

[en] Identifier of the page where the block was added.

    Databases: records: blocks > > object_id

annotations_strikethrough

boolean

[en] Indicates whether the rich text is struck through.

annotations_bold

boolean

[en] Indicates whether the rich text is bold.

plain_text

text

[en] Plain text representation of the rich text.

href

text

[en] Hyperlink associated with the rich text content.

annotations_underline

boolean

[en] Indicates whether the rich text is underlined.

notion_dummy_database_name_blocks_heading_2_rich_text

Campo Tipo

object_id

text

href

text

[en] Hyperlink associated with the rich text content.

annotations_bold

boolean

[en] Indicates whether the rich text is bold.

annotations_strikethrough

boolean

[en] Indicates whether the rich text is struck through.

plain_text

text

[en] Plain text representation of the rich text.

text_link_url

text

[en] Link associated with the rich text content, if any.

annotations_code

boolean

[en] Indicates whether the rich text is formatted as code.

annotations_color

text

[en] Color applied to the rich text annotation.

text_content

text

[en] Main content inside the rich text block.

annotations_italic

boolean

[en] Indicates whether the rich text is italicized.

parent_page_id

text

[en] Identifier of the page where the block was added.

    Databases: records: blocks > > object_id

annotations_underline

boolean

[en] Indicates whether the rich text is underlined.

notion_dummy_database_name_blocks_heading_3_rich_text

Campo Tipo

object_id

text

annotations_code

boolean

[en] Indicates whether the rich text is formatted as code.

annotations_underline

boolean

[en] Indicates whether the rich text is underlined.

annotations_color

text

[en] Color applied to the rich text annotation.

href

text

[en] Hyperlink associated with the rich text content.

plain_text

text

[en] Plain text representation of the rich text.

annotations_strikethrough

boolean

[en] Indicates whether the rich text is struck through.

parent_page_id

text

[en] Identifier of the page where the block was added.

    Databases: records: blocks > > object_id

annotations_bold

boolean

[en] Indicates whether the rich text is bold.

text_link_url

text

[en] Link associated with the rich text content, if any.

text_content

text

[en] Main content inside the rich text block.

annotations_italic

boolean

[en] Indicates whether the rich text is italicized.

notion_dummy_database_name_blocks_bulleted_list_item_rich_text

Campo Tipo

object_id

text

text_link_url

text

[en] Link associated with the rich text content, if any.

plain_text

text

[en] Plain text representation of the rich text.

annotations_bold

boolean

[en] Indicates whether the rich text is bold.

href

text

[en] Hyperlink associated with the rich text content.

text_content

text

[en] Main content inside the rich text block.

annotations_underline

boolean

[en] Indicates whether the rich text is underlined.

annotations_italic

boolean

[en] Indicates whether the rich text is italicized.

annotations_strikethrough

boolean

[en] Indicates whether the rich text is struck through.

parent_page_id

text

[en] Identifier of the page where the block was added.

    Databases: records: blocks > > object_id

annotations_code

boolean

[en] Indicates whether the rich text is formatted as code.

annotations_color

text

[en] Color applied to the rich text annotation.

notion_dummy_database_name_blocks_paragraph_rich_text

Campo Tipo

object_id

text

text_link_url

text

[en] Link associated with the rich text content, if any.

href

text

[en] Hyperlink associated with the rich text content.

annotations_strikethrough

boolean

[en] Indicates whether the rich text is struck through.

annotations_bold

boolean

[en] Indicates whether the rich text is bold.

plain_text

text

[en] Plain text representation of the rich text.

annotations_code

boolean

[en] Indicates whether the rich text is formatted as code.

annotations_color

text

[en] Color applied to the rich text annotation.

annotations_underline

boolean

[en] Indicates whether the rich text is underlined.

parent_page_id

text

[en] Identifier of the page where the block was added.

    Databases: records: blocks > > object_id

annotations_italic

boolean

[en] Indicates whether the rich text is italicized.

text_content

text

[en] Main content inside the rich text block.

notion_dummy_database_name_blocks_callout_rich_text

Campo Tipo

object_id

text

annotations_color

text

[en] Color applied to the rich text annotation.

text_link_url

text

[en] Link associated with the rich text content, if any.

annotations_strikethrough

boolean

[en] Indicates whether the rich text is struck through.

annotations_underline

boolean

[en] Indicates whether the rich text is underlined.

parent_page_id

text

[en] Identifier of the page where the block was added.

    Databases: records: blocks > > object_id

annotations_italic

boolean

[en] Indicates whether the rich text is italicized.

annotations_bold

boolean

[en] Indicates whether the rich text is bold.

annotations_code

boolean

[en] Indicates whether the rich text is formatted as code.

text_content

text

[en] Main content inside the rich text block.

href

text

[en] Hyperlink associated with the rich text content.

plain_text

text

[en] Plain text representation of the rich text.

notion_dummy_database_name_blocks_code_rich_text

Campo Tipo

object_id

text

annotations_color

text

[en] Color applied to the rich text annotation.

text_content

text

[en] Main content inside the rich text block.

parent_page_id

text

[en] Identifier of the page where the block was added.

    Databases: records: blocks > > object_id

annotations_underline

boolean

[en] Indicates whether the rich text is underlined.

annotations_italic

boolean

[en] Indicates whether the rich text is italicized.

annotations_strikethrough

boolean

[en] Indicates whether the rich text is struck through.

href

text

[en] Hyperlink associated with the rich text content.

plain_text

text

[en] Plain text representation of the rich text.

annotations_bold

boolean

[en] Indicates whether the rich text is bold.

annotations_code

boolean

[en] Indicates whether the rich text is formatted as code.

text_link_url

text

[en] Link associated with the rich text content, if any.

notion_dummy_database_name_blocks_quote_rich_text

Campo Tipo

object_id

text

parent_page_id

text

[en] Identifier of the page where the block was added.

    Databases: records: blocks > > object_id

annotations_color

text

[en] Color applied to the rich text annotation.

text_link_url

text

[en] Link associated with the rich text content, if any.

annotations_strikethrough

boolean

[en] Indicates whether the rich text is struck through.

annotations_underline

boolean

[en] Indicates whether the rich text is underlined.

annotations_italic

boolean

[en] Indicates whether the rich text is italicized.

annotations_code

boolean

[en] Indicates whether the rich text is formatted as code.

annotations_bold

boolean

[en] Indicates whether the rich text is bold.

href

text

[en] Hyperlink associated with the rich text content.

text_content

text

[en] Main content inside the rich text block.

plain_text

text

[en] Plain text representation of the rich text.

notion_dummy_database_name_blocks_to_do_rich_text

Campo Tipo

object_id

text

annotations_bold

boolean

[en] Indicates whether the rich text is bold.

annotations_code

boolean

[en] Indicates whether the rich text is formatted as code.

plain_text

text

[en] Plain text representation of the rich text.

annotations_color

text

[en] Color applied to the rich text annotation.

annotations_strikethrough

boolean

[en] Indicates whether the rich text is struck through.

parent_page_id

text

[en] Identifier of the page where the block was added.

    Databases: records: blocks > > object_id

text_link_url

text

[en] Link associated with the rich text content, if any.

annotations_italic

boolean

[en] Indicates whether the rich text is italicized.

href

text

[en] Hyperlink associated with the rich text content.

text_content

text

[en] Main content inside the rich text block.

annotations_underline

boolean

[en] Indicates whether the rich text is underlined.

notion_dummy_database_name_blocks_toggle_rich_text

Campo Tipo

object_id

text

text_content

text

[en] Main content inside the rich text block.

annotations_strikethrough

boolean

[en] Indicates whether the rich text is struck through.

annotations_italic

boolean

[en] Indicates whether the rich text is italicized.

text_link_url

text

[en] Link associated with the rich text content, if any.

parent_page_id

text

[en] Identificador da página onde o bloco foi adicionado.

    Databases: records: blocks > > object_id

annotations_code

boolean

[en] Indicates whether the rich text is formatted as code.

annotations_color

text

[en] Color applied to the rich text annotation.

annotations_underline

boolean

[en] Indicates whether the rich text is underlined.

plain_text

text

[en] Plain text representation of the rich text.

annotations_bold

boolean

[en] Indicates whether the rich text is bold.

href

text

[en] Hyperlink associated with the rich text content.

notion_dummy_database_name_blocks_title

Campo Tipo

object_id

text

text_content

text

[en] Main content inside the rich text block.

annotations_strikethrough

boolean

[en] Indicates whether the rich text is struck through.

annotations_italic

boolean

[en] Indicates whether the rich text is italicized.

text_link_url

text

[en] Link associated with the rich text content, if any.

parent_page_id

text

[en] Identificador da página onde o bloco foi adicionado.

    Databases: records: blocks > > object_id

annotations_code

boolean

[en] Indicates whether the rich text is formatted as code.

annotations_color

text

[en] Color applied to the rich text annotation.

annotations_underline

boolean

[en] Indicates whether the rich text is underlined.

plain_text

text

[en] Plain text representation of the rich text.

annotations_bold

boolean

[en] Indicates whether the rich text is bold.

href

text

[en] Hyperlink associated with the rich text content.

Databases: records: blocks: comments

Main object

Campo Tipo

object_id

text

[en] Unique identifier of the block to which the comment is associated.

    Databases: records > > object_id

md_created_by_id

text

[en] Identifier of the user who created the comment.

md_created_by_object

text

[en] Type of comment creator, usually 'user'.

md_created_time

timestamp

[en] Date and time when the comment was created.

md_discussion_id

text

[en] Identifier of the discussion group to which the comment belongs.

md_last_edited_time

timestamp

[en] Date and time of the last edit of the comment.

md_parent_page_id

text

[en] Identifier of the page where the comment was added.

    Databases: records: blocks > > object_id

md_parent_block_id

text

[en] Identifier of the block where the comment was added.

    Databases: records: blocks > > object_id

md_parent_type

text

[en] Type of parent element to which the comment is associated (e.g., 'page_id').

notion_dummy_database_name_blocks_comments_rich_text

Campo Tipo

comment_id

text

[en] Unique identifier of the block to which the comment is associated.

parent_page_id

text

[en] Identifier of the page where the comment was added.

    Databases: records: blocks > > object_id

parent_block_id

text

[en] Identifier of the block where the comment was added.

    Databases: records: blocks > > object_id

annotations_bold

boolean

[en] Indicates whether the rich text is bold.

annotations_code

boolean

[en] Indicates whether the rich text is formatted as code.

annotations_color

text

[en] Color applied to the rich text annotation.

annotations_italic

boolean

[en] Indicates whether the rich text is italicized.

annotations_strikethrough

boolean

[en] Indicates whether the rich text is struck through.

annotations_underline

boolean

[en] Indicates whether the rich text is underlined.

href

text

[en] Hyperlink associated with the rich text content.

plain_text

text

[en] Plain text representation of the rich text.

text_content

text

[en] Main content inside the rich text block.

text_link_url

text

[en] Link associated with the rich text content, if any.

Databases: records: comments

Main object

Campo Tipo

object_id

text

[en] Unique identifier of the block to which the comment is associated.

    Databases: records > > object_id

md_created_by_id

text

[en] Identifier of the user who created the comment.

md_created_by_object

text

[en] Type of comment creator, usually 'user'.

md_created_time

timestamp

[en] Date and time when the comment was created.

md_discussion_id

text

[en] Identifier of the discussion group to which the comment belongs.

md_last_edited_time

timestamp

[en] Date and time of the last edit of the comment.

md_parent_page_id

text

[en] Identifier of the page where the comment was added.

    Databases: records: blocks > > object_id

md_parent_block_id

text

[en] Identifier of the block where the comment was added.

    Databases: records: blocks > > object_id

md_parent_type

text

[en] Type of parent element to which the comment is associated (e.g., 'page_id').

notion_dummy_database_name_blocks_comments_rich_text

Campo Tipo

comment_id

text

[en] Unique identifier of the block to which the comment is associated.

parent_page_id

text

[en] Identifier of the page where the comment was added.

    Databases: records: blocks > > object_id

parent_block_id

text

[en] Identifier of the block where the comment was added.

    Databases: records: blocks > > object_id

annotations_bold

boolean

[en] Indicates whether the rich text is bold.

annotations_code

boolean

[en] Indicates whether the rich text is formatted as code.

annotations_color

text

[en] Color applied to the rich text annotation.

annotations_italic

boolean

[en] Indicates whether the rich text is italicized.

annotations_strikethrough

boolean

[en] Indicates whether the rich text is struck through.

annotations_underline

boolean

[en] Indicates whether the rich text is underlined.

href

text

[en] Hyperlink associated with the rich text content.

plain_text

text

[en] Plain text representation of the rich text.

text_content

text

[en] Main content inside the rich text block.

text_link_url

text

[en] Link associated with the rich text content, if any.