Why is all my data not populating?

Daniel Egladyous asked on July 10, 2019

When I connect a local JSON file, none of my data besides the Grand Total populates. I have tried in the Demo as well as downloaded the free version and neither has worked. I used “WebDataRocks” which is also powered by Flexmonster, and on the same dataset, all of my data populates as soon as I upload the file.
 
After uploading the JSON file, in fields, I select “traderName” as Rows, and “totalShares” as a Value. The only thing that populates is the grand total. If you click the “Settings” on traderName in the table itself, it will show you all of the names correctly listed, but not populating into the table. 

Attachments:
gs.summaries.json

3 answers

Public
Vera Didenko Flexmonster 7 days ago

Hello, Daniel,
 
Thank you for writing to us.
 
 
Please keep in mind that the JSON format should be one of the following:
 
1) An array of objects, where each object is an unordered set of name/value pairs
2) An array of arrays, where each sub-array contains ordered values.
 
Nested JSON data is not supported in Flexmonster.
 
More information about supported JSON formats can be found in our connecting to JSON guide.
 
Our team kindly suggests restructuring the JSON data the following way:

[
{
......
"customScenarioData": 0.0,
"customScenarioDataToEquity": -0.0,
......
"gatewayStatus": "",
"overallState": null,
......
"shockEffects": 0.0,
......
},
{
......
"customScenarioData": 0.0,
"customScenarioDataToEquity": -0.0,
......
"gatewayStatus": "",
"overallState": null,
......
"shockEffects": 0.0,
......
},
....
]

This format is supported and the output should be as desired.
 
Here is a JSFiddle example for illustration.
 
Please let us know if this works.
 
Best Regards,
Vera

Public
Daniel Egladyous 3 days ago

Hello Vera,
I have used WebDataRocks which seems to be a free version of the Pivot Table also powered by Flexmonster. (https://www.webdatarocks.com/demos/javascript-pivot-table-demo/)
This website seemed to have supported Nested JSON.
Is there a way to restructure our data in an automated process, as you have done above, so Flexmonster can process our data correctly? Our data comes in large formats, and is very nested as you could see.
 
If you could provide any help it would be appreciated.
Thank you,
Daniel

Public
Tanya Gryshko Flexmonster 2 days ago

Hello, Daniel,

Thank you for your answer.

We would like to inform you that WebDataRocks works with arrays of objects, where each object is an unordered set of name/value pairs. Nested JSON is not supported for WebDataRocks.

Speaking of flattening the JSON, there are some helping utilities on the internet. We suggest looking for the one you need for your programming language.

Please let us know in case of other questions.

Regards,
Tanya

Please login or Register to Submit Answer