Parsing Error When Creating an Item with column_values in deluge zoho cliq

Platform discussions monday apps & integrations
,
1

I am trying to create an item using the Monday.com API with the create_item mutation. When I include column_values, I get a parsing error, but when I remove column_values, the mutation works fine.

Mutation That Fails

column_values_map = Map();
if(task_description != null) {
column_values_map.put(“text8”, task_description);
}

// Convert column values map to a valid JSON string
column_values_json = toJSONList(column_values_map);
info "Escaped Column Values JSON: " + column_values_json;

// Mutation query with properly formatted column values
query = "mutation { create_item (board_id: " + board_id + “, group_id: "” + group_id + “", item_name: "” + task_name + “", column_values: " + column_values_json + " ) { id }}”;

info "query: " + query;

header_data = Map();
header_data.put(“Content-Type”, “application/json”);

body_data = Map();
body_data.put(“query”, query);

info "body = " + body_data.toString();

response = invokeurl
[
url : “https://api.monday.com/v2”
type : POST
body: body_data.toString()
headers: header_data
connection: “mon”
];

info "Task Created Response: " + response;

Error Response

Escaped Column Values JSON: {“text8”:“w”}

query: mutation { create_item (board_id: 1966479412, group_id: “topics”, item_name: “a”, column_values: {“text8”:“w”} ) { id }}

body = {“query”:“mutation { create_item (board_id: 1966479412, group_id: "topics", item_name: "a", column_values: {"text8":"w"} ) { id }}”}

Task Created Response: {“errors”:[{“message”:“parsing error: syntax error: expected R_CURLY, got "text8"”,“locations”:[{“line”:1,“column”:99}],“extensions”:{“code”:“PARSING_ERROR”}},{“message”:“parsing error: syntax error: expected R_PAREN, got "text8"”,“locations”:[{“line”:1,“column”:99}],“extensions”:{“code”:“PARSING_ERROR”}},{“message”:“parsing error: syntax error: expected R_CURLY, got "text8"”,“locations”:[{“line”:1,“column”:99}],“extensions”:{“code”:“PARSING_ERROR”}},{“message”:“parsing error: syntax error: expected definition”,“locations”:[{“line”:1,“column”:99}],“extensions”:{“code”:“PARSING_ERROR”}},{“message”:“parsing error: syntax error: expected a StringValue, Name or OperationDefinition”,“locations”:[{“line”:1,“column”:106}],“extensions”:{“code”:“PARSING_ERROR”}},{“message”:“parsing error: syntax error: expected definition”,“locations”:[{“line”:1,“column”:107}],“extensions”:{“code”:“PARSING_ERROR”}},{“message”:“parsing error: syntax error: expected a StringValue, Name or OperationDefinition”,“locations”:[{“line”:1,“column”:110}],“extensions”:{“code”:“PARSING_ERROR”}},{“message”:“parsing error: syntax error: expected a StringValue, Name or OperationDefinition”,“locations”:[{“line”:1,“column”:112}],“extensions”:{“code”:“PARSING_ERROR”}},{“message”:“parsing error: syntax error: expected a StringValue, Name or OperationDefinition”,“locations”:[{“line”:1,“column”:120}],“extensions”:{“code”:“PARSING_ERROR”}}],“account_id”:27707574}

If anyone has a more efficient way to handle JSON escaping in deluge, please help!