Documentation menu

Supported JSON formats

Flexmonster supports JSON data in an array of objects and an array of arrays formats:

// Array of objects
[ 
  { 
    "Color" : "green", 
    "Country" : "Canada", 
    "State" : "Ontario",  
    "City" : "Toronto",  
    "Price" : 174,  
    "Quantity" : 22  
  },  
  {  
    "Color" : "red",  
    "Country" : "USA",  
    "State" : "California",  
    "City" : "Los Angeles",  
    "Price" : 166,  
    "Quantity" : 19  
  }  
]

// Array of arrays  
[  
  ["Color", "Country", "State", "City", "Price", "Quantity"],  
  ["green", "Canada", "Ontario", "Toronto", 174, 22],  
  ["red", "USA", "California", "Los Angeles", 166, 19]  
]

In addition, both formats may include embedded metadata.

Supported input date formats

Flexmonster supports the following date formats:

  1. ISO 8601. For example:

    • "2021-04-25" — date.

    • "2021-04-25T21:30:05" — date and time.

    • "2021-04-25T21:30:05+03:00" — date and time with a time zone.

  2. Unix timestamp in milliseconds. For example, "2021-04-25" is 1619298000000 when converted to a Unix timestamp in milliseconds.
    Note It is important to assign the date type to the Unix timestamp field explicitly. Otherwise, Flexmonster will treat this field as a numeric one.

Other formats aren’t officially supported and may be parsed incorrectly.

See also