Monday API change_multiple_column_values not working

monday Apps & Developers
,
1

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

2

Hello @cliff.leavitt and welcome to the community!

I hope you like it here :muscle:

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 :slightly_smiling_face:

Cheers,
Matias

3

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

1 Like