How to get the underlying data from the pivot?

For debugging purpose, is there a way to get the underlying data from pivot? When using remote json, there’re times where the backend send the data, but pivot doesn’t seem to grab it. If there’s some way to retrieve the current working data from the pivot, it’ll be easier for debugging.

3 answers

Public
Dmytro Zvazhii Flexmonster August 29, 2018

Hello, Liang Yi Aris,
Thank you for writing. Currently, you can try using CSV export from the flat view to retrieve data from the pivot. Also, please note, that if you have an issue when loading the data we recommend providing us with a working sample where the issue is reproducible. That will help us to investigate the issue and fix it.
Please let us know in case of any other question.
Regards,
Dmytro

Public
liangyi2012 August 31, 2018

That’s good idea. Will do that. I think the scenario happens when property changes in remote json. If report requires property to exist but doesn’t, it may cause report to not load anything. So it may be about how to update the data schema, when there’re existing report depending on old one.

Public
Tanya Gryshko Flexmonster August 31, 2018

Hello, Liang Yi,
Thank you for the additional details. Here is a working example showing the flow you described: https://jsfiddle.net/flexmonster/ghvq9hhw/18/. Also, please note that both API calls connectTo and updateData can load new data, however, they work differently. Please check whether you use the one you need.
Waiting for the feedback from you.
Regards,
Tanya

Please login or Register to Submit Answer