/** * Notion Node - Version 2.1 * Discriminator: resource=databasePage, operation=getAll */ interface Credentials { notionApi: CredentialReference; } /** Get many child blocks */ export type NotionV21DatabasePageGetAllParams = { resource: 'databasePage'; operation: 'getAll'; /** * The Notion Database to operate on * @default {"mode":"list","value":""} */ databaseId?: { __rl: true; mode: 'list' | 'url' | 'id'; value: string; cachedResultName?: string }; /** * Whether to return all results or only up to a given limit * @default false */ returnAll?: boolean | Expression; /** * Max number of results to return * @displayOptions.show { returnAll: [false] } * @default 50 */ limit?: number | Expression; /** * Whether to return a simplified version of the response instead of the raw data * @default true */ simple?: boolean | Expression; /** * Filter * @default none */ filterType?: 'none' | 'manual' | 'json' | Expression; /** * Must Match * @displayOptions.show { filterType: ["manual"] } * @default anyFilter */ matchType?: 'anyFilter' | 'allFilters' | Expression; /** * Filters * @displayOptions.show { filterType: ["manual"] } * @default {} */ filters?: { /** Conditions */ conditions?: Array<{ /** The name of the property to filter by. Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a>. */ key?: string | Expression; /** Type * @default ={{$parameter["&key"].split("|")[1]}} */ type?: unknown; /** The value of the property to filter by * @displayOptions.show { type: ["title"] } */ condition?: 'equals' | 'does_not_equal' | 'contains' | 'does_not_contain' | 'starts_with' | 'ends_with' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["rich_text"] } */ condition?: 'equals' | 'does_not_equal' | 'contains' | 'does_not_contain' | 'starts_with' | 'ends_with' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["number"] } */ condition?: 'equals' | 'does_not_equal' | 'greater_than' | 'less_than' | 'greater_than_or_equal_to' | 'less_than_or_equal_to' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["checkbox"] } */ condition?: 'equals' | 'does_not_equal' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["select"] } */ condition?: 'equals' | 'does_not_equal' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["multi_select"] } */ condition?: 'contains' | 'does_not_equal' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["status"] } */ condition?: 'equals' | 'does_not_equal' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["date"] } */ condition?: 'equals' | 'before' | 'after' | 'on_or_before' | 'is_empty' | 'is_not_empty' | 'on_or_after' | 'past_week' | 'past_month' | 'past_year' | 'next_week' | 'next_month' | 'next_year' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["people"] } */ condition?: 'contains' | 'does_not_contain' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["files"] } */ condition?: 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["url"] } */ condition?: 'equals' | 'does_not_equal' | 'contains' | 'does_not_contain' | 'starts_with' | 'ends_with' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["email"] } */ condition?: 'equals' | 'does_not_equal' | 'contains' | 'does_not_contain' | 'starts_with' | 'ends_with' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["phone_number"] } */ condition?: 'equals' | 'does_not_equal' | 'contains' | 'does_not_contain' | 'starts_with' | 'ends_with' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["relation"] } */ condition?: 'contains' | 'does_not_contain' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["created_by"] } */ condition?: 'contains' | 'does_not_contain' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["created_time"] } */ condition?: 'equals' | 'before' | 'after' | 'on_or_before' | 'is_empty' | 'is_not_empty' | 'on_or_after' | 'past_week' | 'past_month' | 'past_year' | 'next_week' | 'next_month' | 'next_year' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["last_edited_by"] } */ condition?: 'contains' | 'does_not_contain' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["last_edited_time"] } */ condition?: 'equals' | 'before' | 'after' | 'on_or_before' | 'is_empty' | 'is_not_empty' | 'on_or_after' | 'past_week' | 'past_month' | 'past_year' | 'next_week' | 'next_month' | 'next_year' | Expression; /** The formula return type * @displayOptions.show { type: ["formula"] } */ returnType?: 'text' | 'checkbox' | 'number' | 'date' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["formula"], returnType: ["text"] } */ condition?: 'equals' | 'does_not_equal' | 'contains' | 'does_not_contain' | 'starts_with' | 'ends_with' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["formula"], returnType: ["checkbox"] } */ condition?: 'equals' | 'does_not_equal' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["formula"], returnType: ["number"] } */ condition?: 'equals' | 'does_not_equal' | 'greater_than' | 'less_than' | 'greater_than_or_equal_to' | 'less_than_or_equal_to' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["formula"], returnType: ["date"] } */ condition?: 'equals' | 'before' | 'after' | 'on_or_before' | 'is_empty' | 'is_not_empty' | 'on_or_after' | 'past_week' | 'past_month' | 'past_year' | 'next_week' | 'next_month' | 'next_year' | Expression; /** Title * @displayOptions.show { type: ["title"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ titleValue?: string | Expression | PlaceholderValue; /** Text * @displayOptions.show { type: ["rich_text"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ richTextValue?: string | Expression | PlaceholderValue; /** Phone number. No structure is enforced. * @displayOptions.show { type: ["phone_number"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ phoneNumberValue?: string | Expression | PlaceholderValue; /** Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a> * @displayOptions.show { type: ["multi_select"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } * @default [] */ multiSelectValue?: string | Expression; /** Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a> * @displayOptions.show { type: ["select"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ selectValue?: string | Expression; /** Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a> * @displayOptions.show { type: ["status"] } */ statusValue?: string | Expression; /** Email * @displayOptions.show { type: ["email"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ emailValue?: string | Expression | PlaceholderValue; /** URL * @displayOptions.show { type: ["url"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ urlValue?: string | Expression | PlaceholderValue; /** List of users. Multiples can be defined separated by comma. Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a>. * @displayOptions.show { type: ["people"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ peopleValue?: string | Expression; /** List of users. Multiples can be defined separated by comma. Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a>. * @displayOptions.show { type: ["created_by"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ createdByValue?: string | Expression; /** List of users. Multiples can be defined separated by comma. Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a>. * @displayOptions.show { type: ["last_edited_by"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ lastEditedByValue?: string | Expression; /** Relation ID * @displayOptions.show { type: ["relation"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ relationValue?: string | Expression | PlaceholderValue; /** Whether or not the checkbox is checked. <code>true</code> represents checked. <code>false</code> represents unchecked * @displayOptions.show { type: ["checkbox"] } * @default false */ checkboxValue?: boolean | Expression; /** Number value * @displayOptions.show { type: ["number"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } * @default 0 */ numberValue?: number | Expression; /** An ISO 8601 format date, with optional time * @displayOptions.show { type: ["date"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty", "past_week", "past_month", "past_year", "next_week", "next_month", "next_year"] } */ date?: string | Expression; /** An ISO 8601 format date, with optional time * @displayOptions.show { type: ["created_time"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty", "past_week", "past_month", "past_year", "next_week", "next_month", "next_year"] } */ createdTimeValue?: string | Expression; /** An ISO 8601 format date, with optional time * @displayOptions.show { type: ["last_edited_time"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty", "past_week", "past_month", "past_year", "next_week", "next_month", "next_year"] } */ lastEditedTime?: string | Expression; /** Number value * @displayOptions.show { type: ["formula"], returnType: ["number"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } * @default 0 */ numberValue?: number | Expression; /** Text * @displayOptions.show { type: ["formula"], returnType: ["text"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ textValue?: string | Expression | PlaceholderValue; /** Whether or not the checkbox is checked. <code>true</code> represents checked. <code>false</code> represents unchecked * @displayOptions.show { type: ["formula"], returnType: ["checkbox"] } * @default false */ checkboxValue?: boolean | Expression; /** An ISO 8601 format date, with optional time * @displayOptions.show { type: ["formula"], returnType: ["date"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty", "past_week", "past_month", "past_year", "next_week", "next_month", "next_year"] } */ dateValue?: string | Expression; }>; }; /** * Filters (JSON) * @displayOptions.show { filterType: ["json"] } */ filterJson?: string | Expression | PlaceholderValue; /** * Options * @default {} */ options?: { /** Whether to download a file if a database's field contains it * @default false */ downloadFiles?: boolean | Expression; /** Filters * @default {} */ filter?: { /** Single Condition */ singleCondition?: { /** The name of the property to filter by. Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a>. */ key?: string | Expression; /** Type * @default ={{$parameter["&key"].split("|")[1]}} */ type?: unknown; /** The value of the property to filter by * @displayOptions.show { type: ["title"] } */ condition?: 'equals' | 'does_not_equal' | 'contains' | 'does_not_contain' | 'starts_with' | 'ends_with' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["rich_text"] } */ condition?: 'equals' | 'does_not_equal' | 'contains' | 'does_not_contain' | 'starts_with' | 'ends_with' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["number"] } */ condition?: 'equals' | 'does_not_equal' | 'greater_than' | 'less_than' | 'greater_than_or_equal_to' | 'less_than_or_equal_to' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["checkbox"] } */ condition?: 'equals' | 'does_not_equal' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["select"] } */ condition?: 'equals' | 'does_not_equal' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["multi_select"] } */ condition?: 'contains' | 'does_not_equal' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["status"] } */ condition?: 'equals' | 'does_not_equal' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["date"] } */ condition?: 'equals' | 'before' | 'after' | 'on_or_before' | 'is_empty' | 'is_not_empty' | 'on_or_after' | 'past_week' | 'past_month' | 'past_year' | 'next_week' | 'next_month' | 'next_year' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["people"] } */ condition?: 'contains' | 'does_not_contain' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["files"] } */ condition?: 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["url"] } */ condition?: 'equals' | 'does_not_equal' | 'contains' | 'does_not_contain' | 'starts_with' | 'ends_with' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["email"] } */ condition?: 'equals' | 'does_not_equal' | 'contains' | 'does_not_contain' | 'starts_with' | 'ends_with' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["phone_number"] } */ condition?: 'equals' | 'does_not_equal' | 'contains' | 'does_not_contain' | 'starts_with' | 'ends_with' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["relation"] } */ condition?: 'contains' | 'does_not_contain' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["created_by"] } */ condition?: 'contains' | 'does_not_contain' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["created_time"] } */ condition?: 'equals' | 'before' | 'after' | 'on_or_before' | 'is_empty' | 'is_not_empty' | 'on_or_after' | 'past_week' | 'past_month' | 'past_year' | 'next_week' | 'next_month' | 'next_year' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["last_edited_by"] } */ condition?: 'contains' | 'does_not_contain' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["last_edited_time"] } */ condition?: 'equals' | 'before' | 'after' | 'on_or_before' | 'is_empty' | 'is_not_empty' | 'on_or_after' | 'past_week' | 'past_month' | 'past_year' | 'next_week' | 'next_month' | 'next_year' | Expression; /** The formula return type * @displayOptions.show { type: ["formula"] } */ returnType?: 'text' | 'checkbox' | 'number' | 'date' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["formula"], returnType: ["text"] } */ condition?: 'equals' | 'does_not_equal' | 'contains' | 'does_not_contain' | 'starts_with' | 'ends_with' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["formula"], returnType: ["checkbox"] } */ condition?: 'equals' | 'does_not_equal' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["formula"], returnType: ["number"] } */ condition?: 'equals' | 'does_not_equal' | 'greater_than' | 'less_than' | 'greater_than_or_equal_to' | 'less_than_or_equal_to' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["formula"], returnType: ["date"] } */ condition?: 'equals' | 'before' | 'after' | 'on_or_before' | 'is_empty' | 'is_not_empty' | 'on_or_after' | 'past_week' | 'past_month' | 'past_year' | 'next_week' | 'next_month' | 'next_year' | Expression; /** Title * @displayOptions.show { type: ["title"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ titleValue?: string | Expression | PlaceholderValue; /** Text * @displayOptions.show { type: ["rich_text"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ richTextValue?: string | Expression | PlaceholderValue; /** Phone number. No structure is enforced. * @displayOptions.show { type: ["phone_number"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ phoneNumberValue?: string | Expression | PlaceholderValue; /** Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a> * @displayOptions.show { type: ["multi_select"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } * @default [] */ multiSelectValue?: string | Expression; /** Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a> * @displayOptions.show { type: ["select"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ selectValue?: string | Expression; /** Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a> * @displayOptions.show { type: ["status"] } */ statusValue?: string | Expression; /** Email * @displayOptions.show { type: ["email"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ emailValue?: string | Expression | PlaceholderValue; /** URL * @displayOptions.show { type: ["url"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ urlValue?: string | Expression | PlaceholderValue; /** List of users. Multiples can be defined separated by comma. Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a>. * @displayOptions.show { type: ["people"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ peopleValue?: string | Expression; /** List of users. Multiples can be defined separated by comma. Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a>. * @displayOptions.show { type: ["created_by"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ createdByValue?: string | Expression; /** List of users. Multiples can be defined separated by comma. Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a>. * @displayOptions.show { type: ["last_edited_by"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ lastEditedByValue?: string | Expression; /** Relation ID * @displayOptions.show { type: ["relation"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ relationValue?: string | Expression | PlaceholderValue; /** Whether or not the checkbox is checked. <code>true</code> represents checked. <code>false</code> represents unchecked * @displayOptions.show { type: ["checkbox"] } * @default false */ checkboxValue?: boolean | Expression; /** Number value * @displayOptions.show { type: ["number"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } * @default 0 */ numberValue?: number | Expression; /** An ISO 8601 format date, with optional time * @displayOptions.show { type: ["date"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty", "past_week", "past_month", "past_year", "next_week", "next_month", "next_year"] } */ date?: string | Expression; /** An ISO 8601 format date, with optional time * @displayOptions.show { type: ["created_time"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty", "past_week", "past_month", "past_year", "next_week", "next_month", "next_year"] } */ createdTimeValue?: string | Expression; /** An ISO 8601 format date, with optional time * @displayOptions.show { type: ["last_edited_time"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty", "past_week", "past_month", "past_year", "next_week", "next_month", "next_year"] } */ lastEditedTime?: string | Expression; /** Number value * @displayOptions.show { type: ["formula"], returnType: ["number"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } * @default 0 */ numberValue?: number | Expression; /** Text * @displayOptions.show { type: ["formula"], returnType: ["text"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ textValue?: string | Expression | PlaceholderValue; /** Whether or not the checkbox is checked. <code>true</code> represents checked. <code>false</code> represents unchecked * @displayOptions.show { type: ["formula"], returnType: ["checkbox"] } * @default false */ checkboxValue?: boolean | Expression; /** An ISO 8601 format date, with optional time * @displayOptions.show { type: ["formula"], returnType: ["date"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty", "past_week", "past_month", "past_year", "next_week", "next_month", "next_year"] } */ dateValue?: string | Expression; }; /** Multiple Condition */ multipleCondition?: { /** Condition * @default {} */ condition?: { /** OR */ or?: Array<{ /** The name of the property to filter by. Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a>. */ key?: string | Expression; /** Type * @default ={{$parameter["&key"].split("|")[1]}} */ type?: unknown; /** The value of the property to filter by * @displayOptions.show { type: ["title"] } */ condition?: 'equals' | 'does_not_equal' | 'contains' | 'does_not_contain' | 'starts_with' | 'ends_with' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["rich_text"] } */ condition?: 'equals' | 'does_not_equal' | 'contains' | 'does_not_contain' | 'starts_with' | 'ends_with' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["number"] } */ condition?: 'equals' | 'does_not_equal' | 'greater_than' | 'less_than' | 'greater_than_or_equal_to' | 'less_than_or_equal_to' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["checkbox"] } */ condition?: 'equals' | 'does_not_equal' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["select"] } */ condition?: 'equals' | 'does_not_equal' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["multi_select"] } */ condition?: 'contains' | 'does_not_equal' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["status"] } */ condition?: 'equals' | 'does_not_equal' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["date"] } */ condition?: 'equals' | 'before' | 'after' | 'on_or_before' | 'is_empty' | 'is_not_empty' | 'on_or_after' | 'past_week' | 'past_month' | 'past_year' | 'next_week' | 'next_month' | 'next_year' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["people"] } */ condition?: 'contains' | 'does_not_contain' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["files"] } */ condition?: 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["url"] } */ condition?: 'equals' | 'does_not_equal' | 'contains' | 'does_not_contain' | 'starts_with' | 'ends_with' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["email"] } */ condition?: 'equals' | 'does_not_equal' | 'contains' | 'does_not_contain' | 'starts_with' | 'ends_with' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["phone_number"] } */ condition?: 'equals' | 'does_not_equal' | 'contains' | 'does_not_contain' | 'starts_with' | 'ends_with' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["relation"] } */ condition?: 'contains' | 'does_not_contain' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["created_by"] } */ condition?: 'contains' | 'does_not_contain' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["created_time"] } */ condition?: 'equals' | 'before' | 'after' | 'on_or_before' | 'is_empty' | 'is_not_empty' | 'on_or_after' | 'past_week' | 'past_month' | 'past_year' | 'next_week' | 'next_month' | 'next_year' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["last_edited_by"] } */ condition?: 'contains' | 'does_not_contain' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["last_edited_time"] } */ condition?: 'equals' | 'before' | 'after' | 'on_or_before' | 'is_empty' | 'is_not_empty' | 'on_or_after' | 'past_week' | 'past_month' | 'past_year' | 'next_week' | 'next_month' | 'next_year' | Expression; /** The formula return type * @displayOptions.show { type: ["formula"] } */ returnType?: 'text' | 'checkbox' | 'number' | 'date' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["formula"], returnType: ["text"] } */ condition?: 'equals' | 'does_not_equal' | 'contains' | 'does_not_contain' | 'starts_with' | 'ends_with' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["formula"], returnType: ["checkbox"] } */ condition?: 'equals' | 'does_not_equal' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["formula"], returnType: ["number"] } */ condition?: 'equals' | 'does_not_equal' | 'greater_than' | 'less_than' | 'greater_than_or_equal_to' | 'less_than_or_equal_to' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["formula"], returnType: ["date"] } */ condition?: 'equals' | 'before' | 'after' | 'on_or_before' | 'is_empty' | 'is_not_empty' | 'on_or_after' | 'past_week' | 'past_month' | 'past_year' | 'next_week' | 'next_month' | 'next_year' | Expression; /** Title * @displayOptions.show { type: ["title"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ titleValue?: string | Expression | PlaceholderValue; /** Text * @displayOptions.show { type: ["rich_text"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ richTextValue?: string | Expression | PlaceholderValue; /** Phone number. No structure is enforced. * @displayOptions.show { type: ["phone_number"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ phoneNumberValue?: string | Expression | PlaceholderValue; /** Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a> * @displayOptions.show { type: ["multi_select"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } * @default [] */ multiSelectValue?: string | Expression; /** Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a> * @displayOptions.show { type: ["select"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ selectValue?: string | Expression; /** Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a> * @displayOptions.show { type: ["status"] } */ statusValue?: string | Expression; /** Email * @displayOptions.show { type: ["email"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ emailValue?: string | Expression | PlaceholderValue; /** URL * @displayOptions.show { type: ["url"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ urlValue?: string | Expression | PlaceholderValue; /** List of users. Multiples can be defined separated by comma. Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a>. * @displayOptions.show { type: ["people"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ peopleValue?: string | Expression; /** List of users. Multiples can be defined separated by comma. Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a>. * @displayOptions.show { type: ["created_by"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ createdByValue?: string | Expression; /** List of users. Multiples can be defined separated by comma. Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a>. * @displayOptions.show { type: ["last_edited_by"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ lastEditedByValue?: string | Expression; /** Relation ID * @displayOptions.show { type: ["relation"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ relationValue?: string | Expression | PlaceholderValue; /** Whether or not the checkbox is checked. <code>true</code> represents checked. <code>false</code> represents unchecked * @displayOptions.show { type: ["checkbox"] } * @default false */ checkboxValue?: boolean | Expression; /** Number value * @displayOptions.show { type: ["number"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } * @default 0 */ numberValue?: number | Expression; /** An ISO 8601 format date, with optional time * @displayOptions.show { type: ["date"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty", "past_week", "past_month", "past_year", "next_week", "next_month", "next_year"] } */ date?: string | Expression; /** An ISO 8601 format date, with optional time * @displayOptions.show { type: ["created_time"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty", "past_week", "past_month", "past_year", "next_week", "next_month", "next_year"] } */ createdTimeValue?: string | Expression; /** An ISO 8601 format date, with optional time * @displayOptions.show { type: ["last_edited_time"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty", "past_week", "past_month", "past_year", "next_week", "next_month", "next_year"] } */ lastEditedTime?: string | Expression; /** Number value * @displayOptions.show { type: ["formula"], returnType: ["number"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } * @default 0 */ numberValue?: number | Expression; /** Text * @displayOptions.show { type: ["formula"], returnType: ["text"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ textValue?: string | Expression | PlaceholderValue; /** Whether or not the checkbox is checked. <code>true</code> represents checked. <code>false</code> represents unchecked * @displayOptions.show { type: ["formula"], returnType: ["checkbox"] } * @default false */ checkboxValue?: boolean | Expression; /** An ISO 8601 format date, with optional time * @displayOptions.show { type: ["formula"], returnType: ["date"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty", "past_week", "past_month", "past_year", "next_week", "next_month", "next_year"] } */ dateValue?: string | Expression; }>; /** AND */ and?: Array<{ /** The name of the property to filter by. Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a>. */ key?: string | Expression; /** Type * @default ={{$parameter["&key"].split("|")[1]}} */ type?: unknown; /** The value of the property to filter by * @displayOptions.show { type: ["title"] } */ condition?: 'equals' | 'does_not_equal' | 'contains' | 'does_not_contain' | 'starts_with' | 'ends_with' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["rich_text"] } */ condition?: 'equals' | 'does_not_equal' | 'contains' | 'does_not_contain' | 'starts_with' | 'ends_with' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["number"] } */ condition?: 'equals' | 'does_not_equal' | 'greater_than' | 'less_than' | 'greater_than_or_equal_to' | 'less_than_or_equal_to' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["checkbox"] } */ condition?: 'equals' | 'does_not_equal' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["select"] } */ condition?: 'equals' | 'does_not_equal' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["multi_select"] } */ condition?: 'contains' | 'does_not_equal' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["status"] } */ condition?: 'equals' | 'does_not_equal' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["date"] } */ condition?: 'equals' | 'before' | 'after' | 'on_or_before' | 'is_empty' | 'is_not_empty' | 'on_or_after' | 'past_week' | 'past_month' | 'past_year' | 'next_week' | 'next_month' | 'next_year' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["people"] } */ condition?: 'contains' | 'does_not_contain' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["files"] } */ condition?: 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["url"] } */ condition?: 'equals' | 'does_not_equal' | 'contains' | 'does_not_contain' | 'starts_with' | 'ends_with' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["email"] } */ condition?: 'equals' | 'does_not_equal' | 'contains' | 'does_not_contain' | 'starts_with' | 'ends_with' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["phone_number"] } */ condition?: 'equals' | 'does_not_equal' | 'contains' | 'does_not_contain' | 'starts_with' | 'ends_with' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["relation"] } */ condition?: 'contains' | 'does_not_contain' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["created_by"] } */ condition?: 'contains' | 'does_not_contain' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["created_time"] } */ condition?: 'equals' | 'before' | 'after' | 'on_or_before' | 'is_empty' | 'is_not_empty' | 'on_or_after' | 'past_week' | 'past_month' | 'past_year' | 'next_week' | 'next_month' | 'next_year' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["last_edited_by"] } */ condition?: 'contains' | 'does_not_contain' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["last_edited_time"] } */ condition?: 'equals' | 'before' | 'after' | 'on_or_before' | 'is_empty' | 'is_not_empty' | 'on_or_after' | 'past_week' | 'past_month' | 'past_year' | 'next_week' | 'next_month' | 'next_year' | Expression; /** The formula return type * @displayOptions.show { type: ["formula"] } */ returnType?: 'text' | 'checkbox' | 'number' | 'date' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["formula"], returnType: ["text"] } */ condition?: 'equals' | 'does_not_equal' | 'contains' | 'does_not_contain' | 'starts_with' | 'ends_with' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["formula"], returnType: ["checkbox"] } */ condition?: 'equals' | 'does_not_equal' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["formula"], returnType: ["number"] } */ condition?: 'equals' | 'does_not_equal' | 'greater_than' | 'less_than' | 'greater_than_or_equal_to' | 'less_than_or_equal_to' | 'is_empty' | 'is_not_empty' | Expression; /** The value of the property to filter by * @displayOptions.show { type: ["formula"], returnType: ["date"] } */ condition?: 'equals' | 'before' | 'after' | 'on_or_before' | 'is_empty' | 'is_not_empty' | 'on_or_after' | 'past_week' | 'past_month' | 'past_year' | 'next_week' | 'next_month' | 'next_year' | Expression; /** Title * @displayOptions.show { type: ["title"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ titleValue?: string | Expression | PlaceholderValue; /** Text * @displayOptions.show { type: ["rich_text"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ richTextValue?: string | Expression | PlaceholderValue; /** Phone number. No structure is enforced. * @displayOptions.show { type: ["phone_number"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ phoneNumberValue?: string | Expression | PlaceholderValue; /** Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a> * @displayOptions.show { type: ["multi_select"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } * @default [] */ multiSelectValue?: string | Expression; /** Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a> * @displayOptions.show { type: ["select"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ selectValue?: string | Expression; /** Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a> * @displayOptions.show { type: ["status"] } */ statusValue?: string | Expression; /** Email * @displayOptions.show { type: ["email"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ emailValue?: string | Expression | PlaceholderValue; /** URL * @displayOptions.show { type: ["url"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ urlValue?: string | Expression | PlaceholderValue; /** List of users. Multiples can be defined separated by comma. Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a>. * @displayOptions.show { type: ["people"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ peopleValue?: string | Expression; /** List of users. Multiples can be defined separated by comma. Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a>. * @displayOptions.show { type: ["created_by"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ createdByValue?: string | Expression; /** List of users. Multiples can be defined separated by comma. Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a>. * @displayOptions.show { type: ["last_edited_by"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ lastEditedByValue?: string | Expression; /** Relation ID * @displayOptions.show { type: ["relation"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ relationValue?: string | Expression | PlaceholderValue; /** Whether or not the checkbox is checked. <code>true</code> represents checked. <code>false</code> represents unchecked * @displayOptions.show { type: ["checkbox"] } * @default false */ checkboxValue?: boolean | Expression; /** Number value * @displayOptions.show { type: ["number"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } * @default 0 */ numberValue?: number | Expression; /** An ISO 8601 format date, with optional time * @displayOptions.show { type: ["date"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty", "past_week", "past_month", "past_year", "next_week", "next_month", "next_year"] } */ date?: string | Expression; /** An ISO 8601 format date, with optional time * @displayOptions.show { type: ["created_time"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty", "past_week", "past_month", "past_year", "next_week", "next_month", "next_year"] } */ createdTimeValue?: string | Expression; /** An ISO 8601 format date, with optional time * @displayOptions.show { type: ["last_edited_time"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty", "past_week", "past_month", "past_year", "next_week", "next_month", "next_year"] } */ lastEditedTime?: string | Expression; /** Number value * @displayOptions.show { type: ["formula"], returnType: ["number"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } * @default 0 */ numberValue?: number | Expression; /** Text * @displayOptions.show { type: ["formula"], returnType: ["text"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty"] } */ textValue?: string | Expression | PlaceholderValue; /** Whether or not the checkbox is checked. <code>true</code> represents checked. <code>false</code> represents unchecked * @displayOptions.show { type: ["formula"], returnType: ["checkbox"] } * @default false */ checkboxValue?: boolean | Expression; /** An ISO 8601 format date, with optional time * @displayOptions.show { type: ["formula"], returnType: ["date"] } * @displayOptions.hide { condition: ["is_empty", "is_not_empty", "past_week", "past_month", "past_year", "next_week", "next_month", "next_year"] } */ dateValue?: string | Expression; }>; }; }; }; /** Sort * @default {} */ sort?: { /** Sort */ sortValue?: Array<{ /** Whether or not to use the record's timestamp to sort the response * @default false */ timestamp?: boolean | Expression; /** The name of the property to filter by. Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a>. * @displayOptions.show { timestamp: [false] } */ key?: string | Expression; /** The name of the property to filter by * @displayOptions.show { timestamp: [true] } */ key?: 'created_time' | 'last_edited_time' | Expression; /** Type * @displayOptions.show { timestamp: [true] } * @default ={{$parameter["&key"].split("|")[1]}} */ type?: unknown; /** The direction to sort */ direction?: 'ascending' | 'descending' | Expression; }>; }; }; }; export type NotionV21DatabasePageGetAllOutput = { id?: string; name?: string; url?: string; }; export type NotionV21DatabasePageGetAllNode = { type: 'n8n-nodes-base.notion'; version: 2.1; credentials?: Credentials; config: NodeConfig; output?: Items; };