# How to use Notions Search Objects module to find a database item and use its page ID

**URL:** <https://community.make.com/t/how-to-use-notions-search-objects-module-to-find-a-database-item-and-use-its-page-id/45046>\
**Category:** Questions\
**Tags:** notion, error, filters\
**Created:** [July 8, 2024, 5:07am UTC](https://community.make.com/t/how-to-use-notions-search-objects-module-to-find-a-database-item-and-use-its-page-id/45046 "2024-07-08T05:07:16Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![DenzelDear](https://avatars.discourse-cdn.com/v4/letter/d/6bbea6/32.png) [@DenzelDear](https://community.make.com/u/DenzelDear)\
**Post date:** [July 8, 2024, 5:07am UTC](https://community.make.com/t/how-to-use-notions-search-objects-module-to-find-a-database-item-and-use-its-page-id/45046/1 "2024-07-08T05:07:16Z")

</div>

I’ve got a scenario set up where I would like to sync updated tasks from Todoist in Notion.

How I want to go about this is, after an update event in Todoist, search for a specific database item in Notion to get its page ID, and the final step is to update this database item in Notion. Sounds like 3 simple steps. However, I keep having errors with the second step.

I’m using the Notion Search Objects module to search for a value in a column called “_externalTaskId_.” I’m using the syntax like in the screenshot.

 ![filter Notion](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/b/eb24a39bbec70fdd6bbc414ca510c28bf152a5e7.jpeg)

But I’m getting this error below. How can I solve this? Additionally, is there a way to use a good debugging tool, because these errors aren’t helpful?

> The operation failed with an error. [400] body failed validation. Fix one: body.filter.or[0].title should be defined, instead was `undefined`. body.filter.or[0].rich\_text should be defined, instead was `undefined`. body.filter.or[0].number should be defined, instead was `undefined`. body.filter.or[0].checkbox should be defined, instead was `undefined`. body.filter.or[0].select should be defined, instead was `undefined`. body.filter.or[0].multi\_select should be defined, instead was `undefined`. body.filter.or[0].status should be defined, instead was `undefined`. body.filter.or[0].date should be defined, instead was `undefined`. body.filter.or[0].people should be defined, instead was `undefined`. body.filter.or[0].files should be defined, instead was `undefined`. body.filter.or[0].url should be defined, instead was `undefined`. body.filter.or[0].email should be defined, instead was `undefined`. body.filter.or[0].phone\_number should be defined, instead was `undefined`. body.filter.or[0].relation should be defined, instead was `undefined`. body.filter.or[0].created\_by should be defined, instead was `undefined`. body.filter.or[0].created\_time should be defined, instead was `undefined`. body.filter.or[0].last\_edited\_by should be defined, instead was `undefined`. body.filter.or[0].last\_edited\_time should be defined, instead was `undefined`. body.filter.or[0].formula should be defined, instead was `undefined`. body.filter.or[0].unique\_id should be defined, instead was `undefined`. body.filter.or[0].rollup should be defined, instead was `undefined`. body.filter.or[0].or should be defined, instead was `undefined`. body.filter.or[0].and should be defined, instead was `undefined`.

---

<div class="post-metadata">

**Author:** ![Simo](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/simo/32/9701_2.png) [@Simo](https://community.make.com/u/Simo)\
**Post date:** [July 8, 2024, 5:55am UTC](https://community.make.com/t/how-to-use-notions-search-objects-module-to-find-a-database-item-and-use-its-page-id/45046/2 "2024-07-08T05:55:24Z")

</div>

As a first step to troubleshoot, what property type is “externalTaskId” in your Notion database? Is it a number, text, or something else?

a) If it is a number, the filter data type you select seems correct, so you can try to enclose “818739393” in the function “parseNumber()”

b) If it is a text property, then you may change the filter data type to “text: equals”

* * *

As for the error message, that is actually what the Notion API outputs, and I see your point about its lack of clarity.  
An additional more detailed tool to troubleshoot is the [Integromat DevTool](https://chromewebstore.google.com/detail/integromat-devtool/ainnemkhpnjgkhcdkfbhmlenkhehmfhi) browser extension

---

<div class="post-metadata">

**Author:** ![DenzelDear](https://avatars.discourse-cdn.com/v4/letter/d/6bbea6/32.png) [@DenzelDear](https://community.make.com/u/DenzelDear)\
**Post date:** [July 8, 2024, 7:59am UTC](https://community.make.com/t/how-to-use-notions-search-objects-module-to-find-a-database-item-and-use-its-page-id/45046/3 "2024-07-08T07:59:16Z")

</div>

It is a text, so I previously selected “text equals”. But after encountering many errors, I tried changing the datatype of my Notion database to number and selected “number equals” in Make. Thanks for the ParseNumber function, but it still doesn’t work. Here is my scenario flow. Is there anything I should change here?

 ![scenario flow](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/f/6fb6eb4c394d3c1ac319c659c7f49065b570a903.png)

---

<div class="post-metadata">

**Author:** ![Simo](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/simo/32/9701_2.png) [@Simo](https://community.make.com/u/Simo)\
**Post date:** [July 8, 2024, 10:03am UTC](https://community.make.com/t/how-to-use-notions-search-objects-module-to-find-a-database-item-and-use-its-page-id/45046/4 "2024-07-08T10:03:50Z")

</div>

When you insert the database ID manually in a Search Objects module, you should see a dropdown menu of available properties to use for filtering in the database (see screenshot as an example). In your previous screenshot, it looks like you have typed the property name manually, which may be the reason why it’s not working.

So, you could try: (1) double-checking that the Connection has access to the database you want to use; (2) using the “Search” option next to “Database ID” to search for the desired database by its name; (3) re-pasting the database ID without any extra spaces at the end/beginning.

Let’s see if any of these things help, otherwise we can continue troubleshooting.

 ![the search object module and the option to select from the available properties](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/0/80a7295a7f56e559b7e6190c935ebc6787bb8bef.png)

---

<div class="post-metadata">

**Author:** ![Carlo](https://avatars.discourse-cdn.com/v4/letter/c/c4cdca/32.png) [@Carlo](https://community.make.com/u/Carlo)\
**Post date:** [July 31, 2024, 8:54pm UTC](https://community.make.com/t/how-to-use-notions-search-objects-module-to-find-a-database-item-and-use-its-page-id/45046/5 "2024-07-31T20:54:49Z")

</div>

I have the same problem, and I don’t even get the dropdown for the filter.

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/4/1/4176c98c30b37c07d37406a7d36f006b3bb58e0b.png)

---

<div class="post-metadata">

**Author:** ![Carlo](https://avatars.discourse-cdn.com/v4/letter/c/c4cdca/32.png) [@Carlo](https://community.make.com/u/Carlo)\
**Post date:** [July 31, 2024, 8:55pm UTC](https://community.make.com/t/how-to-use-notions-search-objects-module-to-find-a-database-item-and-use-its-page-id/45046/6 "2024-07-31T20:55:36Z")

</div>

i would be very open to troubleshoot this to the end its a very important module in notion

---

<div class="post-metadata">

**Author:** ![Simo](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/simo/32/9701_2.png) [@Simo](https://community.make.com/u/Simo)\
**Post date:** [July 31, 2024, 11:08pm UTC](https://community.make.com/t/how-to-use-notions-search-objects-module-to-find-a-database-item-and-use-its-page-id/45046/7 "2024-07-31T23:08:57Z")

</div>

Try using the “Search” menu and typing the database name you want to use there. The ID will be automatically populated if the connection has access to it. If not, it means the connection doesn’t have access to it.

 ![click on "search" and type the database name](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/e/9e16229ad27f98eb7cc438276854e8a3030342ad.png)

---

<div class="post-metadata">

**Author:** ![Carlo](https://avatars.discourse-cdn.com/v4/letter/c/c4cdca/32.png) [@Carlo](https://community.make.com/u/Carlo)\
**Post date:** [August 1, 2024, 12:59pm UTC](https://community.make.com/t/how-to-use-notions-search-objects-module-to-find-a-database-item-and-use-its-page-id/45046/8 "2024-08-01T12:59:02Z")

</div>

I Deleted All My Notion Connections and Created a Complet New One but the Query Search does not work

---

<div class="post-metadata">

**Author:** ![Carlo](https://avatars.discourse-cdn.com/v4/letter/c/c4cdca/32.png) [@Carlo](https://community.make.com/u/Carlo)\
**Post date:** [August 1, 2024, 1:05pm UTC](https://community.make.com/t/how-to-use-notions-search-objects-module-to-find-a-database-item-and-use-its-page-id/45046/9 "2024-08-01T13:05:02Z")

</div>

![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/1/c1936c848bb83f41e182d9637f198b0300eca9d3.png)

im confused with this when i try connecting make to my database it never works i cant seem to find a “add” button for make

---

<div class="post-metadata">

**Author:** ![Carlo](https://avatars.discourse-cdn.com/v4/letter/c/c4cdca/32.png) [@Carlo](https://community.make.com/u/Carlo)\
**Post date:** [August 1, 2024, 1:06pm UTC](https://community.make.com/t/how-to-use-notions-search-objects-module-to-find-a-database-item-and-use-its-page-id/45046/10 "2024-08-01T13:06:02Z")

</div>

![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/7/676544db71b50e454636d782713b9bcc74d2a9cc.png)  
there is this also if i click make here it brings me to the sign up page of [make.com](http://make.com)

---

<div class="post-metadata">

**Author:** ![Carlo](https://avatars.discourse-cdn.com/v4/letter/c/c4cdca/32.png) [@Carlo](https://community.make.com/u/Carlo)\
**Post date:** [August 1, 2024, 1:11pm UTC](https://community.make.com/t/how-to-use-notions-search-objects-module-to-find-a-database-item-and-use-its-page-id/45046/11 "2024-08-01T13:11:35Z")

</div>

ok I GOT it 🙂

"To add databases from your Notion account to Make app:

1. Log in to your Notion account.
2. Enter into the database you want to add to Make , click on **…** in the top right corner, click **Add connections** , search for and click on the integration you previously created, and click **Confirm**."

[https://www.make.com/en/help/app/notion](https://www.make.com/en/help/app/notion)

the search! is importand here it will not show your connections on default you have to search for it

and after you made the integration Notion x Make you also need to make the connection Notion Database x Make Scenario

ok thanks Simo for the help 🙂 finally its over haha

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [October 30, 2024, 2:12pm UTC](https://community.make.com/t/how-to-use-notions-search-objects-module-to-find-a-database-item-and-use-its-page-id/45046/12 "2024-10-30T14:12:05Z")

</div>


