Hi All,
I'm trying to retrieve a report in a flat form using Custom Data API But after the handshake & fields call I have to select all fields manually by clicking the checkbox. Is there any way to get them automatically
Please Help me out with this issue.
Thanks,
Aashish Chavan
Hello, Aashish!
Thank you for reaching out to us.
Kindly note that this is a default behavior for Flexmonster connected to the custom API server when the SliceObject is not defined. This object is a definition of what data subset is going to be shown in the report and should be predefined in Flexmonster's report. You can either manually set the slice in the report's settings or programmatically select all necessary fields:
olapstructureloaded
event handler, which is triggered after the /fields request. At this point, you can retrieve all fields using getAllHierarchies
method to get all fields and set them in slice via runQuery
API call. You are welcome to check the example: https://jsfiddle.net/flexmonster/np9j0ycs/ Please let us know if one of the suggested solutions works for you.
Best Regards,
Maksym
Thanks Maksym Diachenko for the solution. It works fine.
Hello, Aashish!
Thank you for your feedback.
We are glad to hear that the provided solution works for you.
Feel free to contact us if more questions arise.
Best Regards,
Maksym