rest-notion-db
A RESTful way to use your Notion tables as a database.
Use-cases
Form submissions or frontend websites, use one database that is understood by everyone at your workplace for all your needs.
Usage
In order to use the API, you need to provide your Notion token_v2 cookie and the Notion database page URL. You can obtain your token_v2 using Chrome DevTools or the like for other browsers.
GET data
Endpoint: /page/
The PAGE_ID includes the ID of the page along with the default ?v URL parameter.
Simply replace the notion.so to rest-notion-db.herokuapp.com on your database page to access the table data as a JSON response.
In case of an auth-secured page, send your token_v2 cookie as a Authorization Bearer Token header in the request.
Queries
Currently, you can sort and limit the data using request parameters.
For example:
?name=asc: sorts all the names in alphabetical order as per the default Notion intent.
?limit=5: limits the number of results in the response to 5.
You can add multiple query parameters to sort the data as per your use-cases.
Demo
Database: User Research Template
Request: https://rest-notion-db.herokuapp.com/page/1d595a4c3f9a4254b332587507e87267?v=43045489a1a44683b04154a85a562898&name=desc&limit=2
Response:
[{
"completion_time": 20,
"email": "",
"name": "Kyle Miller",
"rsvp": true,
"status": "Cancelled",
"task": ["Profile Editing"],
"title": "Kyle Miller"
}, {
"completion_time": 30,
"email": "",
"name": "Emily Cohen",
"rsvp": false,
"status": "Contacted",
"task": ["Offline Mode", "Profile Editing"],
"title": "Emily Cohen"
}]
POST data
Endpoint: /post
Send the Notion Page URL and the token_v2 cookie, in case of a private page, as request headers along with the JSON POST data.
In order to successfully POST, the request data keys should match the schema names and the values should match the schema datatypes.
Demo
Database: User Research Template
Request:
Headers
{
"Authorization": "Bearer " ,
"Notion-Page-Url": "" ,
"Content-Type": "application/json"
}
Body
{
"name": "Ivan Zhao",
"task": ["Offline Mode", "Profile Editing"],
"status": "Scheduled",
"completion_time": 42,
"rsvp": true
}
Response:
{
"message": "Added data to table successfully.",
"success": true
}
Credits
notion-py for the unofficial Notion client wrapper.
Problems?
File an issue or contact me.
75 Dec 4, 2022
248 Dec 26, 2022
311 Dec 24, 2022
40 Jan 3, 2023
19 Sep 12, 2022
6 Mar 31, 2022
22 Dec 26, 2022
1.9k Jan 7, 2023
78 Dec 19, 2022
30 Sep 23, 2022
214 Jan 7, 2023
3 Feb 15, 2022
209 Jan 5, 2023
1 Feb 9, 2022
141 Jan 6, 2023
0 Aug 9, 2022
3.9k Jan 3, 2023
10 Jul 9, 2022
525 Jan 1, 2023
4 Feb 19, 2022
5 Dec 20, 2021
142 Jan 6, 2023
2.4k Dec 24, 2022
19 Aug 30, 2022
4k Dec 31, 2022
332 Dec 17, 2022
50 Dec 30, 2022
57 Dec 29, 2022