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
- Run your workflow to load data.
- Open the node where you need to map data.
-
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.
- 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:
[
{
"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:
[
{
"name": "First item",
"nested": {
"example-number-field": 1,
"example-string-field": "apples"
}
},
{
"name": "Second item",
"nested": {
"example-number-field": 2,
"example-string-field": "oranges"
}
}
]