Open JSON file

open JSON

Open a JSON file: open a JSON file to load data.

Encoding: choose the JSON file encoding.

Show As: Struct / File, "Struct" shows tree view, "File" shows content.

Whole File Content As One Column: True to load whole file content as the only column, False will not.

Node Tree: when "Show As" is "Struct", the node tree shows.

Value Node: show the node name choosed in node tree.

Records: show the child node count of "Value Node".

To Sublevel: the sub-level child nodes of "Value Node" to load. An example.

Array Data: Use First Item / Flat Array Items, for array data, "Use First Item" only load array[0], "Flat Array Items" load all array as a string.

Array/Object Value: Whole JSON String / [ARRAY]/{OBJECT}, for performance.

Record On: array or object child of "Value Node", may have more than 1 record to load. An example.

Set Custom Columns: An example as below

{
  "name": "1",
  "image": "1.png",
  "attributes": [
    {
      "trait_type": "Background",
      "value": "BLAU3"
    },
    {
      "trait_type": "Luckbox",
      "value": "4"
    }
  ]
}
	  

for array "attributes", set 2 custom columns.

1) "attributes[Background]", for:

{
    "trait_type": "Background",
    "value": "BLAU3"
}
	  

2) "attributes[Luckbox]", for:

{
    "trait_type": "Luckbox",
    "value": "4"
}
	  

set custom columns for JSON