We have updated Flexmonster Software License Agreement, effective as of September 30, 2024. Learn more about what’s changed.

How to show Array as field

Answered
Ivan Firoavanti asked on March 18, 2020

Is it possible to simply show the value of an array in the Pivot? https://jsfiddle.net/61fnov4d/
Thanks,
Ivan

1 answer

Public
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: https://jsfiddle.net/flexmonster/sow71m4v/
 
 
Please let us know if this works and if you have any additional questions.
 
Best regards,
Vera

Please login or Register to Submit Answer