Skip to main content

Hi, this post has been closed for comments but I am asking more or less the same question. The issue is similar to the one discussed here as well.

I am trying to get an item in Monday by column value and update the item with new input. I use the “Get Item by Column Value in monday.com” Zap to get the item, but the returned data does not seem to include the item’s unique ID. The reason I need it is so I can use the “Get Column Values in monday.com” Zap to get the item’s actual values (rather than the “Fulfillment Values” provided in the first Zap, which are not formatted properly).

How can I go about retrieving the item’s unique ID from Monday? Thanks!

Hi @Paolo Miriello 

Good question.

For us to have full context, please provide detailed screenshots with how your Zap steps are configured, thanks.

Make sure to include screenshots with all the data points returned from testing the Zap step.


Sure thing!

I first get the item by column value:

 

Using data from a previous Zap to search the table, this returns the item’s values but formatted as JSON (and therefore unusable):

 

My objective is to retrieve the item ID so I can get it using the Get Column Values Zap. However, the previous Zap only returns isFulfilled, isRejected and _zap_search_was_found_status (besides the fulfillmentValue entries). When I try setting up the Get Column Values Zap using a specific Item ID selected from the Zapier interface under the Item ID tab (which wouldn’t work for my use case as this value must be provided dynamically based on previous Zaps whose data appear in the Custom tab), I see the unique ID:

 

And the returned values are formatted properly:

 

So to sum up, I need a way to retrieve the item ID which appears in the before last screenshot as something I can select statically, but not in the values returned dynamically by Get Item by Column Value.


@Paolo Miriello 

For Step 3 we’d need to see how your Zap step is configured:

 

Give this a try…leave the Columns to receive as blank since it’s optional, and that should make sure to return the Item ID you need.

 

 


It seems I may have solved the problem myself: as it turns out, I had selected the “Column to search in” but hadn’t provided the value to search for, which probably returned multiple values from the board. It works now, I have retrieved the Monday item ID. Thanks for your time!


Thanks for closing the loop here, @Paolo Miriello! Glad to hear you were able to get this sorted. 🤗