Get Free Trial

Get Current JSON In Report

Scott Oliver asked on July 30, 2021

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:

  • The entire JSON packets that make up the data I am viewing (in compact or classic view)
  • A specific JSON object of the data that makes up what I am viewing (such as ID or Age)

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.

3 answers

Illia Yatsyshyn Illia Yatsyshyn Flexmonster July 30, 2021

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,

Scott Oliver August 6, 2021

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?

Illia Yatsyshyn Illia Yatsyshyn Flexmonster August 6, 2021

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.

Please login or Register to Submit Answer