Upload to database w/ external source

[thomashirtz]

I am struggling to upload to database from an external source, can someone tell me what I am doing wrong ? (I tried w/ and w/out [])

from notion_client import Client


token = ""
database_id = ""
url = ""

client = Client(auth=token)
client.pages.create(
    parent={'database_id': database_id},
    properties={
        'Title': [{'text': {'content': 'Testing upload'}}],
        "File": [{
            "files": [
                {
                    "type": "external",
                    "name": "pdf",
                    "external": url
                }
            ]
        }]
    },
)

File and Title exist, but it still doesn't work :/

Traceback (most recent call last):
  File "C:\ProgramData\Anaconda3\lib\site-packages\notion_client\client.py", line 115, in _parse_response
    response.raise_for_status()
  File "C:\ProgramData\Anaconda3\lib\site-packages\httpx\_models.py", line 1508, in raise_for_status
    raise HTTPStatusError(message, request=request, response=self)
httpx.HTTPStatusError: Client error '400 Bad Request' for url 'https://api.notion.com/v1/pages'
For more information check: https://httpstatuses.com/400

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "D:/Thomas/GitHub/notion-scholar/excluded/upload.py", line 12, in <module>
    client.pages.create(
  File "C:\ProgramData\Anaconda3\lib\site-packages\notion_client\api_endpoints.py", line 202, in create
    return self.parent.request(
  File "C:\ProgramData\Anaconda3\lib\site-packages\notion_client\client.py", line 187, in request
    return self._parse_response(response)
  File "C:\ProgramData\Anaconda3\lib\site-packages\notion_client\client.py", line 122, in _parse_response
    raise APIResponseError(response, body["message"], code)
notion_client.errors.APIResponseError: body failed validation. Fix one: body.properties.File[0].text should be defined, instead was `undefined`. body.properties.File[0].mention should be defined, instead was `undefined`. body.properties.File[0].equation should be defined, instead was `undefined`. body.properties.File[0].id should be defined, instead was `undefined`. body.properties.File[0].name should be defined, instead was `undefined`. body.properties.File[0].person should be defined, instead was `undefined`. body.properties.File[0].bot should be defined, instead was `undefined`. body.properties.File[0].file should be defined, instead was `undefined`. body.properties.File[0].external should be defined, instead was `undefined`.

Process finished with exit code 1

I got what to put for File here https://www.reddit.com/r/Notion/comments/sm1av3/upload_to_notion_using_external_url/hvzyxrm/?context=3

If I do that:

    client = Client(auth=token)
    client.pages.create(
        parent={'database_id': database_id},
        properties={
            'Title': [{'text': {'content': 'Testing upload'}}],
        }
    )

It works just fine

[thomashirtz]

(Discussion can be deleted as I created an issue)

[ramnes]

The discussion seemed more appropriate as it's most likely a problem with Notion's API, not the client. I didn't answer so far because I didn't investigate yet and so I can't give you any hint. But again, that doesn't sound like a client problem. Did you try with cURL or similar?

[thomashirtz]

I tried with bare request:

import requests


url = "https://api.notion.com/v1/pages"
database_id = ""
secret = ""


payload = {
    "properties": {
        "File": {
            "files": [
                {
                    "type": "external",
                    "name": "Space Wallpaper",
                    "external": "https://website.domain/images/space.png"
                }

            ]
        }
    },
    "parent": {
        "type": "database_id",
        "database_id": database_id
    }
}

headers = {
    "Accept": "application/json",
    "Notion-Version": "2021-08-16",
    "Content-Type": "application/json",
    "Authorization": f"Bearer {secret}"

}


if __name__ == '__main__':
    response = requests.request("POST", url, json=payload, headers=headers)
    print(response.text)

(File exists in my database)

Using the examples from the website, but since I didn't see anyone complain on internet I thought I may just have done it incorrectly
It would be nice to have one example on notion-sdk-api that shows how to format each property/block once to see if it comes from the api or not when problem arise

Did you ever managed to upload ?

Links: https://notion-group.readmepreview.com/reference/post-page and https://developers.notion.com/reference/property-value-object#files-property-values

[thomashirtz]

import requests


url = "https://api.notion.com/v1/pages"
secret = ""
database_id = ""



payload = {
    "properties": {
        "File": {
            "files": [
                {
                    "type": "external",
                    "name": "Space Wallpaper",
                    "external": {"url": "https://website.domain/images/space.png"}
                }

            ]
        }
    },
    "parent": {
        "type": "database_id",
        "database_id": database_id
    }
}

headers = {
    "Accept": "application/json",
    "Notion-Version": "2021-08-16",
    "Content-Type": "application/json",
    "Authorization": f"Bearer {secret}"

}


if __name__ == '__main__':
    response = requests.request("POST", url, json=payload, headers=headers)
    print(response.text)

This is a working payload w/ the API, however it doesn't seem to work with notion-sdk-py