ET1's JSON Input Node

When extracting data from a JSON file, try the JSON Input Node.

JSON (JavaScript Object Notation) is a common data source.

With ET1’s JSON Input Node you can quickly open your JSON files and begin to transform the data, merge it with other data like CSV data.

In ET1, data is normalized in a data grid view to understand the data as if it was in a normalized view. This is due to the desire for most users to see and understand their data like a data grid. However under the hood the data is JSON because under the hood of ET1 is JavaScript and a DAG Streaming (Graph) engine, which enables ET1 to offer features you’ve never seen before in an ETL software!

Using JSON Input Node

Find the Json Input Node in your with your Hands, or in the hamburger menu in the top right of ET1.

Once your JSON Input Node is on the canvas:

Drag and drop the json file on the node
Click the drag and drop area and a “browse to file” tool will open
- find the JSON and open
If the JSON is structured correctly, the node works.
- Otherwise the node does not work

Example of JSON format that will work:

[
  {
    "name": "Impossible",
    "mean": "0.5",
    "const": "CATS GO MOO"
  },
  {
    "name": "Almost No Chance",
    "mean": "2.0",
    "const": "CATS GO MOO"
  }
]

Now that you’re familiar. Let’s see JSON Input Node in action!

Thanks for learning more about ET1 and know if you have any questions… Please contact us.

We would love to hear about your use cases.

Return to ET1 Overview to learn more.

ET1’s JSON Input Node

Using JSON Input Node

Articles