🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Fail on trying to test with valid JSON: get an alert about invalid JSON

Answered
Evgeniy Orlov asked on April 14, 2021

Hello!
 
I try to test flexmonster with a local JSON, but fail on upload: i get an alert “invalid JSON”. Tested the file with other validators it is validated errorfree.
Could you please look into this issue? i attach the test file.
BTW. same issue happens with Webdatarocks – valid file can’t be uploaded and alerted as invald.

Thank you!

Attachments:
combined-results.json

1 answer

Public
Vera Didenko Vera Didenko Flexmonster April 15, 2021

Hello, Evgeniy,
 
Thank you for writing to us.
 
You are right; the provided JSON is valid. However, it has a nested JSON structure.
 
Flexmonster works with the following JSON formats: 

  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.

 
Currently, 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 flattening the JSON data before loading it into Flexmonster.
 
Please let us know if further questions arise – we will be happy to help.
 
Kind regards,
Vera

Please login or Register to Submit Answer