Constructing complex filters for Notion API database queries

Other Questions Notion
1

I’m struggling to create a multi-condition filter for my Notion database query using the API. My single-condition filter works fine:

simple_filter = {
  "filter": {
    "timestamp": "created_time",
    "created_time": {
      "after": "2023-04-01T07:04:00"
    }
  }
}

But when I try to add more conditions with an ‘and’ operator, I get validation errors:

complex_filter = {
    "filter": {
        "and": [
            {
                "timestamp": "created_time",
                "created_time": {
                    "after": "2023-04-01T07:04:00"
                }
            },
            {
                "property": "TaskType",
                "select": {
                    "equals": "Bug Fix"
                }
            },
            {
                "property": "Priority",
                "select": {
                    "equals": "High"
                }
            }
        ]
    }
}

The API keeps complaining about undefined fields. I’ve tried different property types and filter structures but no luck. What am I doing wrong? How can I properly construct this multi-condition filter?

2

hey mate, i’ve run into this too. the trick is to use ‘property’ for everything, even created_time. also, double-check ur property names match exactly what’s in ur database (case matters!). if ur still stuck, try breaking it down into smaller filters first and build up. good luck!

3

I’ve dealt with similar Notion API filter challenges. Your issue likely stems from the filter structure. The ‘timestamp’ field in your first condition is incorrect. Instead, use ‘property’ consistently for all conditions.

Here’s a revised version that should work:

complex_filter = {
    "filter": {
        "and": [
            {
                "property": "created_time",
                "created_time": {
                    "after": "2023-04-01T07:04:00"
                }
            },
            {
                "property": "TaskType",
                "select": {
                    "equals": "Bug Fix"
                }
            },
            {
                "property": "Priority",
                "select": {
                    "equals": "High"
                }
            }
        ]
    }
}

This structure maintains consistency across all filter conditions. Remember, property names are case-sensitive, so ensure they exactly match your database fields. If issues persist, verify your API version and permissions.

4

I’ve encountered similar issues with complex filters in Notion API queries. The key is to structure your filter object correctly. Here’s what worked for me:

For the ‘and’ operator, each condition needs to be a separate object within the array. Also, make sure you’re using the correct property names and filter types for each field.

Try restructuring your filter like this:

complex_filter = {
    "filter": {
        "and": [
            {
                "property": "created_time",
                "created_time": {
                    "after": "2023-04-01T07:04:00"
                }
            },
            {
                "property": "TaskType",
                "select": {
                    "equals": "Bug Fix"
                }
            },
            {
                "property": "Priority",
                "select": {
                    "equals": "High"
                }
            }
        ]
    }
}

Notice how I changed ‘timestamp’ to ‘property’ for the created_time filter. This should resolve the validation errors you’re getting. If you’re still having trouble, double-check that your property names exactly match those in your Notion database, as they’re case-sensitive.