# Notion - Query database action

The Query database action searches a Notion database and returns a list of records that match the criteria you specify.

# Input

Field Description
Database Select the database to search.
Filter source list Input a list datapill to create the filter from.
Column Select the column to filter by.
Value Provide the value to compare against the selected Column values.
Filter condition Specify how to compare the returned Column values against the Value you set.
Condition Specify whether to use AND or OR logic for the filter's conditions.
Sort by Select a property to sort the results by.
Sort order Specify whether to sort the records in ascending or descending order.
Sort by Timestamp column Select a timestamp column to sort the results by.
Cursor Provide the next_cursor value to retrieve the next page of results. Defaults to the first page if left blank.
Page size Enter the number of records to return per page. The maximum and default value is 100.

# Output

Field Description
Object The type of object retrieved.
Page ID The identifier for the associated page.
Created time The timestamp when the object was created.
Last edited time The timestamp when the object was last updated.
Archived Indicates whether the database is archived.
URL The queried object's URL.
Parent Contains information about the queried object's parent, such as its Type and ID.
Properties Contains information about the queried object's properties, such as its Title, Type, and ID.
List size The total number of matching results.
List index The position of the returned entries within the results list.
Next cursor The identifier for the next page of results.
Has more Indicates if there are additional results.


Last updated: 12/3/2024, 4:54:13 PM

On this page