Query
Query Certified

Query a Notion database

yaml
type: io.kestra.plugin.notion.database.Query
yaml
id: notion_query_database
namespace: company.team

tasks:
  - id: query_db
    type: io.kestra.plugin.notion.database.Query
    apiToken: "{{ secret('NOTION_API_TOKEN') }}"
    databaseId: "12345678-1234-1234-1234-123456789abc"
    filter:
      property: "Status"
      select:
        equals: "Done"
    sorts:
      - property: "Created"
        direction: "descending"
    pageSize: 50
    fetchType: STORE

yaml
id: notion_query_database_fetch
namespace: company.team

tasks:
  - id: query_db
    type: io.kestra.plugin.notion.database.Query
    apiToken: "{{ secret('NOTION_API_TOKEN') }}"
    databaseId: "12345678-1234-1234-1234-123456789abc"
    fetchType: FETCH
Properties
DefaultSTORE
Possible Values
STOREFETCHFETCH_ONENONE
Definitions
allowFailedbooleanstring
Defaultfalse
allowedResponseCodesarray
SubTypeinteger
auth
type*Requiredobject
passwordstring
usernamestring
type*Requiredobject
tokenstring
type*Requiredobject
passwordstring
usernamestring
basicAuthPasswordDeprecatedstring
basicAuthUserDeprecatedstring
connectTimeoutDeprecatedstring
Formatduration
connectionPoolIdleTimeoutDeprecatedstring
Formatduration
defaultCharsetstring
DefaultUTF-8
followRedirectsbooleanstring
Defaulttrue
logLevelDeprecatedstring
Possible Values
ALLTRACEDEBUGINFOWARNERROROFFNOT_SPECIFIED
logsarray
SubTypestring
Possible Values
REQUEST_HEADERSREQUEST_BODYRESPONSE_HEADERSRESPONSE_BODY
maxContentLengthDeprecatedinteger
proxy
addressstring
passwordstring
portintegerstring
typestring
DefaultDIRECT
Possible Values
DIRECTHTTPSOCKS
usernamestring
proxyAddressDeprecatedstring
proxyPasswordDeprecatedstring
proxyPortDeprecatedinteger
proxyTypeDeprecatedstring
Possible Values
DIRECTHTTPSOCKS
proxyUsernameDeprecatedstring
readIdleTimeoutDeprecatedstring
Formatduration
readTimeoutDeprecatedstring
Formatduration
ssl
insecureTrustAllCertificatesbooleanstring
timeout
connectTimeoutstring
readIdleTimeoutstring
DefaultPT5M
Default100
SubTypeobject
SubTypeobject
Formaturi