Skip to content

Edit Fields (Set) 节点#

使用 Edit Fields 节点设置工作流数据。此节点可以设置新数据以及覆盖已存在的数据。此节点在期望从前面节点接收传入数据的工作流中至关重要，例如向 Google Sheets 或数据库插入值时。

节点参数#

这些是 Edit Fields 节点中可用的设置和选项。

Mode 模式#

您可以使用 Manual Mapping 手动映射 通过 GUI 编辑字段，或使用 JSON Output JSON 输出 编写 n8n 添加到输入数据的 JSON。

Fields to Set 要设置的字段#

如果您选择 Mode 模式 > Manual Mapping 手动映射，您可以通过从 INPUT 拖放值来配置字段。

拖动值时的默认行为是：

  • n8n 将值的名称设置为字段名称。
  • 字段值包含访问该值的表达式。

如果您不想使用表达式：

  1. 悬停在字段上。n8n 显示 Fixed | Expressions 固定 | 表达式 切换。
  2. 选择 Fixed 固定。

您可以对字段的名称和值都执行此操作。

A gif showing the drag and drop action, as well as changing a field to fixed

Keep Only Set Fields 仅保留设置的字段#

启用此选项可丢弃您在 Fields to Set 要设置的字段 中未使用的任何输入数据。

Include in Output 包含在输出中#

选择要在节点输出数据中包含哪些输入数据。

节点选项#

使用这些选项自定义节点的行为。

Include Binary Data 包含二进制数据#

如果输入数据包含二进制数据，选择是否将其包含在 Edit Fields 节点的输出数据中。

Ignore Type Conversion Errors 忽略类型转换错误#

仅限手动映射。

启用此选项允许 n8n 在映射字段时忽略一些数据类型错误。

Support Dot Notation 支持点表示法#

默认情况下，n8n 支持点表示法。

例如，使用手动映射时，节点遵循 Name 名称 字段的点表示法。这意味着如果您在 Name 名称 字段中将名称设置为 number.one，在 Value 值 字段中将值设置为 20，结果 JSON 为：

1
{ "number": { "one": 20} }

您可以通过选择 Add Option 添加选项 > Support Dot Notation 支持点表示法，并将 Dot Notion 点表示法 字段设置为关闭来防止此行为。现在结果 JSON 为：

1
{ "number.one": 20 }

模板和示例#

Browse 设置 integration templates, or search all templates

JSON Output 模式中的数组和表达式#

在创建 JSON Output 时，您可以使用数组和表达式。

例如，给定 Customer Datastore 节点生成的输入数据：

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
[
  {
    "id": "23423532",
    "name": "Jay Gatsby",
    "email": "[email protected]",
    "notes": "Keeps asking about a green light??",
    "country": "US",
    "created": "1925-04-10"
  },
  {
    "id": "23423533",
    "name": "José Arcadio Buendía",
    "email": "[email protected]",
    "notes": "Lots of people named after him. Very confusing",
    "country": "CO",
    "created": "1967-05-05"
  },
  {
    "id": "23423534",
    "name": "Max Sendak",
    "email": "[email protected]",
    "notes": "Keeps rolling his terrible eyes",
    "country": "US",
    "created": "1963-04-09"
  },
  {
    "id": "23423535",
    "name": "Zaphod Beeblebrox",
    "email": "[email protected]",
    "notes": "Felt like I was talking to more than one person",
    "country": null,
    "created": "1979-10-12"
  },
  {
    "id": "23423536",
    "name": "Edmund Pevensie",
    "email": "[email protected]",
    "notes": "Passionate sailor",
    "country": "UK",
    "created": "1950-10-16"
  }
]

在 JSON Output JSON 输出 字段中添加以下 JSON，并将 Include in Output 包含在输出中 设置为 All Input Fields 所有输入字段：

1
2
3
4
5
6
7
8
9
{
  "newKey": "new value",
  "array": [{{ $json.id }},"{{ $json.name }}"],
  "object": {
    "innerKey1": "new value",
    "innerKey2": "{{ $json.id }}",
    "innerKey3": "{{ $json.name }}",
 }
}

您将得到此输出：

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
[
  {
    "id": "23423532",
    "name": "Jay Gatsby",
    "email": "[email protected]",
    "notes": "Keeps asking about a green light??",
    "country": "US",
    "created": "1925-04-10",
    "newKey": "new value",
    "array": [
      23423532,
      "Jay Gatsby"
    ],
    "object": {
      "innerKey1": "new value",
      "innerKey2": "23423532",
      "innerKey3": "Jay Gatsby"
    }
  },
  {
    "id": "23423533",
    "name": "José Arcadio Buendía",
    "email": "[email protected]",
    "notes": "Lots of people named after him. Very confusing",
    "country": "CO",
    "created": "1967-05-05",
    "newKey": "new value",
    "array": [
      23423533,
      "José Arcadio Buendía"
    ],
    "object": {
      "innerKey1": "new value",
      "innerKey2": "23423533",
      "innerKey3": "José Arcadio Buendía"
    }
  },
  {
    "id": "23423534",
    "name": "Max Sendak",
    "email": "[email protected]",
    "notes": "Keeps rolling his terrible eyes",
    "country": "US",
    "created": "1963-04-09",
    "newKey": "new value",
    "array": [
      23423534,
      "Max Sendak"
    ],
    "object": {
      "innerKey1": "new value",
      "innerKey2": "23423534",
      "innerKey3": "Max Sendak"
    }
  },
  {
    "id": "23423535",
    "name": "Zaphod Beeblebrox",
    "email": "[email protected]",
    "notes": "Felt like I was talking to more than one person",
    "country": null,
    "created": "1979-10-12",
    "newKey": "new value",
    "array": [
      23423535,
      "Zaphod Beeblebrox"
    ],
    "object": {
      "innerKey1": "new value",
      "innerKey2": "23423535",
      "innerKey3": "Zaphod Beeblebrox"
    }
  },
  {
    "id": "23423536",
    "name": "Edmund Pevensie",
    "email": "[email protected]",
    "notes": "Passionate sailor",
    "country": "UK",
    "created": "1950-10-16",
    "newKey": "new value",
    "array": [
      23423536,
      "Edmund Pevensie"
    ],
    "object": {
      "innerKey1": "new value",
      "innerKey2": "23423536",
      "innerKey3": "Edmund Pevensie"
    }
  }
]