Monday.com error: Required field "Item ID" (item_id) is missing

Hi there, @Focushub 👋

Sorry to hear of the troubles here! Is the Get Column Values action taking the value for it’s Item ID field from the Google Calendar trigger or Formatter action step in the Zap?

Asking as I suspect the cause of the issue may lie with whatever trigger or action is supplying the ID to that Get Column Values action. If it’s failing to consistently supply a proper ID that’s then likely what’s causing Monday.com to not finding a match in some cases.
 

Can you please share some additional screenshots here showing the Data In and Data Out in the Zap History of the trigger/action step that the ID has been selected from? That’ll help us to better determine what’s causing the ID to not always be supplied as expected. Please remove/hide any private information (like names, emails, addresses etc.) from any screenshots before sharing.

Thanks, I look forward to your reply! 

No need to apologise @Focushub! 🙂

I can’t see any screenshots showing the Data In so it’s a bit tricky to identify why the number is not being output correctly by the Formatter action some of the time. It could be that there’s an issue with how the number has been added to the event. 🤔 

What Transform function that Formatter action is using?

Is it the Extract Number transform? Like in this example:

 
If so and it’s taking the number from the event’s Summary or Description field, could it be that there are other numbers that appear in the selected field first? If that’s the case then that could be what’s causing this issue as it would only capture the first number group for example if the event summary was “Event #1 ID:12345678910” 1 would be output instead of 12345678910.

Do you think that could be the case here?

Thanks for sharing those additional screenshots @Focushub, it’s much appreciated!

The monday.com action appears to be running correctly but it’s not always being sent a valid Item ID number by the Formatter action. So the issue is likely being caused by that Formatter action which is supplying the Item ID number to the monday.com action. 

Can you please share a screenshot showing the fields and settings that have been selected in the Formatter action. This is the kind of screenshot I’m after that shows the Data In for the Formatter action as well as the Step Details section: 


That will help me to confirm whether or not this issue is definitely being caused by the Formatter action.

Thanks for your continued assistance on this, I look forward to hearing from you! 🙂

I’m so sorry about the delay in my response here @Focushub! 

It looks like you are using that same Extract Number transform for Formattter action so if there’s any number present before the ID number then that will be why it’s not consistently extracting the number.

As an alternative it might be worth using Formatter’s Extract Pattern action instead. It can be set to extract a number that follows a certain word for example, if the event’s summary will always contain the word “ID:” followed by the ID number then you could use ID:\s*(\d+) in the Pattern field like so:


That would ensure that only the ID number that comes immediately after “ID:” would be extracted and any group of numbers present in the event’s summary before that point would be ignored.

From your screenshot it looks like the word immediately before the ID number might be “Reference”. If that’s the case, you’d just need to change the word “ID” in the pattern to be “Reference”, e.g. Reference:\s*(\d+) instead of ID:\s*(\d+) and it should extract the ID number correctly.

You can learn more about using Extract Patterns here: 

Can you give that a try and let me know if that sorts it?

Thanks for being so understanding @Focushub. Excited to hear how you get on with this! 😁