Mapping in the UI

You can map data by dragging and dropping data from the INPUT into parameters. This generates the mapping expression for you.

How to drag and drop data

  1. Run your workflow to load data.
  2. Open the node where you need to map data.
  3. You can map in table, JSON, and schema view:
    • In table view: click and hold a table heading to map top level data, or a field in the table to map nested data.
    • In JSON view: click and hold a key.
    • In schema view: click and hold a key.
  4. Drag the item into the field where you want to use the data.

Understand what you're mapping with drag and drop

Data mapping maps the key path, and loads the key's value into the field. For example, given the following data:

Copy
Copied
[
	{
		"fruit": "apples",
		"color": "green"
	}
]

You can map fruit by dragging and dropping fruit from the INPUT into the field where you want to use its value. This creates an expression, {{ $json.fruit }}. When the node iterates over input items, the value of the field becomes the value of fruit for each item.

Understand nested data

Given the following data:

Copy
Copied
[
  {
    "name": "First item",
    "nested": {
      "example-number-field": 1,
      "example-string-field": "apples"
    }
  },
  {
    "name": "Second item",
    "nested": {
      "example-number-field": 2,
      "example-string-field": "oranges"
    }
  }
]