跳至内容

编辑字段（设置）#

使用编辑字段节点来设置工作流数据。该节点既可以设置新数据，也可以覆盖已存在的数据。在需要处理来自前序节点传入数据的工作流中（例如向Google表格或数据库插入值时），此节点至关重要。

节点参数#

这些是“编辑字段”节点中可用的设置和选项。

模式#

您可以选择使用手动映射通过图形界面编辑字段，或者使用JSON输出编写JSON数据，n8n会将其添加到输入数据中。

需要设置的字段#

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

拖动数值时的默认行为是：

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

如果您不想使用表达式：

  1. 将鼠标悬停在字段上。n8n会显示固定值 | 表达式切换选项。
  2. 选择固定。

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

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

仅保留已设置字段#

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

包含在输出中#

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

节点选项#

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

包含二进制数据#

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

忽略类型转换错误#

仅限手动映射。

启用此选项后，n8n在映射字段时可以忽略某些数据类型错误。

支持点符号表示法#

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

例如，当使用手动映射时，节点会遵循名称字段的点表示法。这意味着如果您将名称字段设置为number.one，并将值字段的值设为20，生成的JSON将是：

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

您可以通过选择添加选项 > 支持点表示法，并将点表示法字段设置为关闭来阻止此行为。现在生成的JSON为：

1
{ "number.one": 20 }

模板和示例#

Creating an API endpoint

作者：Jonathan

查看模板详情
Scrape and summarize webpages with AI

由n8n团队

查看模板详情
Very quick quickstart

作者：Deborah

查看模板详情
浏览编辑字段（设置）集成模板, or 搜索所有模板

JSON输出模式中的数组与表达式#

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

例如，以下是客户数据存储节点生成的输入数据：

 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": "gatsby@west-egg.com",
    "notes": "Keeps asking about a green light??",
    "country": "US",
    "created": "1925-04-10"
  },
  {
    "id": "23423533",
    "name": "José Arcadio Buendía",
    "email": "jab@macondo.co",
    "notes": "Lots of people named after him. Very confusing",
    "country": "CO",
    "created": "1967-05-05"
  },
  {
    "id": "23423534",
    "name": "Max Sendak",
    "email": "info@in-and-out-of-weeks.org",
    "notes": "Keeps rolling his terrible eyes",
    "country": "US",
    "created": "1963-04-09"
  },
  {
    "id": "23423535",
    "name": "Zaphod Beeblebrox",
    "email": "captain@heartofgold.com",
    "notes": "Felt like I was talking to more than one person",
    "country": null,
    "created": "1979-10-12"
  },
  {
    "id": "23423536",
    "name": "Edmund Pevensie",
    "email": "edmund@narnia.gov",
    "notes": "Passionate sailor",
    "country": "UK",
    "created": "1950-10-16"
  }
]

在JSON输出字段中添加以下JSON，并将包含在输出中设置为所有输入字段：

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": "gatsby@west-egg.com",
    "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": "jab@macondo.co",
    "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": "info@in-and-out-of-weeks.org",
    "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": "captain@heartofgold.com",
    "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": "edmund@narnia.gov",
    "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"
    }
  }
]
优云智算