Skip to main content

Hello,


I try to use API v2 console with this request:


mutation {

change_column_value (

board_id: 493115024,

item_id: 496948433,

column_id: “email”,

value: “{\\"email\\":\\"a.b@gmail.com\\",\\"text\\":\\"a.b@gmail.com\\"}”) {

id

}

}


The board exists and item exists - I used this query before:


query {

items_by_column_values (board_id: 493115024, column_id: “email”, column_value: “o@a.com”) {

id

}

}

received response:


{

“data”: {

“items_by_column_values”: m

{

“id”: “496948433”

}

]

},

“account_id”: 5856938

}


So when I attempt to change the email value, I keep receiving internal server error 500.


I researched the forum and tried many things. But any complex value requiring {} substructure returns me the error 500.


image


What’s going on?

Hi @sternet 👋


Based on your message above, I see a couple possible culprits.


The first being that this direct copy-paste of your code includes beginning quotations and end quotations - “” - which will cause problems.


monday.com’s API is expecting a more generic quotation - "


I’ve replaced the quotations and tested that API call, and it works as expected:


mutation {

change_column_value (board_id: 493115024, item_id: 496948433, column_id: "email" value: "{\\"email\\":\\"a.b@gmail.com\\",\\"text\\":\\"a.b@gmail.com\\"}") {

id

}

}

Additionally, in your screenshot I can see that you’re using an email address of a.b%40gmail.com which will also cause problems. the API is instead expecting the typical email format of a.b@gmail.com 🙂


-Scott

Terms & ConditionsCookie settings