S11. プロパティ要素

11.1 プロパティ要素の分類

• データベースを取得したときの JSON オブジェクト(Property object)
Start building with the Notion API
Metadata that controls how a database property behaves. Each database property object contains the following keys. In addition, it must contain a key corresponding with the value of type. The value is an object containing type-specific configuration. The type-specific configurations are described in the sections below.

https://developers.notion.com/reference/property-object

• ページを取得したときの JSON オブジェクト(Property item object)
Start building with the Notion API
A property_item object describes the identifier, type, and value of a page property. It's returned from the Retrieve a page property item Each page property item object contains the following keys. In addition, it will contain a key corresponding with the value of type. The value is an object containing type-specific data.

https://developers.notion.com/reference/property-item-object

• データベースを設定するときの JSON オブジェクト (Property schema object)
Start building with the Notion API
Metadata that controls how a database property behaves. Each database property schema object has at least one key which is the property type. This type contains behavior of this property. Possible values of this key are "title", "rich_text", "number", "select", "multi_select", "date", "people", "files", "checkbox", "url", "email", "phone_number", "formula", "relation", "rollup", "created_time", "created_by", "last_edited_time", "last_edited_by".

https://developers.notion.com/reference/property-schema-object

• ページを追加・更新する時の JSON オブジェクト (Property value object)
Start building with the Notion API
A property value defines the identifier, type, and value of a page property in a page object. It's used when retrieving and updating pages, ex: Create and Update pages. Property values in the page object have a 25 page reference limit Any property value that has uses other pages in its value will only use the first 25 page references.

https://developers.notion.com/reference/property-value-object

• データベースを検索するための JSON オブジェクト (Property filter object)
Start building with the Notion API
A filter is a single condition used to specify and limit the entries returned from a database query. Database queries can be filtered by page property values. The API supports filtering by the following property types: rich_text, phone_number, number, checkbox, select, multi-select, date, people, fi...

https://developers.notion.com/reference/post-database-query-filter

11.2 Property object / Property schema object

11.2.1 設定値がないプロパティ

11.2.2 関数 (formula)

11.2.3 セレクト (select) / マルチセレクト (multi_select)

11.2.4 数値 (number)

11.2.5 リレーション (relation)

11.2.6 ロールアップ (rollup)

11.3 Property item object / Property value object

11.3.1 作成者 (created_by) /最終更新者 (last_edited_by)

11.3.2 作成日時 (created_time) /最終更新日時 (last_edited_time)

11.3.3 関数 (formula)

11.3.4 ロールアップ (rollup)

11.3.5 チェックボックス (checkbox)

11.3.6 日付 (date)

11.3.7 メール (email)

11.3.8 ファイル & メディア (files)

11.3.9 マルチセレクト (multi_select)

11.3.10 数値 (number)

11.3.11 ユーザー (people)

11.3.12 電話 (phone_number)

11.3.13 リレーション (relation)

11.3.14 テキスト (rich_text)

11.3.15 セレクト (select)

11.3.16 タイトル (title)

11.3.17 URL (url)

11.4 Filter object

Start building with the Notion API

A filter is a single condition used to specify and limit the entries returned from a database query. Database queries can be filtered by page property values. The API supports filtering by the following property types: rich_text, phone_number, number, checkbox, select, multi-select, date, people, fi...

https://developers.notion.com/reference/post-database-query-filter

11.4.1 存在・非存在条件

11.4.2 一致・不一致条件

11.4.3 包含・非包含条件

11.4.4 開始・終了条件

11.4.5 数値の大小条件

11.4.5 日付の前後条件

11.4.6 関数(formula)に対する条件

11.4.7 ロールアップ(rollup)に対する条件