Monday.com error: Required field "Item ID" (item_id) is missing
Hello, I have this problem in an automation between Monday and Zapier, it consists of taking a value from a table by its ID item_id where the IDs are 10 numbers when it gets the ID it takes the 10 digits, but for some reason it takes an ID of a single number therefore generating an error and stops or does not take any and still fails, I attach images with the errors and when it works
Page 1 / 1
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!
Sorry for the lateness, I hope this helps
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?
Sorry if I didn't send you the complete data, I already know the complements
What I think is that from one moment to another it works without problems as you see in the screenshots and it only takes the data from the column, nothing changes, it only takes the data but fails because it does not get it at some moment.
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!
Thank you very much, I'll send you the screenshot now.
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?
Okay, thank you very much, no problem, I'm also busy with a lot of things, I will soon make the changes you have suggested here and I will keep you informed, truly grateful.
Thanks for being so understanding @Focushub. Excited to hear how you get on with this!