Uses JSON.parse to evaluate the argument.
Consider a database with 3 columns: Name (a title type), Age (a number type) and Occupation (a text type). An example input would look like this:
{
"Name": "My Name",
"Age": 10,
"Occupation": "Astronaut"
}
Other supported types:
Status e.g. "MyStatus": "MyOption"
Checkbox e.g "MyCheckbox": true
User
Query Database with Filter and Sorts and Item Count
i
Uses JSON.parse to evaluate the filter and sorts argument.
The JSON format for the filter configuration looks like this:
{
"and": [
{
"property": "Done",
"checkbox": {
"equals": true
}
},
{
"or": [
{
"property": "Tags",
"contains": "A"
},
{
"property": "Tags",
"contains": "B"
}
]
}
]
}
For all possible filter options see the https://developers.notion.com/reference/post-database-query-filter
For sorting see https://developers.notion.com/reference/post-database-query-sort.
Advanced
User
Retrieve Database
i
Retrieves a database object that describes the structure and columns of a database