How to stop duplicate Notion database items when referring to a Data Store?

How To
,
1

I’m pretty new to Make and trying to Automate some things on a Notion Dashboard I have set up for my personal scheduling.

My Employer uses Deputy and want to include so that I can see my scheduled shifts within my Notion Schedule.

I’m not too sure of best practises, but essentially this scenario I want to add my scheduled shifts from Deputy to my Notion Database and then have the automation review my database for any existing items that I have specified a date for and change the status to done when the date has passed. Would it be possible to do this in the one scenario or should I separate this as creating Notion database items for Deputy Shifts" and “Updating Status of existing Notion Database Items”?

The issue I am facing, for some reason the scenario is creating duplicate Notion Database items of my scheduled shifts that I have put into my Data Store and I’m not sure exactly why. There is only 10 items in the data storage, but it spits out 15 database items.

image
image3840×1980 382 KB

Any help would be appreciated :grinning:

3

Something to keep in mind, @MieKrispy, is that we’re dealing with bundles.

So your Deputy call is returning ten things, and hopefully each data store is returning one each too. However, at your module 34, one or more of your queries are giving more than one result. Hence the 15.

You might check how to ensure 1-1 relationships or account for 1-M to prevent further duplicates.