asked on March 18, 2020
Hello,
i would like to check if returned data is empty, i.e. we get the csv headers but no entries.
can i access the data in report and do something like getRowSize() / getNumberOfRows() and if this is 0 act on it?
Now i do have an empty chart, but i would like to tell the user "no data".
Also accessng the data from the API would be very useful...so is there a way to do something like getValue(row,column)?
kind regards
Randolph
⋅ March 18, 2020
Hello, Randolph,
Thank you for contacting us.
We would like to kindly draw your attention to the showEmptyData: false property of the options object. It allows displaying the alert instead of an empty chart/grid in case only headers are defined in the specified CSV file.
Please find out more about options object and its properties (including the showEmptyData one) in our documentation.
Talking about getting the values, our team would like to kindly inform you that Flexmonster is designed to visualize data; therefore, it does not provide an appropriate API allowing get data and manipulate it.
We hope it helps.
Please contact us in case any additional questions occur on this point.
Kind regards,
Illia
⋅ March 18, 2020
Hello Illia,
showEmptyData: false
is set - but no error is triggered.
kind regards
Randolph
⋅ March 19, 2020
Hello, Randolph,
Thank you for your feedback.
We would like to kindly inform you that the issue is not reproducible on our side.
We recommend checking out an example we have prepared for you. It uses the following CSV file with only headers specified.
If it does not help, we suggest providing us with a sample project where the issue can be reproduced so we could investigate it on our side.
We are looking forward to hearing from you.
Best regards,
Illia
⋅ March 19, 2020
Hello Illia,
thanks for your fiddle.
Please have a look at the following one
https://jsfiddle.net/uzcqywnj/
here you can see how to reproduce this.
kind regards
Randolph
⋅ March 20, 2020
Hello,
Thank you for providing us with an example.
We would like to kindly explain that the showEmptyData property should be used instead of showEmptyValues in order to achieve the desired functionality.
Also, it should be specified as a property of the options object instead of grid or chart.
We have changed an example you have provided us with so it works as expected.
We hope it helps.
Please contact us in case additional questions occur.
Kind regards,
Illia
