Updating item values via C# code by calling change_multiple_column_values

monday Apps & Developers
, ,
1

I’m trying to update items in C# via api calls, but my query is not working, it returns a 500 Internal Server Error, Version: 1.1, but it works in the play ground:
{“query”: “mutation {change_multiple_column_values(item_id: 5720531888, board_id: 5720522778, column_values: “{"name":"Name changed","people":{"personsAndTeams":[{"id":"42575577","kind":"person"}]},"status":{"index":1},"numbers":"10"}” ){id} }”}

This the mutation that works in the play ground the exact mutation, which is not working it code, the values and format are all the same so they are correct:
mutation worksHere {change_multiple_column_values(item_id: 5720531888, board_id: 5720522778, column_values: “{"name":"Name changed","people":{"personsAndTeams":[{"id":"42575577","kind":"person"}]},"status":{"index":1},"numbers":"10"}” ){id} }

By the way, I am able to udpate the board in code, add_users_to_board or delete_subscribers_from_board and that works, including updating description and board name.

Looking forward to getting this working, thanks in advance for your help.

2

Hello there @sbryon and welcome to the community!

I hope you like it here :muscle:

I am not experienced with C# but I tried using your query in Postman and “translating” it to C# and this is what I get:

var client = new HttpClient();
var request = new HttpRequestMessage(HttpMethod.Post, "https://api.monday.com/v2/");
request.Headers.Add("API-Version", "2023-10");
request.Headers.Add("Authorization", "APITOKEN");
var content = new StringContent("{\"query\":\"{change_multiple_column_values(item_id: 5720531888, board_id: 5720522778, column_values: “{\\\"name\\\":\\\"Name changed\\\",\\\"people\\\":{\\\"personsAndTeams\\\":[{\\\"id\\\":\\\"42575577\\\",\\\"kind\\\":\\\"person\\\"}]},\\\"status\\\":{\\\"index\\\":1},\\\"numbers\\\":\\\"10\\\"}” ){id} }\",\"variables\":{}}", null, "application/json");
request.Content = content;
var response = await client.SendAsync(request);
response.EnsureSuccessStatusCode();
Console.WriteLine(await response.Content.ReadAsStringAsync());

Maybe you can compare this with your script and see what the differences are to see what you need to change :grin:

Cheers,
Matias

3

Thanks Matias, I compared your Postman with my C#, the only difference I see is that your content does not contain the key work “mutation” and your have the empty variable property at the end, everything else is the say. I believe for update and create mutation is needed, so far that’s what has been working for me in other functions. Oh, you’re also doing a SendAsync() and I’m doing PostAsync(). Everything else is the same, I’ll do some further digging, but if anyone has this working in C# I’d really appreciate the help. Thanks.

4

Hello again,

Yes!!! I am sorry! I don’t know why the “mutation” was not included. It is indeed needed.

Then from what you say, on the monday side, it looks like everything is in order, so I hope

5

Thank you, it’s all good. I needed to work on my GraphQL syntax, but it’s all working now. Thanks again.

6

I am glad that is the case @sbryon !!