Hi All :)
I am updatting a Monday.com Board from a new Google Sheets record.
I currently have a zap set up with Monday.com's v1.0 API that takes 8 tasks of the allowed 750 monthly tasks. It works fine.
I wanted to do this with less tasks so in the second (I was granted access to the new) Monday.com API v2 there seems to be a task associated with updating multiple cells.
I am now able to post 5 of the 7 column values to the correct cell in the Monday.com board (Board_ID: 518892687)
However, when using the Monday.com v2 API integration on Zapier I get errors for two of the columns I want to post to:
The first one is a date column:
I get this error:
In the previous version of the Zapier API (v1.xxx) I also did a column post with this date that worked fine after I formatted it using the Formatter by Zapier app task.
Currently, the date that is sent to the pulse is formatted as this (YYYY-MM-DD): Column_ID = date_of_job where it needs to be updated.
Is this formatting the issue? Or something else?
The second issue I have is trying to update a number column (Column_ID: time_spent_in_hours)
And when I attempt to push that value through, I get this error:
As you can see from the examples above those 2 records are giving these errors respectively, so I have isolated these two problems.
If I run the zap like this:📷
Without the date_of_job and time_spent_in_hours included in the data send, It updates fine on the Monday board.
Can someone please point me towards a forum where I can raise this issue? Thanks so much!
Best answer by Liz_RobertsView original