I want to export report dataset content into excel using only Java. From the documentation I found a way to get the report dataset content into a megacollection like this -
MegaObject mgobjDataSubSet = megaRoot.getCollection("~)ilXTIGrKPiB[Report DataSet]").get(datasetId);
MegaCollection mgcolDataSubSetValues = mgobjDataSubSet.getCollection("~Yvazr2mvKf21[DataSet Create]");
How can I iterate through this collection to get the short names of all the objects in this collection?
Does anyone have any insights into this? Is it possible to use the java API to extract an existing report dataset to Excel?