Notion API Functions

2025-02-20 11:13 UTC gpt-4o Open in ChatGPT ↗

You

can you explain what happens here:

def notion_post_request(url): try: response = requests.post(url, headers=NOTION_REQUEST_HEADERS)

    # Check if the request was successful
    response.raise_for_status()  # Raise an exception for any HTTP error

    # Parse the response JSON
    data = response.json()

    return data

except requests.exceptions.RequestException as e:
    print(f"Error during POST request: {e}")
    return None

def notion_get_request(url): try: response = requests.get(url, headers=NOTION_REQUEST_HEADERS)

    # Check if the request was successful
    response.raise_for_status()  # Raise an exception for any HTTP error

    # Parse the response JSON
    data = response.json()

    if not data:
        raise ValueError(f"No data found for {url}")

    return data

except requests.exceptions.RequestException as e:
    print(f"Error during GET request: {e}")
    return None

def notion_get_database(db_id): url = f”{NOTION_DATABASE_URL}/{db_id}/query” return notion_post_request(url)

def notion_get_page(page_id): url = f”{NOTION_PAGE_URL}/{page_id}” return notion_get_request(url)

def notion_get_blocks(page_id): url = f”{NOTION_BLOCK_URL}/{page_id}/children”

return notion_get_request(url)

Helper function to extract text from a block’s rich_text

def extract_text_from_block(block): # Check if the block contains rich_text block_type = block.get(‘type’, ”) rich_text_field = None

# Identify the correct field to extract text from
if block_type == 'paragraph':
    rich_text_field = block.get('paragraph', {}).get('rich_text', [])
elif block_type == 'bulleted_list_item':
    rich_text_field = block.get('bulleted_list_item', {}).get('rich_text', [])
elif block_type == 'toggle':
    rich_text_field = block.get('toggle', {}).get('rich_text', [])

# Extract the content from the rich_text field
if rich_text_field:
    text = ''.join([t['text']['content'] for t in rich_text_field if 'text' in t])

    # Decode HTML entities (like " for quotes)
    text = html.unescape(text)
    return text

return ''

ChatGPT

This code defines a set of functions to interact with the Notion API, specifically for making requests to retrieve databases, pages, and blocks, as well as extracting text from rich text blocks.

---

Breakdown of the Code:

1. Making HTTP Requests to Notion API

• The functions use the requests library to send HTTP requests to Notion’s API.
• The NOTION_REQUEST_HEADERS variable (which is assumed to be defined elsewhere) likely contains the necessary authentication headers (e.g., API key).

notion_post_request(url)

• Sends a POST request to the given url (typically used for querying a database in Notion).
• Uses response.raise_for_status() to raise an error if the request fails.
• Parses the response as JSON and returns the resulting data.
• If there’s an error, it prints an error message and returns None.

notion_get_request(url)

• Sends a GET request to retrieve data from the given url.
• Similar to notion_post_request, it raises an exception if the request fails and returns None in case of an error.
• Additionally, it checks if the response contains any data. If not, it raises a ValueError.

---

2. Fetching Specific Notion Data

These functions use the above request functions to interact with specific Notion API endpoints.

notion_get_database(db_id)

• Constructs a URL for querying a Notion database.
• Calls notion_post_request(url) to retrieve the database contents.

notion_get_page(page_id)

• Constructs a URL for retrieving a specific Notion page.
• Calls notion_get_request(url) to fetch the page details.

notion_get_blocks(page_id)

• Constructs a URL to get the child blocks of a page (e.g., paragraphs, lists, toggles).
• Calls notion_get_request(url) to retrieve these blocks.

---

3. Extracting Text from Blocks

extract_text_from_block(block)

• Extracts text content from a Notion block, specifically handling:
  • Paragraphs (paragraph)
  • Bulleted list items (bulleted_list_item)
  • Toggle blocks (toggle)
• Checks if the block contains a rich_text field, then concatenates the text content from all parts of the block.
• Uses html.unescape(text) to decode HTML entities (e.g., " → ").

---

How This Code is Used

