import requests,json
#创建页面上的数据库表格
def create_database(base_url,pageID,token):
payload = {
"properties": {
"Name": {
"title":{}
},
"Age": {
"number": {}
},
"Email": {
"rich_text":{}
}
},
"parent": {
"type": "page_id",
"page_id": pageID
}
}
url = base_url + "databases"
headers = {
"Accept": "application/json",
"Notion-Version": "2022-02-22",
"Content-Type": "application/json",
"Authorization": "Bearer %s" %token
}
response = requests.request("POST", url, json=payload, headers=headers)
return response.json()['id'].replace('-','')
#创建数据库表格中的record,但notion官方定义的名字也叫page
def create_page(base_url, databaseID, token):
url = base_url + "pages"
payload = {
"properties": {
"Name": {
"title": [
{
"text": {
"content": "wj"
}
}
]
},
"Age": {
"number": 20
},
"Email": {
"rich_text": [
{
"text": {
"content": "wj@XXX"
}
}
]
}
},
"parent": {
"type": "database_id",
"database_id": databaseID
}
}
headers = {
"Accept": "application/json",
"Notion-Version": "2022-02-22",
"Content-Type": "application/json",
"Authorization": "Bearer %s" % token
}
response = requests.request("POST", url, json=payload, headers=headers)
print(response.text)
if __name__ == '__main__':
base_url = "https://api.notion.com/v1/"
token = "XXXXXXXXXXXXXXXXXXXXXXXXX"
pageID = "9815fe09-cb27-46ee-9417-1d9131b7d53f"
databaseID = create_database(base_url, pageID, token)
create_page(base_url, databaseID, token)版权声明:本文为qq_19757081原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。