Skip to main content

Comma breaking dropdown value

  • April 5, 2022
  • 2 replies
  • 924 views

Hello everyone!

I am very new to GraphQL api and I come accross a problem when I am trying to create a new item using a dropdown with a value containing a comma.

To make it simple, I have this mutation:

mutation {
create_item (board_id: 2322589638, group_id: “topics”, item_name: “ITEM_NAME”, column_values:"{“dropdown”:“This is my value, containing a comma”}") { id, }
}

When I try sending my POST request with POSTMAN, I get the error:
The dropdown label ‘This is my value’ does not exist, possible labels are: This is my value, containing a comma

I am unsure how I can do to escape the comma.

Here is my original request:
mutation { create_item (board_id: 2502539628, group_id: "topics", item_name: "ITEM_NAME", column_values:"{\\"menu_d_roulant1\\":\\"Diplôme ou titre à finalité professionnelle de niveau Bac+2 (DUT, BTS, DEUG)\\",\\"dup__of_rgpd__origine_e_mail\\":\\"Client\\"}") { id, } }

and the error I get:

{

    "error_code": "ColumnValueException",

    "status_code": 200,

    "error_message": "The dropdown label 'Diplôme ou titre à finalité professionnelle de niveau Bac+2 (DUT' does not exist, possible labels are: {1: Bac +2, 2: Bac +, 3: Diplôme ou titre à finalité professionnelle de niveau Bac+2 (DUT, BTS, DEUG), 4: Certificat de certification professionnelle, 5: Diplôme ou titre à finalité professionnelle de niveau Bac+3 (licence) ou Bac+4 (maîtrise, M1), 6: Diplôme ou titre à finalité professionnelle de niveau BAC+5 ( Master, DEA, DESS,Diplôme d'ingénieur)}",

    "error_data": {

        "column_value": "{\\"labels\\"=>[\\"Diplôme ou titre à finalité professionnelle de niveau Bac+2 (DUT\\", \\"BTS\\", \\"DEUG)\\"]}"

    }
}

Thank you for any help!

2 replies

Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • 3512 replies
  • April 11, 2022

Hello @BaptisteS4A!

Which kind of columns are menu_d_roulant1 and dup__of_rgpd__origine_e_mail?

You have to send the data in the right syntax so that it works.

You can see the different syntax for each column type here.

For example, a status column is updated like this:
column_values: "{\\"status15\\" : {\\"label\\" : \\"Done\\"}}

Let me know if this helps 🙂

Cheers,
Matias


  • New Participant
  • 1 reply
  • October 2, 2024

Hi Baptiste,

did you find a solution for your issue? I have the same now.