A date column needs to have a JSON with date, not text
See: https://api.developer.monday.com/docs/date#json
mutation {
change_multiple_column_values(item_id:11111, board_id:22222, column_values: "{\\"date\\" : {\\"date\\" : \\"1993-08-27\\", \\"time\\" : \\"18:00:00\\"}}") {
id
}
}
I tried it. Still got this error.
{“errors”:{“message”:“Parse error on "date" (STRING) at T1, 80]”,“locations”:{“line”:1,“column”:80}]}],“account_id”:7398594}
Fid you escape teh date string in the JSON?
Yes I did. Already escaped
Can you share your full query string as build and show it as formatted test. This editor has it’s own mind on escaping 🙂 and formatting, so it is better to always enter this kind of data as a preformatted text (using the </>
button.
I tried multiple queries but returns error.
query = “{"query" : "mutation { change_column_value(board_id: 3063556967, item_id: 3075649406 , column_values: {\\"” + “date” + “\\" : {\\"” + “date” + “\\" : \\"” + “2022-08-16” + “\\"}}){ id} }"}”;
–{“errors”:{“message”:“Parse error on "date" (STRING) at 1, 92]”,“locations”:"{“line”:1,“column”:92}]}],“account_id”:7398594}
query = “{"query":"mutation{ change_multiple_column_values (item_id:3075700297, board_id:3063556967, column_values: \\"{\\\\"status_1\\\\" : {\\\\"label\\\\" : \\\\"Done\\\\"}}\\"){ id} }"}”;
–Newtonsoft.Json.JsonException: ‘The response from https://api.monday.com/v2/ was InternalServerError’
Sorry, I can’t analyze these as they are formatted text, please add them between
triple backktick or use the </> button in the format bar
The formatter here deletes escapes characters.
Hi - let me know if you have not solved this. I have done this before and might be able to provide you with assistance if you still need it
Hi! I already solved this. I also created a new topic regarding here. Thank you!
Hello! I wanted to share my work which spent some time and patience.
I tried a lot of format that returns multiple errors. I also got an idea from someone here in the community but I forgot the name. Well, thanks to you.
Hope this helps! Happy coding!
[image]
This results to:
{“query” : “mutation { create_item (board_id: 3063556967, item_name: "Daily xxx" , column_values: "{\\"date\\" : {\\"date\\" : \\"2022-08-15\\"}}"){ id} }”}
Remember the escaping.