1. Fetching a Notion Database:

   db_data = notion_get_database("your_database_id")
   print(db_data)

   • Queries the database and returns the data.

2. Retrieving a Notion Page:

   page_data = notion_get_page("your_page_id")
   print(page_data)

   • Fetches details about a specific page.

3. Getting Blocks (Content) from a Page:

   blocks = notion_get_blocks("your_page_id")
   for block in blocks.get("results", []):
       print(extract_text_from_block(block))

   • Retrieves the child blocks of a page and extracts text from them.

---

Possible Issues & Improvements

• The code assumes that NOTION_REQUEST_HEADERS, NOTION_DATABASE_URL, NOTION_PAGE_URL, and NOTION_BLOCK_URL are correctly defined elsewhere.
• Error Handling could be improved:
  • Instead of print(), logging errors would be better for debugging.
  • Returning more structured error messages rather than just None would help identify issues.
• Expand Supported Block Types: Currently, only paragraph, bulleted_list_item, and toggle blocks are handled. Other types (like headings, numbered lists, etc.) could be added.

Let me know if you need any modifications or explanations! 🚀

You

notion how to get children of a toggle block

ChatGPT

To get the children of a toggle block in Notion using the API, you need to fetch the block’s child elements. Here’s how you can do it:

---

Steps to Get Children of a Toggle Block in Notion API

1. Retrieve the block’s children using the Notion API.
2. Check if the block is a toggle block and fetch its child blocks.

---

1. Fetching Children of a Toggle Block

The Notion API provides an endpoint to get children of any block:

Request

GET https://api.notion.com/v1/blocks/{toggle_block_id}/children

• Replace {toggle_block_id} with the ID of your toggle block.
• Use the appropriate authentication headers.

---

2. Python Code to Fetch Toggle Block Children

Here’s a function to get the children of a toggle block using Python:

import requests

# Notion API Constants (Replace with your values)
NOTION_API_KEY = "your_secret_api_key"
NOTION_VERSION = "2022-06-28"
NOTION_BASE_URL = "https://api.notion.com/v1/blocks"

HEADERS = {
    "Authorization": f"Bearer {NOTION_API_KEY}",
    "Notion-Version": NOTION_VERSION,
    "Content-Type": "application/json"
}

def get_toggle_block_children(toggle_block_id):
    url = f"{NOTION_BASE_URL}/{toggle_block_id}/children"

    try:
        response = requests.get(url, headers=HEADERS)
        response.raise_for_status()  # Raise an error for bad responses
        data = response.json()

        return data.get("results", [])  # Return the child blocks

    except requests.exceptions.RequestException as e:
        print(f"Error fetching children: {e}")
        return None

# Example usage
toggle_block_id = "your_toggle_block_id_here"
children = get_toggle_block_children(toggle_block_id)

# Print child blocks
for child in children:
    print(child)

---

3. Extracting Text from Toggle Block Children

If you want to extract text from the toggle block’s child elements, you can modify the function:

def extract_text_from_toggle_children(toggle_block_id):
    children = get_toggle_block_children(toggle_block_id)

    extracted_texts = []

    for child in children:
        block_type = child.get("type", "")
        rich_text = child.get(block_type, {}).get("rich_text", [])

        # Extract text content
        text_content = "".join([t["text"]["content"] for t in rich_text if "text" in t])
        extracted_texts.append(text_content)

    return extracted_texts

# Example Usage
toggle_block_id = "your_toggle_block_id_here"
toggle_texts = extract_text_from_toggle_children(toggle_block_id)

for text in toggle_texts:
    print(text)

---

Expected API Response Example

If a toggle block has children, the response might look like this:

{
    "object": "list",
    "results": [
        {
            "object": "block",
            "id": "block_1",
            "type": "paragraph",
            "paragraph": {
                "rich_text": [
                    {"type": "text", "text": {"content": "This is inside the toggle!"}}
                ]
            }
        },
        {
            "object": "block",
            "id": "block_2",
            "type": "bulleted_list_item",
            "bulleted_list_item": {
                "rich_text": [
                    {"type": "text", "text": {"content": "Bullet inside toggle"}}
                ]
            }
        }
    ]
}

