Skip to main content

Hello,

I have been working with the Monday API with some success. I have run into difficulty with change_multiple_column_values. Here is the error:

message: “Parse error on “: {” (STRING) at [1, 107]”, the character at 107 is a semicolon

I have a working query in POSTMAN

mutation {
 change_multiple_column_values (item_id: 22222222, board_id: 1111111111, column_values: "{\\"date4\\": {\\"date\\":\\"1993-08-27\\"},\\"text9\\": \\"Barney Rubble\\",\\"text0\\": \\"Corporate\\",\\"link\\":{\\"url\\" : \\"https://support.company.com/app/itdesk/ui/requests/109348000039391139/details#\\", \\"text\\":\\"Original Request\\"} }") {
    id
  }
}

So I took that POSTMAN query and escaped it to use in a C# console app


  {\\"query\\":\\"mutation {change_multiple_column_values (item_id: 22222222, board_id: 1111111111, column_values: \\\\\\"{\\\\\\"date4\\\\\\": {\\\\\\"date\\\\\\":\\\\\\"1993-08-27\\\\\\"},\\\\\\"text9\\\\\\": \\\\\\"Barney Rubble\\\\\\",\\\\\\"text0\\\\\\": \\\\\\"Corporate\\\\\\",\\\\\\"link\\\\\\":{\\\\\\"url\\\\\\" : \\\\\\"https://support.company.com/app/itdesk/ui/requests/109348000039391139/details#\\\\\\", \\\\\\"text\\\\\\":\\\\\\"Original Request\\\\\\"} }\\\\\\") {id}}\\"}

I just can’t get it to run successfully in my C# app. Can anyone see where I might have gone wrong?

Thank you!

Cliff

Hello @cliff.leavitt and welcome to the community!

I hope you like it here 💪

I do not have experience with C# but it looks like yo might not be escaping quotes the right way.

Here is an example of a working query so you have an example to follow:

{"query": "mutation { change_multiple_column_values ( item_id: 12345678, board_id: 11223344, column_values:\\"{\\\\\\"people\\\\\\":{\\\\\\"personsAndTeams\\\\\\":[{\\\\\\"id\\\\\\":2300000,\\\\\\"kind\\\\\\":\\\\\\"person\\\\\\"}]},\\\\\\"people_1\\\\\\":{\\\\\\"personsAndTeams\\\\\\":[{\\\\\\"id\\\\\\":2300001, \\\\\\"kind\\\\\\":\\\\\\"person\\\\\\"}]}}\\") { name}}"}

I hope this helps 🙂

Cheers,
Matias

Hi Matias,

Thank you! I will give that a try in my service app. I did get it working nicely in Javascript using Axios and Fetch Api. I figured I must have missed something in my original.

Cheers

Cliff

Terms & ConditionsCookie settingsAccessibility statement