Query
Query a Notion database
Query
Query a Notion database
yaml
type: io.kestra.plugin.notion.database.QueryExamples
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
databaseId *Requiredstring
apiToken string
fetchType string
Default
STOREPossible Values
STOREFETCHFETCH_ONENONEfilter object
options Non-dynamic
Definitions
io.kestra.core.http.client.configurations.HttpConfiguration
allowFailedbooleanstring
Default
falseallowedResponseCodesarray
SubTypeinteger
auth
io.kestra.core.http.client.configurations.BasicAuthConfiguration
type*Requiredobject
passwordstring
usernamestring
io.kestra.core.http.client.configurations.BearerAuthConfiguration
type*Requiredobject
tokenstring
io.kestra.core.http.client.configurations.DigestAuthConfiguration
type*Requiredobject
passwordstring
usernamestring
basicAuthPasswordDeprecatedstring
basicAuthUserDeprecatedstring
connectTimeoutDeprecatedstring
Format
durationconnectionPoolIdleTimeoutDeprecatedstring
Format
durationdefaultCharsetstring
Default
UTF-8java.nio.charset.Charset
followRedirectsbooleanstring
Default
truelogLevelDeprecatedstring
Possible Values
ALLTRACEDEBUGINFOWARNERROROFFNOT_SPECIFIEDlogsarray
SubTypestring
Possible Values
REQUEST_HEADERSREQUEST_BODYRESPONSE_HEADERSRESPONSE_BODYmaxContentLengthDeprecatedinteger
proxy
io.kestra.core.http.client.configurations.ProxyConfiguration
addressstring
passwordstring
portintegerstring
typestring
Default
DIRECTPossible Values
DIRECTHTTPSOCKSusernamestring
proxyAddressDeprecatedstring
proxyPasswordDeprecatedstring
proxyPortDeprecatedinteger
proxyTypeDeprecatedstring
Possible Values
DIRECTHTTPSOCKSproxyUsernameDeprecatedstring
readIdleTimeoutDeprecatedstring
Format
durationreadTimeoutDeprecatedstring
Format
durationssl
io.kestra.core.http.client.configurations.SslOptions
insecureTrustAllCertificatesbooleanstring
timeout
io.kestra.core.http.client.configurations.TimeoutConfiguration
connectTimeoutstring
readIdleTimeoutstring
Default
PT5MpageSize integerstring
Default
100sorts array
SubTypeobject
startCursor string
Outputs
hasMore boolean
nextCursor string
row object
rows array
SubTypeobject
size integer
uri string
Format
uri