I am hoping to extract the JSON from the data that is currently displayed in the report. I have been able to successfully extract data using the new get data function, however I am looking for one of two things:
My aim here is to be able to extract the JSON or the list of ID records from that I am viewing, with the current filters, and then parse them to another software platform.
Hello, Scott,
Thank you for posting on our forum.
We would like to explain that Flexmonster is a tool for data visualization and analysis. The component is not designed to serve as a data provider for external software platforms. Its capabilities on this point are limited with exporting the data to the predefined set of formats (CSV, Excel, PDF, etc.) and integrating with third-party charting libraries using the getData
function mentioned in your question.
In a similar way, records' identifiers (the id
data type) are aimed to provide additional control over the component's behavior and configuration, not to be used for extracting the data.
Do not hesitate to contact us if other questions occur.
Kind regards,
Illia
Hello, thank you for your response.
Are you suggesting that what I am looking for is not possible? That I cannot extract or identify which JSON elements are currently being displayed within the pivot?
Hello, Scott,
Concerning data extraction, the only option to do so in JSON format is the getData
function mentioned earlier.
Also, you can always identify which JSON element (record from the dataset) was used in composing each specific cell by retrieving its identifier. Identifiers can be retrieved in different ways, including cellclick
, celldoubleclick
events, customizeCell
hook and getCell
/getSelectedCell
methods. Please note that none of the listed approaches can be used to iterate over the grid and retrieve all its information. All of them are aimed to provide some additional data about a cell or set of cells interesting for the user. For example, show id's on click, customize cells based on their identifiers, etc.
Please let us know if other questions arise.
Regards,
Illia