Get Free Trial

How to show Array as field

Ivan Firoavanti asked on March 18, 2020

Is it possible to simply show the value of an array in the Pivot?

1 answer

Vera Didenko Vera Didenko Flexmonster March 19, 2020

Hello, Ivan,
Thank you for writing to us and for providing a JSFiddle for illustration.
We would like to explain that Flexmonster supports two 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.
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:

"Category": "Accessories",
"Color": "green",
"Quantity": 22,
"Test": "A"
"Category": "Accessories",
"Color": "green",
"Quantity": 22,
"Test": "B"

Here is a modified version of the JSFiddle showing the described approach:
Please let us know if this works and if you have any additional questions.
Best regards,

Please login or Register to Submit Answer