Reducing operations in Monday.com Module

How To
,
1

Hello Make community!

I am developing a workflow to retrieve data from a csv, filter by date, and remove items in Monday.com if they are not filtered out. However, my problem is that to delete the items from Monday.com I first need to use the ‘Search Items in the Board by Column Values’ to get the Item IDs to use the ‘Delete or Archive an Item’. Doing so means an operation for each record it searches for. Any suggestion on how to reduce the amount of operations in the workflow?

Screenshot 2024-10-02 at 3.31.01 PM
Screenshot 2024-10-02 at 3.31.01 PM1888×374 64.9 KB

1 Like
2

Use the Search items module before the Parse CSV module.

3

Hey @Joseph_Draper.
Unfortunately there is no way to avoid it with your current scenario structure. The “delete item” get 1 and only parameter, the item’s ID. No workaround this even with a GQL command.

image
image760×262 14.7 KB

So you have to use 1 kind of module (in your case the search board) to retrieve that item ID first in order to delete it.

4

Hey @Joseph_Draper

You can do it y listing the items.

  1. List the items from Monday before iterator and then aggregate them into an array.

  2. Now, after ietrator, set the filter saying:

{{map(array_of_items;raw_name_of_column_that_you_are_using_to_search)}} CONTAINS “value from iterator”

  1. Then, inside “delete or archive an item module”, use the map() function to get the IDs:
    {{map(array_of_items;id;raw_name_of_column_that_you_are_using_to_search;value_from_iterator)}}

Hope this helps.

Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation

1 Like