Supported JSON formats

In this guide, you can learn how to format your JSON data so WebDataRocks can process it.

WebDataRocks supports two JSON formats:

1) Array of objects. Each object in the array is an unordered collection of key-value pairs, where the key is a field name and the value is a field member. Example:

let jsonData = [
  {
    "Product": "Apple",
    "Price": 2.50
  },
  {
    "Product": "Cherry",
    "Price": 5.25
  }
];

2) Array of arrays. The first subarray contains field names, while other subarrays contain the respective field members. The field’s name and members must have the same position in the subarrays. Example:

let jsonData = [
  ["Product", "Price"],
  ["Apple", 2.50],
  ["Cherry", 5.25]
];

Regardless of what JSON format you choose, the first element of each array can be the mapping object for JSON. This object is used to set data types and create multilevel hierarchies.

See also

• Setting data types in JSON
• Connecting to JSON
• Creating multilevel hierarchies
• Mapping object for JSON