☝️Small business or a startup? See if you qualify for our special offer.
+

Save issue

Answered
Varun asked 5 days ago

Hi,

 

I loaded attached csv file approx with 500000 rows and was trying to save result but it is somehow not saving the result in json file.

 

Could you please have a look and let me know how can we fix this issue?

 

Thanks,

Varun

1 answer

Public
Maksym Diachenko Maksym Diachenko Flexmonster 3 days ago

Hello, Varun!

Thank you for reaching out to us.

We noticed that you did not attach the CSV file, yet we could reproduce the issue following your description using a similarly-sized file. While loading a CSV file, all the data is stored inside the report as JSON in the dataSource.data property. When saving the report, it is stringified with the 500000 rows of inline data, which causes the saving failure due to exceeding the string size limit.

We recommend connecting to your data via URL instead of loading a local file to avoid this issue. This way, the report remains lightweight, as the URL would be saved in the report instead of a massive JSON array with data:

report: {
dataSource: {
type: "csv",
filename: "https://cdn.flexmonster.com/data/data.csv"
},
}

Below, you can find guides for connecting to JSON and CSV data via URL:

Due to the error being caused by a string size limitation, it cannot be fully resolved. However, our team will improve the error handling for this case in one of the future minor releases, ETA June 9th.

Please let us know if our suggestion was helpful.

Best regards,
Maksym

Please login or Register to Submit Answer