Monday.com required date format forms an invalid JSON file

Beginner Questions
,
1

Hi, I am having trouble with Monday.com integration – they request the date (deadline) for an item to be in this format: [“EXACT”, “2023-07-01”].

However, if i use this format, ChatGPT module outputs what the JSON Parser module says is an invalid JSON file - if i check the JSON in a JSON validator, it says it is expeting colon, not comma:

{
“Task title”:“Návod k Poštonautu U1”,
“Deadline”:“EXACT”,
“2025-07-27”,
“Description”:“Studujte a pochopit návod k službě Poštonaut od firmy U1. Budete potřebovat tyto informace k efektivnímu a správnému použití služby. Kontaktní osoba pro další otázky je Jakub Růžička. Odkaz na původní zprávu: https://mail.google.com/mail/u/0/#inbox/1983d8706746ed65”
}

I think that the problem is that the Monday format of the date makes it that the date is on two lines in the JSON, because of the comma.

Does anyone have any idea how to fix this please? I am new to this :slight_smile:

Adding some screenshots which might help:

Snímek obrazovky 2025-07-24 v 20.05.42
Snímek obrazovky 2025-07-24 v 20.05.42918×1484 108 KB

Snímek obrazovky 2025-07-24 v 20.05.52
Snímek obrazovky 2025-07-24 v 20.05.522624×1744 212 KB

Snímek obrazovky 2025-07-24 v 20.06.10
Snímek obrazovky 2025-07-24 v 20.06.10906×2046 162 KB

1 Like
2

hi @Chytron
check JSON syntax at JSON Parser Online to parse JSON of

Json that you shared is invalid.

You can change date format using {{formatDate(; )}} function.
Best regards,

3

Hey @Chytron

I guess this exact is to instruct the GPT to strictly follow the date format.

A json cannot be ever valid if there is comma between 2 strings defined with “”.

Please remove Exact from the res;onse output sample in GPT and then try Monday api.

Regards,
@Msquare Automation - Gold Partner of Make

1 Like