Hi Dojo Community
I'm using the old report engine to generate a tabulated view of a list of circuits and some data for them based on a JSON. However, I would like to migrate from those reports to a more updated tool.
The JSON will contain information about the execution, and a list of entries with the value for his statistics (metrics).
I'm thinking on using the new apps; however, I don't know if it's possible to tabulate information there directly from a JSON (stored in a Cube Table). I know it's possible to replicate tables or request data from specific parameters but never seen more complicated operations like parsing a JSON to generate a table.
Is that possible? Or in the case is not possible, is there any recommendation on how can I achieve something similar?
Thanks in advance!
Hi Luis,
I believe there are two approaches here:
- You could use a custom GQI operator that can read a cell containing the JSON structure and generate columns for each attribute available in JSON payload.
- Another approach could be using GQI custom data source (Configuring an external data source in a query) to get the JSON structure from a table. From 10.3.4 we are able to get data from elements using SLNet messages (RN35701).
Hope it helps.
Thanks Miguel,
I used the GQI Custom Data Source option, and it worked, I was able to retrieve the information beforehand to parse it correctly so it can be displayed exactly how I wanted. It is a very powerful tool.