☝️Small business or a startup? See if you qualify for our special offer.
+

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