C# query escape characters- 500 error

The problem is you are trying to manually serialize your request body.

# warning, I am not a C# guy, so I know C# gets weird about strings. Needing a number of 
# $ equal to the number of sequential {{{ for example, and """ three or greater depending 
# on how many sequential quotes are inside the string.
var queryString = """{
  items_page_by_column_values(
    board_id: 5146042481
    columns: [{column_id: "name", column_values: "DDNL05"}]
  ) {
    cursor
    items {
      id
    }
  }
}""";
var fullQuery = JsonSerializer.Serialize({query: queryString});

Investigate GraphQL Variables because they will make your life much easier trying to substitute the values in your query.

Hello @J_Morl I don’t have experience with C# either, but this might help. I used your query in Postman and then exported it and this is the result:

C# HttpClient:

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\\":\\"{\\\\n  items_page_by_column_values(\\\\n    board_id: 1234567890\\\\n    columns: [{column_id: \\\\\\"name\\\\\\", column_values: \\\\\\"DDNL05\\\\\\"}]\\\\n  ) {\\\\n    cursor\\\\n    items {\\\\n      id\\\\n    }\\\\n  }\\\\n}\\",\\"variables\\":{}}", null, "application/json");
request.Content = content;
var response = await client.SendAsync(request);
response.EnsureSuccessStatusCode();
Console.WriteLine(await response.Content.ReadAsStringAsync());

C# RestSharp:

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\\":\\"{\\\\n  items_page_by_column_values(\\\\n    board_id: 1234567890\\\\n    columns: [{column_id: \\\\\\"name\\\\\\", column_values: \\\\\\"DDNL05\\\\\\"}]\\\\n  ) {\\\\n    cursor\\\\n    items {\\\\n      id\\\\n    }\\\\n  }\\\\n}\\",\\"variables\\":{}}", null, "application/json");
request.Content = content;
var response = await client.SendAsync(request);
response.EnsureSuccessStatusCode();
Console.WriteLine(await response.Content.ReadAsStringAsync());

Hope that helps!

Cheers,
Matias

Hey guys,

Thank you both for the great suggestions, I have definitely added Postman to my tools. I wanted to give an update. I was able to get a working query this morning using JsonSerializer. with a basic HttpClient.

            string json =
                System.Text.Json.JsonSerializer.Serialize(
                    new
                    {
                        query = @"{
                              items_page_by_column_values (board_id: $board columns: [{column_id: ""name"", column_values: ""Test_01""}]) {cursor items{id}} }",
                    }
                );

That’s great @J_Morl !!