Skip to main content

Hello, I use monday API from a while now, and suddenly an error has appears (on the 29/03) after days of good work.


I have test many possibility of queries but I can’t figured it out.


There is my query :


$query =

            'mutation {

            create_item ( board_id: 409788845, group_id: "topics", item_name: "TEST MODULE",

                column_values: "{

                    \\"texte5\\" : \\"test tex\\",

                    \\"texte\\" : \\"Dev\\",

                    \\"person\\" : \\"2556545674\\",

                    \\"connecter_les_tableaux7\\" : {\\"item_ids\\" : :14564564960]},

                    \\"date\\" : {\\"date\\" : \\"2023-03-30\\", \\"time\\" : \\"08:49:02\\"},

                    \\"date6\\" : {\\"date\\" : \\"2023-03-30\\", \\"time\\" : \\"10:25:00\\"},

                    \\"chiffres\\" : \\"1.6\\",

                    \\"chiffres0\\" : \\"372847239\\"

                }")  {

                    id

                }

            }';

This return me this error :


{

    "errors": :

        {

            "message": "Parse error on bad Unicode escape sequence: \\"{\\\\n                    \\\\\\\\\\\\\\"texte5\\\\\\\\\\\\\\" : \\\\\\\\\\\\\\"test tex\\\\\\\\\\\\\\",\\\\n                    \\\\\\\\\\\\\\"texte\\\\\\\\\\\\\\" : \\\\\\\\\\\\\\"Dev\\\\\\\\\\\\\\",\\\\n                    \\\\\\\\\\\\\\"person\\\\\\\\\\\\\\" : \\\\\\\\\\\\\\"2556545674\\\\\\\\\\\\\\",\\\\n                    \\\\\\\\\\\\\\"connecter_les_tableaux7\\\\\\\\\\\\\\" : {\\\\\\\\\\\\\\"item_ids\\\\\\\\\\\\\\" : :14564564960]},\\\\n                    \\\\\\\\\\\\\\"date\\\\\\\\\\\\\\" : {\\\\\\\\\\\\\\"date\\\\\\\\\\\\\\" : \\\\\\\\\\\\\\"2023-03-30\\\\\\\\\\\\\\", \\\\\\\\\\\\\\"time\\\\\\\\\\\\\\" : \\\\\\\\\\\\\\"08:49:02\\\\\\\\\\\\\\"},\\\\n                    \\\\\\\\\\\\\\"date6\\\\\\\\\\\\\\" : {\\\\\\\\\\\\\\"date\\\\\\\\\\\\\\" : \\\\\\\\\\\\\\"2023-03-30\\\\\\\\\\\\\\", \\\\\\\\\\\\\\"time\\\\\\\\\\\\\\" : \\\\\\\\\\\\\\"10:25:00\\\\\\\\\\\\\\"},\\\\n                    \\\\\\\\\\\\\\"chiffres\\\\\\\\\\\\\\" : \\\\\\\\\\\\\\"1.6\\\\\\\\\\\\\\",\\\\n                    \\\\\\\\\\\\\\"chiffres0\\\\\\\\\\\\\\" : \\\\\\\\\\\\\\"372847239\\\\\\\\\\\\n                }\\" (error) at t3, 32]",

            "locations": :

                {

                    "line": 3,

                    "column": 32

                }

            ]

        }

    ],

Here is how I send the data in PHP :


 $result = @file_get_contents($this->apiUrl, false, stream_context_create(e

            'http' => ;

                'method' => 'POST',

                'header' => $this->headers,

                'content' => json_encode(e'query' => $query]),

            ]

        ]));

I understand that the error is at the beginning of the column_values but impossible to make work again.


Again I want to specify that my request were working before the 29 (I have tried with the exact data who works previously).


Could you take a look at this ?


Thanks.

Clement.

Just to double on this I have had some live software also stop working recently due to the same error, anyone know if this is an API change or what?

Hello everyone,


I have checked with the team and it looks like you might be seeing this errors because of a migration that was done on our end.


The new changes follow the GraphQL specifications more closely and patches lots of different gaps, just like strings with line endings.


To have a multiline string you need to use block strings """text""" , not "text".


You can also remove line endings from the query and keep it in one line.


You can also use GraphQL variables to put in any text as a JSON. It’s recommended to use this approach for big values, as this improves readability of queries.


I attached some examples of valid and invalid queries.


Please let me know if you have any questions!


Valid:

image


Valid:

image


Invalid:

image

Thanks for your reply.


Effectively, passing the variable as GraphQL variables fix the issues.


Here is an example in PHP if it can help somebody :


$query_update_item =

            'mutation($column: JSON!) {

                change_multiple_column_values ( item_id: '. $id .', board_id: '.$this->board_id.', column_values: $column )  {

                    id

                }

            }';



        $var = [

            'column' => '{

                    "texte5" : "'. $text .'",

                    "texte" : "'. $text1 .'",

                    "connecter_les_tableaux7" : {"item_ids" : ['. $timer->project_id .']},

                    "date" : {"date" : "'.$day_start.'", "time" : "'.$hour_start.'"},

                    "date6" : {"date" : "'.$day_end.'", "time" : "'.$hour_end.'"},

                    "chiffres" : "'. $chiffres .'",

                    "chiffres0" : "'. $chiffres0 .'"

                }'

        ];





        $result = @file_get_contents($this->apiUrl, false, stream_context_create([

            'http' => [

                'method' => 'POST',

                'header' => $this->headers,

                'content' => json_encode(['query' => $query_update_item, 'variables' => $var]),

            ]

        ]));

Hello again,


I am glad that worked!


Thank you for sharing this!


Cheers,

Matias

Reply


Terms & ConditionsCookie settings