Add +1 on property using API call to filter for Status

[MaGiiCall]

Hey,
I have a number property in Notion called “Days In Progress”. Each time I would run the Make automation, I would like to ADD 1 to this property.

Unfortunatly I cant use “Search Objects”, because I cant filter for Status. Only Tasks with Status = In Progress should get that treatment.

Therefore I thought, I gonna do it with the API Call as mentioned here:

Notion Search by Status

Is there any way using a Notion search objects module to search by a status field? It’s not listed in the available fields which seems strange. This seems like something very basic which is why I I wonder if there is a solution. I’ve done some searching but so far I haven’t found anyone who successfully uses a status field on a search object.

But I always get an error on “Update a Database Item”.

Here the whole setup with its properties:

I am very new to Make.com. So this might be a beginner mistake. I tried to find anything related to this in forums, youtube videos etc. but couldnt find it. I am stuck here.

Hope someone can help. Let me know if you need more informations!

[momomomonmon]

@MaGiiCall
Hey, welcome to make community!
Thank you for the detailed description.
You probably need to configure it on Notion.
You will need to add a Connection to the target Notion’s Database.

The procedure and details can be found in the following link under “Add Databases to be visible in Make”.
https://www.make.com/en/help/apps/productivity/notion#add-databases-to-be-visible-in-make-964748

[MaGiiCall]

Hey, thank you for the quick reply.
This I already did set up. I already did things with using “Watch Database Items” and they work.
But in this case, I dont want to have the Item to be updated to receive a change. I would like to run the automation each 24 hours on every task which has “Status” set to “In Progress”.
I could use “Search Objects”. But unfortunatly, it doesnt allow me to filter for status (see image).

I am looking for an alternative way, and found the post (mentioned above) using the “Make API Call”. But yea, I get an error

I am open for any fixes or alternative ways on doing this.

[momomomonmon]

@MaGilCall
I was totally mistaken, I’m sorry.

The mistake is that the value specified for “Database Item ID” in the “Update a Database Item” Module is “Database ID”.

The following screenshot shows the result of the “Make an API Call” Module. When /v1/databases/${databaseId}/query is executed, the part result > id is Database Item Id.

[MaGiiCall]

okay, interesting, that works! thank youu!
“Make an API Call” only makes 1 call, meaning: Only modifies one task in a run in my example. Correct?
Instead of using something like “Watch Database Items”, where I can modifiy multiple tasks in one run?

If so, is there an alternative way, where I can modify a property in all “Status = In Progress” tasks?

[momomomonmon]

@MaGiiCall
Great!!!
Whether you use Make an API Call module or Update a Database Item module, I believe you can only update one Database Item per API Request.

If you get multiple Database Items with “Watch Database” module, try adding an Iterator module after “Watch Database Items” module. The results Array will be split and you should be able to execute it for each Database Item.