---

Final Notes

• The API allows you to fetch up to 100 children per request. Use pagination if needed.
• Ensure that the block actually has children; otherwise, it will return an empty list.
• The toggle block ID must be valid and accessible using the API key.

Let me know if you need further modifications! 🚀

You

there is an obvious error here, because the toggle object has no property “children”

Function to process a toggle and its children

def process_toggle_block(block): toggle_heading_text = extract_text_from_block(block) blocks = [f”{toggle_heading_text}”]

# Process child blocks under the toggle
if 'children' in block['toggle']:
    for child_block in block['toggle']['children']:
        print(child_block)
        blocks.extend(process_block(child_block))  # Recurse for child blocks
return blocks

ChatGPT

You’re absolutely right! The toggle block object in the Notion API does not have a children property. Instead, to retrieve its children, you must make an API request to fetch them separately.

---

✅ Corrected Approach

Instead of assuming block['toggle']['children'] exists, we should:

1. Extract the toggle block’s text.
2. Make a separate API call to fetch its children.
3. Process the children recursively.

---

Corrected Python Code

import requests

# Notion API Constants (Replace with your values)
NOTION_API_KEY = "your_secret_api_key"
NOTION_VERSION = "2022-06-28"
NOTION_BASE_URL = "https://api.notion.com/v1/blocks"

HEADERS = {
    "Authorization": f"Bearer {NOTION_API_KEY}",
    "Notion-Version": NOTION_VERSION,
    "Content-Type": "application/json"
}

# Function to extract text from a block
def extract_text_from_block(block):
    block_type = block.get('type', '')
    rich_text_field = block.get(block_type, {}).get('rich_text', [])

    if rich_text_field:
        text = ''.join([t['text']['content'] for t in rich_text_field if 'text' in t])
        return text

    return ''

# Function to fetch children of a block (e.g., a toggle block)
def get_block_children(block_id):
    url = f"{NOTION_BASE_URL}/{block_id}/children"

    try:
        response = requests.get(url, headers=HEADERS)
        response.raise_for_status()
        data = response.json()

        return data.get("results", [])  # Returns a list of child blocks
    except requests.exceptions.RequestException as e:
        print(f"Error fetching children: {e}")
        return []

# Function to process a toggle block and its children
def process_toggle_block(block):
    toggle_heading_text = extract_text_from_block(block)
    blocks = [f"{toggle_heading_text}"]

    # Fetch children of the toggle block from the API
    toggle_block_id = block["id"]
    child_blocks = get_block_children(toggle_block_id)  # API request

    # Process child blocks under the toggle
    for child_block in child_blocks:
        blocks.extend(process_block(child_block))  # Recursive call for children

    return blocks

# Function to process any block (calls process_toggle_block when needed)
def process_block(block):
    block_type = block.get("type", "")

    if block_type == "toggle":
        return process_toggle_block(block)

    return [extract_text_from_block(block)]  # Default: Extract text from block

# Example usage: Assume `toggle_block` is a toggle block from Notion API
toggle_block = {
    "id": "some_toggle_block_id",
    "type": "toggle",
    "toggle": {
        "rich_text": [{"type": "text", "text": {"content": "This is a toggle header"}}]
    }
}

# Process the toggle block and its children
processed_blocks = process_toggle_block(toggle_block)
print(processed_blocks)

---

🚀 How This Fix Works

✅ No more accessing block['toggle']['children'] – instead, we make a separate API request to fetch children.
✅ Handles nested toggles properly – recursively processes child blocks.
✅ Works for all Notion block types – process_block() ensures other blocks are processed properly.

---

🔹 Example Output

If a toggle block has children:

[
    "This is a toggle header",
    "Child block 1 text",
    "Child block 2 text",
    "Nested toggle block text",
    "Nested toggle child text"
]

This correctly fetches the toggle’s text, its child blocks, and processes nested toggles recursively.

---

Let me know if you need further clarifications! 🚀

You

