Hi ,
when i am using the change_column_value with C# code with below string :
string query = "{"query" : "mutation { change_column_value(board_id: " + boardId + “, item_id: " + itemId + " , column_id: \"” + columnId + “\", value: \"” + value + “\") { id } }"}”;
it is working but when i am using the change_multiple_column_values with C# code below string :
string query = "{"query" : "mutation { change_multiple_column_values(board_id: " + boardId + “, item_id: " + itemId + " , column_values: "{ \"” + columnId1 + “\" : \"”+ columnValue1 + “\",\"” + columnId2 + “\" : \"” + columnValue2 + “\"}") { id } }"}”;
so its not updating the data and give the error The request was successful but contained no data
so please if i am wrong so please correct me .
Hi @knpashish!
Could you please share the exact error as it’s returned from monday, including any error codes along with it?
Hi @alessandra ,
Below is the string which we are passing as mutation to Monday API through our Visual Studio code, also we have vrified our passing string and found it is ok.
We have gone through the most of available resources over the Monday support and they have also suggested the same way to pass mutation
for multiple value update in a monday board through API, but still we have not got any success on this.
{
“query” :
“mutation { change_multiple_column_values(item_id:3216758143, board_id:3216756962, column_values: “{ "business" : { "label" : "InfoPro Learning"}}”) { id}}”
}
API Exception in response:
Id = 169, Status = RanToCompletion,
Method = “{null}”, Result = "StatusCode: 500, ReasonPhrase: ‘Internal Server Error’,
Version: 1.1,
Content: System.Net.Http.StreamContent, Headers:\r\n{\r\n Connection: keep-alive\r\n vary: Origin\r\n
x-request-id: 8ed79c08-65ad-92b6-9bb9-7137ca32911b\r\n x-runtime: 0.010071\r\n x-envoy-upstream-service-time: 49\r\n
content-security-policy: frame-ancestors https://monday.com
Date: Fri, 30 Sep 2022 11:48:46 GMT\r\n Server: cloudflare\r\n Content-Length: 2\r\n Content-Type: application/json; charset=utf-8\r\n}
Kindly do a check over our passing string along with the way we are passing; and let us know if we are still missing something.
regards
Ashish
Hi @knpashish!
I think the error is in the column value, specifically here column_values: “{ "business" : { "label" : "InfoPro Learning"}}”)
Could you please share what type of column you’re trying to change, it’s ID and with what value you want to send? This way we can advise on the correct format.
It might also be useful to check out this guide: Guide to Changing Column Values