Curl example of a mutation with variables

[lmatter]

I was successful using the “try it” feature of the api docs to perform a mutation using variables. Now I’m trying to convert that syntax into a curl command. Even when putting data in a file (then referencing with @filename) in the curl command, the amount of escaping and quoting is driving me bonkers. All I ever get is a “400 Bad Request” in the headers, nothing to indicate what’s invalid. I’ve seen some sample updates with curl, but none with variables.

Can someone post a working example please?
Thanks!

[lmatter]

Sorry, more specifically what I’m looking for is a mutation create_item with column_values (using variables). I can actually get a new item created, but the column_values are never set.

[dipro-monday.com]

Hey @lmatter!

I just played around with this, and you can use the following cURL command to populate an item with values from a variable. However, there is still a lot of escaping involved, since the column values need to be passed as a JSON string. Are you solely using cURL to call the API?

curl -X POST -H "Content-Type:application/json" -H "Authorization:xxxxx" 'https://api.monday.com/v2' \
-d '{"query" : "mutation($name:String!, $columns:JSON!){create_item(item_name:$name, board_id:162169280, column_values:$columns){name}}", "variables" : "{\"name\" : \"This is a var\", \"columns\" : \"{\\\"status\\\" : {\\\"index\\\" : 4}}\"}"}'

[lmatter]

Thanks! Actually, I just switched over to Postman, but I still need help getting my create-item to populate the column_values. I’ll take a look at your example to see if it gets me further. If you have a postman example that would be awesome!

[lmatter]

I replied to this thread as I’m now using postman:

Creating an item with columns populated

I’m utilising Postman to create a new item with populated columns, however I’ve hit a problem where the item is created, but the fields remain blank. This is my syntax mutation { create_item ( board_id: 283592949, group_id: “For Consideration”, item_name: “New Suggestion”, column_values:" { \“Priority\” : {\“label\” : \“Low\”}, \“Your_Name\”:\“Hello world\”, \“Department\” :\“Hello world\” }" ) { id } } If I try mutation { create_item ( board_id: 283592949, group_id: “For Co…

[djpsantos]

I am having a similar issue, trying to create an item on a board and setting a person to be assigned to it. The item gets created but the name of the person never gets filled.

This is my QL:
mutation {

create_item (board_id: 248361481, group_id: “oa_generated”, item_name: “Test5”,column_values:"{[{“id”:8203162,“kind”:“person”}]}") {
id
}
}

what am i missing

[dipro-monday.com]

Hey @djpsantos!

For the column values, you’ll need to pass a JSON object that uses column IDs for the keys and the values that you want to set for the values themselves. Something like this:

"column_values" : {"text1" : "This is text", "status1" : {"label" : "Done"}}

As for the person column, I’d suggest using the format described in our documentation here.

Let me know if that helps!

Cheers,
Dipro

[djpsantos]

Dipro,

So something like this ?

mutation {

create_item (board_id: 248361481, group_id: “oa_generated”, item_name: “Poland Threat Report & Eastern Europe”,column_values:"{[{“personsAndTeams”:[{“id”:8203162,“kind”:“person”}]}")
{

id

}

}

I have tried it and i am having 500 internal server error.

I checked the board_id, group_id and person id.

Any pointers ?

Thanks

[dipro-monday.com]

@djpsantos – are you getting this from cURL or in the testing environment?

If it’s cURL, can you send the full cURL command (without your API key) so we can take a look?

[djpsantos]

I am doing it from the QL interpreter on monday.com website.
Something like this :

mutation {
create_item (board_id: 248361481, group_id: “oa_generated”, item_name: “Poland Threat Report & Eastern Europe”,column_values:"{[{“personsAndTeams”:[{“id”:8203162,“kind”:“person”}]}") {
id
}
}