instead of prcessing toggle heading and content as equal lines in a list, actually make a small dictionary where the heading is the key and the contents (all children) are the value

def process_toggle_block(block): toggle_heading_text = extract_text_from_block(block) blocks = [f”{toggle_heading_text}”]

# Fetch children of the toggle block from the API
toggle_block_id = block["id"]
child_blocks = get_block_children(toggle_block_id)  # API request

# Process child blocks under the toggle
for child_block in child_blocks:
    blocks.extend(process_block(child_block))  # Recursive call for children

return blocks

ChatGPT

Got it! Instead of returning a flat list, we’ll structure the toggle block as a dictionary where the toggle heading is the key, and its children are stored as a list of processed blocks.

---

✅ Updated Code

This version ensures that:

• Each toggle heading is a dictionary key.
• The value is a list of processed children blocks.
• Recursively processes nested toggles.

import requests

# Notion API Constants (Replace with your values)
NOTION_API_KEY = "your_secret_api_key"
NOTION_VERSION = "2022-06-28"
NOTION_BASE_URL = "https://api.notion.com/v1/blocks"

HEADERS = {
    "Authorization": f"Bearer {NOTION_API_KEY}",
    "Notion-Version": NOTION_VERSION,
    "Content-Type": "application/json"
}

# Function to extract text from a block
def extract_text_from_block(block):
    block_type = block.get('type', '')
    rich_text_field = block.get(block_type, {}).get('rich_text', [])

    if rich_text_field:
        text = ''.join([t['text']['content'] for t in rich_text_field if 'text' in t])
        return text

    return ''

# Function to fetch children of a block (e.g., a toggle block)
def get_block_children(block_id):
    url = f"{NOTION_BASE_URL}/{block_id}/children"

    try:
        response = requests.get(url, headers=HEADERS)
        response.raise_for_status()
        data = response.json()

        return data.get("results", [])  # Returns a list of child blocks
    except requests.exceptions.RequestException as e:
        print(f"Error fetching children: {e}")
        return []

# Function to process a toggle block and store it in a dictionary
def process_toggle_block(block):
    toggle_heading_text = extract_text_from_block(block)

    # Fetch children of the toggle block from the API
    toggle_block_id = block["id"]
    child_blocks = get_block_children(toggle_block_id)  # API request

    # Process child blocks
    processed_children = [process_block(child_block) for child_block in child_blocks]

    # Return dictionary where the heading is the key, and its children are the values
    return {toggle_heading_text: processed_children}

# Function to process any block (calls process_toggle_block when needed)
def process_block(block):
    block_type = block.get("type", "")

    if block_type == "toggle":
        return process_toggle_block(block)

    return extract_text_from_block(block)  # Default: Extract text from block

# Example usage: Assume `toggle_block` is a toggle block from Notion API
toggle_block = {
    "id": "some_toggle_block_id",
    "type": "toggle",
    "toggle": {
        "rich_text": [{"type": "text", "text": {"content": "This is a toggle header"}}]
    }
}

# Process the toggle block and its children
processed_toggle = process_toggle_block(toggle_block)
print(processed_toggle)

---

🔹 Example Output

If a toggle block contains:

• A paragraph (“Child block 1 text”)
• Another toggle block with its own children

The output will look like:

{
    "This is a toggle header": [
        "Child block 1 text",
        {
            "Nested toggle header": [
                "Nested toggle child text"
            ]
        }
    ]
}

---

🚀 Why This Works Better

✅ Keeps the toggle heading as a dictionary key.
✅ Children are properly grouped under their respective toggles.
✅ Handles nested toggles recursively.
✅ Supports mixed content (paragraphs, lists, other toggles, etc.).

Let me know if you need any refinements! 🚀

You

how to get the boolean value from a property?

ChatGPT

To get a boolean value from a property in a Notion database or page, you need to check how Notion structures its API response.

---

🔹 Retrieving a Boolean Property

In a Notion page or database, boolean properties are stored inside the "properties" object.

Example Notion API Response for a Boolean Property:

