Annoying Bug Reading JSON From Disk - Connect 2025.1.1

Hi,

Just an FYI. After updating to version 2025.1.1 my old scripts (In the template Scripts pane) that read a JSON file from disk causes an error: (“Empty JSON string”)

Not working: (The space in “Client Name”)
var json_message = loadjson("file:/D:/Client Name/Statements/Template/message.json");

Working: (Replace the space with %20)
var json_message = loadjson("file:/D:/Client%20Name/Statements/Template/message.json");

I think we had this in the past too, not sure iirc.

Regards,
S

Hello @Sharne,

Thank you for reporting this. I have just shared it with my colleagues from R&D.

I noticed that the same also applies to the loadhtml() function.

[internal reference: SHARED-95838]

1 Like

Hi Marten,

I have a similar issue now in Workflow. Folder Capture with a folder URL containing spaces wont pick up data after unzipping from either the Decompress Files or External Program plugin. Support ticket 1772466.

Regards,
S

Unfortunately Connect 2025.1 is less forgiving with URLs than Connect 2024.2 due to restrictions in newer versions of Java.

A space in a URL would need to be encoded as either %20 or +. Another option would be to turn file:/D:/... into a Windows file path by removing the file:/ prefix.

I doubt that issues with spaces in Workflow have the same cause since Workflow is not Java-based.

Thanks Sander. Yeah Workflow and Designer are diff tech. It was by chance that an issue I’m having in Workflow seemed to be corrected by removing spaces, but this is not the case as I was mistaken. The Folder Capture plugin since the update does not like a certain clients data anymore, so something is up with that plugin. Support should let me know soon.

Regards,
S