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 G1, 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

Reply


Terms & ConditionsCookie settings