Notion filter - "and.a.split is not a function"

How To
1

Hi everyone,

I’m having trouble with setting up a filter in Make.com. I have a Notion database where one of the columns is a checkbox labeled “Opublikowany” (which means “publicated”). I want the “Search Rows” module to pass only the rows where this checkbox is unchecked (false). I’ve attached a screenshot of how I’m setting the filter.

image
image1113×908 76.3 KB

Unfortunately, I’m encountering an error: “Function ‘filter’ finished with error! and.a.split is not a function”. I’m not sure what I’m doing wrong.

Can anyone help me figure out the correct way to set this up?

Thanks in advance!

3

Hi,
Here (video) is how you could achieve this, using “Make an API Call” instead of “Search objects” (reason explained in the video).

Here is the body of the Make an API Call module (edit the values in double curly brackets and bold correctly based on your scenario):

{
“filter”: {
“or”: [
{
“property”: “{{10.name}}”,
“{{10.type}}”: {
“equals”: false
}
}
]
},
“sorts”: [
{
“timestamp”: “created_time”,
“direction”: “ascending”
}
]
}

1 Like
4

Thank you for your reply. It turned out that my error was retrieving the database ID from Output. All I had to do was manually enter the database ID and a list of available options appeared in the filter.

2 Likes