Hi,

I can create item working in SQL Server.

Creating item with column values in (monday.com) is also working.

However, when I try to create item with column values in SQL, it is not working. I have tried many kind of parenthesis for the text. None of them work.

Please see below.

–Working. Below query is working

SET @query = ‘{“query”: "mutation {create_item (board_id: 3791969201, group_id: "new_group16869", item_name: "new item 91") {id }} " }’

–Not working. Below query is not working when I added the column values array

SET @query = ‘{“query”: “mutation {create_item (board_id: 3791969201, group_id: "new_group16869", item_name: "new item 11", column_values: “{ "text" : "test_value" }” ) {id}}”}’

EXEC @hr = sp_OACreate ‘MSXML2.ServerXMLHttp’, @Object OUT

EXEC @hr = sp_OAMethod @Object, ‘open’, NULL, ‘POST’, @Url, false

EXEC @hr = sp_OAMethod @Object, ‘setRequestHeader’, NULL, ‘Authorization’, ‘xxxxx’

EXEC @hr = sp_OAMethod @Object, ‘setRequestHeader’, NULL, ‘Content-Type’, ‘application/json’

EXEC @hr = sp_OAMethod @Object, ‘send’, NULL, @query out

EXEC @hr = sp_OAGetProperty @Object, ‘responseText’, @response OUT

Below is working in monday.com

mutation {

create_item(board_id: 3791969201,

group_id: “new_group16869”,

item_name: “new item 13”,

column_values: “{"text" : "test_value", "text6" : "value2"}”) {

id

}

}

Please help with this. I need to get this working in SQL

Thank you.