{
    "properties": {
        "Completed": {
            "id": "xyz",
            "type": "checkbox",
            "checkbox": true
        }
    }
}

• Here, "Completed" is a checkbox property.
• The actual boolean value is stored in checkbox.

---

✅ Extracting a Boolean Property in Python

def get_boolean_property(page_data, property_name):
    """
    Extracts a boolean property from a Notion page or database entry.

    :param page_data: JSON response from Notion API
    :param property_name: The name of the boolean property to retrieve
    :return: True/False if the property exists, None otherwise
    """
    try:
        return page_data["properties"][property_name]["checkbox"]
    except KeyError:
        print(f"Property '{property_name}' not found.")
        return None

# Example JSON response (simulating Notion API response)
notion_page = {
    "properties": {
        "Completed": {
            "id": "xyz",
            "type": "checkbox",
            "checkbox": True
        }
    }
}

# Extract the boolean value
is_completed = get_boolean_property(notion_page, "Completed")
print(is_completed)  # Output: True

---

🔹 What This Code Does

✅ Checks if the property exists
✅ Extracts the boolean value from checkbox
✅ Handles missing properties safely with KeyError exception

---

🚀 How to Use in a Real API Call

If you are getting a Notion page dynamically, you can use this function like:

# Fetch a Notion page using its ID
page_id = "your_page_id_here"
url = f"https://api.notion.com/v1/pages/{page_id}"
response = requests.get(url, headers=HEADERS)
page_data = response.json()

# Get boolean property
is_done = get_boolean_property(page_data, "Completed")
print(is_done)

This will return True or False depending on the Notion page’s checkbox value.

Let me know if you need any refinements! 🚀

You

for example to get the author data i had this author_data = result[‘properties’].get(‘Author’, {}).get(‘rich_text’, [{}])

now i want to extract a boolean called ‘Clear for RAG’

ChatGPT

To extract a boolean property like “Clear for RAG”, you can follow the same structure you used for extracting text, but instead of accessing "rich_text", you need to access "checkbox".

---

✅ Correct Code for Extracting Boolean Property

clear_for_rag = result['properties'].get('Clear for RAG', {}).get('checkbox', None)

---

🔹 Explanation

• .get('Clear for RAG', {}) → Safely retrieves the dictionary for the property or returns an empty {} if not found.
• .get('checkbox', None) → Retrieves the boolean value (True or False), or None if the checkbox is missing.

---

🔹 Full Example

# Simulated Notion API response
result = {
    "properties": {
        "Author": {
            "rich_text": [{"text": {"content": "John Doe"}}]
        },
        "Clear for RAG": {
            "checkbox": True  # Boolean property
        }
    }
}

# Extracting Author data
author_data = result['properties'].get('Author', {}).get('rich_text', [{}])
author_name = author_data[0].get('text', {}).get('content', '')

# Extracting Boolean property "Clear for RAG"
clear_for_rag = result['properties'].get('Clear for RAG', {}).get('checkbox', None)

print(f"Author: {author_name}")  # Output: Author: John Doe
print(f"Clear for RAG: {clear_for_rag}")  # Output: Clear for RAG: True

---

🔹 Edge Case Handling

If "Clear for RAG" does not exist in properties, clear_for_rag will be None, preventing errors.

Let me know if you need further improvements! 🚀

You

i used this

“name”: result[‘properties’].get(‘Full_Title’, {}).get(‘rich_text’, [{}]),

to get the item title for a notion database element.

however an example of what i get back is this:

“item_name”: [ { “type”: “text”, “text”: { “content”: “Euterpe edulis ”, “link”: null }, “annotations”: { “bold”: true, “italic”: true, “strikethrough”: false, “underline”: false, “code”: false, “color”: “default” }, “plain_text”: “Euterpe edulis ”, “href”: null }, { “type”: “text”, “text”: { “content”: “(Jucara palm)”, “link”: null }, “annotations”: { “bold”: true, “italic”: false, “strikethrough”: false, “underline”: false, “code”: false, “color”: “default” }, “plain_text”: “(Jucara palm)”, “href”: null }, { “type”: “text”, “text”: { “content”: ” - Biomimicry 3.8 Research”, “link”: null }, “annotations”: { “bold”: false, “italic”: false, “strikethrough”: false, “underline”: false, “code”: false, “color”: “default” }, “plain_text”: ” - Biomimicry 3.8 Research”, “href”: null } ],

