Notion Node filters : JSOn not working on Get Many Database pages

[Swati]

Notion node filter JSON isnt working. I get a abd request error . I am forced to filter later using a code node and then have issues there which are getting complex. Why cant Notion simply work with a JSON filter. I tried both fixed and expression

[Benoit_Cotte]

Hey there,

Initially, I had the same issue you were facing - it boils down to the content of the filter expression field. Given your screenshot, it looks like you are adding the key “filter” to the payload, which I assume is there by default already.

I am pasting an example below with a payload that works so that you can start from there:

Summary

I want to use the Notion - Get many database page with a filter to get only notion pages where the attribute Description contains “abode” or “build”

Steps to reproduce

1. Log in to your n8n account
2. Go to a workflow view
3. Add a Notion - Get Many Database node
4. Select JSON in filter and select expression
5. Paste the following payload

{
  "or": [
    {
      "property": "Description",
      "rich_text": {
        "contains": "abode"
      }
    }, {
      "property": "Description",
      "rich_text": {
        "contains": "build"
      }
    }
  ]
}

6. Execute step

See settings below

Expected results

• Only pages that matches the filter (in this case 7)

Current results

• Only pages that matches the filter (in this case 7)

[Swati]

I didnt end up using it as I had to move fast ,so i ended up handling the filters post Notion node, but I will try it next time. Thank you so much