I’m using the CSV Creator plugin to generate a CSV file from JSON data and send it via email. My workflow is structured as follows:
Create CSV from JSON
New File from Base64
Send Email
This works fine for smaller datasets. However, when the JSON data becomes larger (e.g., text with over 120,000 characters), the process fails. On checking the server logs, I see a message like:
~ [truncated, was 123988]
I’ve attached a screenshot for reference. How can I handle large JSON data effectively to avoid this issue?
Please watch this video, it will give you some guidance how to overcome this issue:
Actually this is due to a hard limit in Bubble itself not a plugin problem.
Please feel free to contact me should need any further support because I solved it in a use case that is even more complex than the one in the video above and all working fine with me.
First of all, thanks for your reply! And sorry for the delayed response.
I’ve tried the steps shown in the video (attached a photo for reference), but I’m still facing the truncation issue. It seems that the JSON might be too long, and part of it gets cut off.
Also, the “New File from Base64” parameter is causing an error, so the CSV file isn’t being created. Do you have any suggestions on how to fix this?
@qareer Thanks for your reply. Well the truncation thing is not a problem. Usually you will see the text truncated in the log and that’s the same for me while my file is being generated successfully.
The problem here is the workflow error; the “CSV Creator error - the parameter contents cannot be empty”.
I believe the parameter you are passing to this step is “Result of Step 2’s download’s finalJSON”, Right ?
Please make sure that this is not empty. You can add a Console log (Server) step similar like the one in the attached screenshot to see the error message and whether it’s empty or not.