ChatGPT

You’re currently retrieving the full rich text object for "Full_Title", but what you really want is to extract and concatenate the plain text content from each text block.

---

✅ Corrected Code

To get the actual title as a single string, you can modify your approach as follows:

# Extract the full title as a single string
name = "".join(
    text_block.get("plain_text", "")  # Extract plain text
    for text_block in result['properties'].get('Full_Title', {}).get('rich_text', [])
)

print(name)

---

🔹 Explanation

• .get('Full_Title', {}) → Retrieves the dictionary for the "Full_Title" property safely.
• .get('rich_text', []) → Gets the list of text blocks (or an empty list if missing).
• "".join([...]) → Combines all "plain_text" values into a single string.

---

🔹 Example Output

Given your example, this would return:

Euterpe edulis (Jucara palm) - Biomimicry 3.8 Research

Now you get a clean, readable title from the Notion database without extra metadata.

Let me know if you need refinements! 🚀

You

Ok thanks, nd how can i extract the title and year from this?

{‘object’: ‘page’, ‘id’: ‘19f6716c-a1e8-803d-a550-ddc28a92f3dd’, ‘created_time’: ‘2025-02-19T09:02:00.000Z’, ‘last_edited_time’: ‘2025-02-20T12:10:00.000Z’, ‘created_by’: {‘object’: ‘user’, ‘id’: ‘174d872b-594c-813d-8ee5-000239d1eda2’}, ‘last_edited_by’: {‘object’: ‘user’, ‘id’: ‘174d872b-594c-813d-8ee5-000239d1eda2’}, ‘cover’: None, ‘icon’: None, ‘parent’: {‘type’: ‘database_id’, ‘database_id’: ‘18a6716c-a1e8-80f8-925c-dbe7047b9c2c’}, ‘archived’: False, ‘in_trash’: False, ‘properties’: {‘Clear for RAG’: {‘id’: ‘%3Bhfe’, ‘type’: ‘checkbox’, ‘checkbox’: True}, ‘Site’: {‘id’: ‘AF%60S’, ‘type’: ‘select’, ‘select’: {‘id’: ‘7cf96d97-853e-492c-88b7-7bce6903443d’, ‘name’: ‘Brazil’, ‘color’: ‘green’}}, ‘URL’: {‘id’: ‘A_%3C%5E’, ‘type’: ‘url’, ‘url’: None}, ‘IONIQ_RAG_ITEMS’: {‘id’: ‘Cggt’, ‘type’: ‘relation’, ‘relation’: [{‘id’: ‘19f6716c-a1e8-801a-8535-e4f13d5a915d’}, {‘id’: ‘19f6716c-a1e8-8095-9436-cb37613c362f’}, {‘id’: ‘19f6716c-a1e8-809e-a5db-ec06d7f930bc’}], ‘has_more’: False}, ‘Priority’: {‘id’: ‘EE%7C%3F’, ‘type’: ‘select’, ‘select’: {‘id’: ‘fc6e11e5-790f-4c9b-b7e4-d4f230de91f6’, ‘name’: ‘High’, ‘color’: ‘green’}}, ‘Full_Title’: {‘id’: ‘ESj%3C’, ‘type’: ‘rich_text’, ‘rich_text’: [{‘type’: ‘text’, ‘text’: {‘content’: ‘Euterpe edulis ’, ‘link’: None}, ‘annotations’: {‘bold’: True, ‘italic’: True, ‘strikethrough’: False, ‘underline’: False, ‘code’: False, ‘color’: ‘default’}, ‘plain_text’: ‘Euterpe edulis ’, ‘href’: None}, {‘type’: ‘text’, ‘text’: {‘content’: ‘(Jucara palm)’, ‘link’: None}, ‘annotations’: {‘bold’: True, ‘italic’: False, ‘strikethrough’: False, ‘underline’: False, ‘code’: False, ‘color’: ‘default’}, ‘plain_text’: ‘(Jucara palm)’, ‘href’: None}, {‘type’: ‘text’, ‘text’: {‘content’: ’ - Biomimicry 3.8 Research’, ‘link’: None}, ‘annotations’: {‘bold’: False, ‘italic’: False, ‘strikethrough’: False, ‘underline’: False, ‘code’: False, ‘color’: ‘default’}, ‘plain_text’: ’ - Biomimicry 3.8 Research’, ‘href’: None}]}, ‘Type’: {‘id’: ‘N%5CD%3A’, ‘type’: ‘select’, ‘select’: {‘id’: ‘79bec805-4b98-425b-8a3e-b2ddb0f43af7’, ‘name’: ‘Consultant_Info’, ‘color’: ‘orange’}}, ‘Citation’: {‘id’: ‘Y%3EYT’, ‘type’: ‘rich_text’, ‘rich_text’: []}, ‘Year’: {‘id’: ‘%5B%40EA’, ‘type’: ‘rich_text’, ‘rich_text’: [{‘type’: ‘text’, ‘text’: {‘content’: ‘2025’, ‘link’: None}, ‘annotations’: {‘bold’: False, ‘italic’: False, ‘strikethrough’: False, ‘underline’: False, ‘code’: False, ‘color’: ‘default’}, ‘plain_text’: ‘2025’, ‘href’: None}]}, ‘Author’: {‘id’: ‘fxqS’, ‘type’: ‘rich_text’, ‘rich_text’: [{‘type’: ‘text’, ‘text’: {‘content’: ‘Brittany Jerlinga (Biomimicry 3.8)’, ‘link’: None}, ‘annotations’: {‘bold’: False, ‘italic’: False, ‘strikethrough’: False, ‘underline’: False, ‘code’: False, ‘color’: ‘default’}, ‘plain_text’: ‘Brittany Jerlinga (Biomimicry 3.8)’, ‘href’: None}]}, ‘ID’: {‘id’: ‘rhcL’, ‘type’: ‘unique_id’, ‘unique_id’: {‘prefix’: None, ‘number’: 38}}, ‘License Status ’: {‘id’: ‘t_W_’, ‘type’: ‘relation’, ‘relation’: [], ‘has_more’: False}, ‘License Info’: {‘id’: ‘%7DuO%5D’, ‘type’: ‘rich_text’, ‘rich_text’: [{‘type’: ‘text’, ‘text’: {‘content’: ‘Paid Consultant Research’, ‘link’: None}, ‘annotations’: {‘bold’: False, ‘italic’: False, ‘strikethrough’: False, ‘underline’: False, ‘code’: False, ‘color’: ‘default’}, ‘plain_text’: ‘Paid Consultant Research’, ‘href’: None}]}, ‘Item_Title’: {‘id’: ‘title’, ‘type’: ‘title’, ‘title’: [{‘type’: ‘text’, ‘text’: {‘content’: ‘Euterpe edulis ’, ‘link’: None}, ‘annotations’: {‘bold’: True, ‘italic’: True, ‘strikethrough’: False, ‘underline’: False, ‘code’: False, ‘color’: ‘default’}, ‘plain_text’: ‘Euterpe edulis ’, ‘href’: None}, {‘type’: ‘text’, ‘text’: {‘content’: ‘(Jucara palm)’, ‘link’: None}, ‘annotations’: {‘bold’: True, ‘italic’: False, ‘strikethrough’: False, ‘underline’: False, ‘code’: False, ‘color’: ‘default’}, ‘plain_text’: ‘(Jucara palm)’, ‘href’: None}, {‘type’: ‘text’, ‘text’: {‘content’: ’ - Biomimicry 3.8 Research’, ‘link’: None}, ‘annotations’: {‘bold’: False, ‘italic’: False, ‘strikethrough’: False, ‘underline’: False, ‘code’: False, ‘color’: ‘default’}, ‘plain_text’: ’ - Biomimicry 3.8 Research’, ‘href’: None}]}}, ‘url’: ‘https://www.notion.so/Euterpe-edulis-Jucara-palm-Biomimicry-3-8-Research-19f6716ca1e8803da550ddc28a92f3dd’, ‘public_url’: ‘https://uncharted-limbo.notion.site/Euterpe-edulis-Jucara-palm-Biomimicry-3-8-Research-19f6716ca1e8803da550ddc28a92f3dd’, ‘request_id’: ‘de5f2117-070a-497e-a7e3-0d0308b1b237’}

i am currently doing that

data = notion_get_page(page_id) print(f”NEW ITEM ----------- {data}”) # Extract relevant data from the response (for example, title) page_metadata = { “title”: data[‘properties’].get(‘Full_Title’, {}).get(‘title’, [{}])[0].get(‘text’, {}).get(‘content’,“No Title”), “author”: data[‘properties’].get(‘Author’, {}).get(‘rich_text’, [{}])[0].get(‘text’, {}).get(‘content’, “Unknown Author”), “type”: data[‘properties’].get(‘Type’, {}).get(‘select’, {}).get(‘name’, “Unknown Type”), “year”: data[‘properties’].get(‘Year’, {}).get(‘number’, “Unknown Year”), “url”: data[‘properties’].get(‘URL’, {}).get(‘url’, “No URL”) }

    return page_metadata

and i am getting no Title and unknown Year

ChatGPT

You’re getting "No Title" and "Unknown Year" because there are some incorrect assumptions in how you’re extracting the data. Let’s fix them:

---

🔹 Issues in Your Code

1. Full_Title is rich_text, not title.

   • Your code is using .get('title', [{}]), but the Full_Title field is actually rich_text.
   • You should use .get('rich_text', [{}]).

2. Year is stored as rich_text, not number.

   • Your code is using .get('number', "Unknown Year"), but Year is stored as rich_text, so you need .get('rich_text', [{}]).

---

✅ Corrected Code

# Extract page metadata correctly
page_metadata = {
    # Extract title from 'Item_Title'
    "title": "".join(
        text_block.get("plain_text", "")
        for text_block in data['properties'].get('Item_Title', {}).get('title', [])
    ) or "No Title",

    # Extract author from 'Author'
    "author": "".join(
        text_block.get("plain_text", "")
        for text_block in data['properties'].get('Author', {}).get('rich_text', [])
    ) or "Unknown Author",

    # Extract type from 'Type' (single select)
    "type": data['properties'].get('Type', {}).get('select', {}).get('name', "Unknown Type"),

    # Extract year from 'Year' (rich_text instead of number)
    "year": "".join(
        text_block.get("plain_text", "")
        for text_block in data['properties'].get('Year', {}).get('rich_text', [])
    ) or "Unknown Year",

    # Extract URL
    "url": data['properties'].get('URL', {}).get('url', "No URL")
}

# Return or print the extracted metadata
print(page_metadata)

---

🔹 Explanation of Fixes

✅ Title Extraction (Item_Title)

• "Item_Title" is stored under title, not rich_text.
• Extract all "plain_text" values and concatenate them.

✅ Year Extraction (Year)

• "Year" is a rich_text field, not a number.
• Extract "plain_text" and concatenate.

✅ Author Extraction (Author)

• Extracts "plain_text" from rich_text.

✅ Type Extraction (Type)

• Type is a select field, so the value is under "select" -> "name".

---

🔹 Expected Output

With the provided example, this would return:

{
    "title": "Euterpe edulis (Jucara palm) - Biomimicry 3.8 Research",
    "author": "Brittany Jerlinga (Biomimicry 3.8)",
    "type": "Consultant_Info",
    "year": "2025",
    "url": "No URL"
}

---

🚀 Why This Works Better

✔️ Extracts all plain text properly.
✔️ Handles missing fields gracefully using or defaults.
✔️ Works for multiple text blocks inside rich_text and title fields.

Let me know if you need more improvements! 🚀