16 replies

Query Notion database not working

Hello all, I am new to buildship and trying to explore a possible Notion integration.
So basically what I am trying to do is query a Notion database using filters to retrieve some specific elements from this database
Now it looks like it does connect correctly to the database, but it just ignores completely the filters and returns all the items in the DB. I have tried the exact same filters on Postman and they returns the correct items so I am not sure if I am doing something wrong or if something is broken

This is the workflow, just the Rest call with the body containing the filters, than passing the filters to the Notion node and return the result. I also attached the workflow file.
If anyone have any what's going on please help, I've been stuck on this all day yesterday

Capture_decran_2024-03-19_a_10.42.23.png

message.txt8.56KB

Solution

Hey @LDMWEB, for the second issue with the body validation error, you need to remove the

filter

filter

property and just use the data inside, i.e:

{
  "or": [
    "property": "First Name"
    "title": {
      "contains": "yas"
    },
...

{
  "or": [
    "property": "First Name"
    "title": {
      "contains": "yas"
    },
...

{
  "or": [
    "property": "First Name"
    "title": {
      "contains": "yas"
    },
...

{
  "or": [
    "property": "First Name"
    "title": {
      "contains": "yas"
    },
...

Also, I made some minute modifications to the node to fix the filter issue. Can you refresh the app, clone the node again from the Node Library, and try again? It should work now.

Jump to solution

Query Notion database not working

Similar Threads

Similar Threads

Similar Threads