Hello, I am facing an issue when updating columns in monday.com.
Here is the error: RuntimeError
[200] Syntax error in JSON input [ Error Code: JsonParseException / Error Details: {“json”:“{ "location__1": {"lat":47.7947622,"lng":-3.2547295,"address":"8 Le Champ des Cerfs, 56700 Kervignac…”} ]
Origin Monday
I do not see where this syntax error is coming from!
This is the input bundle
it is giving the same issue on email too. I am using the update Col value of a specific item:
Can you please help?
1 Like
Does that column still exist? If yes, then check you have the correct column id
If all that is fine, try the latitude and longitude to 2 decimal places. If that works, keep increasing the decimal places till they stop working so you can figure out up to how many decimal places it allows
1 Like
I am not only having this issue with location. I am having this same issue with emails… I am suspecting that the problem might be coming from the fact that the collection is in an array and that I may need to use an iterator.
1 Like
Fill it out properly in Monday, and then use the Get an Item module, and see how the data is returned. It should look similar and show you what’s different to your inputs
1 Like
the only thing that solved is parsing it all in JSON:
although GPT is outputting JSON…
1 Like
Any idea how to parse out non dates and output a blank value in make?
I have tried this
and then this:
if(contains(32.end_date; “-”) and length(32.end_date) = 10; if(formatDate(parseDate(32.end_date; “DD-MM-YYYY”); “DD-MM-YYYY”) = 32.end_date; 32.end_date; “”); “”) nothing worked
1 Like
Hi @Emmanuel_Yazbeck
Correct formula is this:
{{if(contains(32.end_date; “-”) = true; 32.end_date; emptystring)}}
Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation
2 Likes
