I have an automation that’s running through Make.com. It makes an API call back to Monday to update multiple column values. The code is stable and no changes have been made. All of a sudden today I’m getting this error:
[400] [{“message”:“parsing error: syntax error: unexpected line terminator”,“locations”:[{“line”:5,“column”:16}],“extensions”:{“code”:“PARSING_ERROR”}},{“message”:“parsing error: syntax error: expected a valid Value”,“locations”:[{“line”:8,“column”:3}],“extensions”:{“code”:“PARSING_ERROR”}}]
It runs successfully under GraphiQL in the Monday Developers space. I have another Make automation that is making a similar multiple column mutation and it’s getting the same parsing error.
Since your question focuses more on the API query, I am changing the category so your post goes into the apps & developers queue. Just wanted to give a head’s up
I think the issue might be with how the JSON is formatted in the column_values. Even though it works in GraphiQL, Make.com might be handling it differently.
Try to escape the double quotes inside the column_values JSON, like this:
@rachelatmonday Can you please check if there has been an update to the API that affects the change_multiple_column_values call?
I see in status.monday.com that there was a scheduled maintenance few days back, can it be related to this error?
Make.com tech supports thinks it’s something on their end. You’ll want to report it to them so they start to compile a record of incidents. In the meantime, review the structure of the JSON and try to make it “compact”. Here’s what they sent me:
I’ve tried multiple times for them to be very specific about where they made the change. No luck so this screenshot is the best I have. From there, it’s a bit of trial and error.
The update body I am sending is pretty much the same as any other till a few days ago: {"query":"mutation {create_update (item_id: 1681046262, body: \"\n <p><b>Ticket description (imported FD message from client):\n </b> \\n <div style=\\\"font-family:-apple-system, BlinkMacSystemFont, Segoe UI, Roboto, Helvetica Neue, Arial, sans-serif; font-size:14px\\\"><div style=\\\"font-family:-apple-system, BlinkMacSystemFont, Segoe UI, Roboto, Helvetica Neue, Arial, sans-serif; font-size:14px\\\"><div dir=\\\"ltr\\\">TEst message</div><div dir=\\\"ltr\\\"><strong dir=\\\"ltr\\\">TEst test message </strong></div></div></div> \\n \\n <b>Comment from Agent:</b> \\nTEst test\\n</p>\") { id }}"}