Skip to main content

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!

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


Hi Baptiste,


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


Reply