Skip to content

数据表#

¥Data table

使用“数据表”节点以表格格式永久保存跨工作流执行的数据。它提供对存储数据执行各种数据操作的功能。查看 数据表。

¥Use the Data Table node to permanently save data across workflow executions in a table format. It provides functionality to perform various data operations on stored data. See Data tables.

节点参数#

¥Node parameters

资源#

¥Resource

选择要操作的资源。

¥Select the resource on which you want to operate.

  • 行

¥Rows

操作#

¥Operations

选择要对资源执行的操作：

¥Select the operation you want to run on the resource:

  • 删除：删除一行或多行。

¥Delete: Delete one or more rows.

  • 试运行：在最终确定删除操作之前进行模拟。如果你启用此选项，n8n 将返回操作将删除的行。默认状态为 off。

    ¥Dry Run: Simulate a deletion before finalizing it. If you switch on this option, n8n returns the rows that will be deleted by the operation. Default state is off.

  • 获取：根据定义的筛选条件从表中获取一行或多行数据。

¥Get: Get one or more rows from your table based on defined filters.

  • 限制：要返回的行数，以数字形式指定。默认值为 50。

    ¥Limit: The number of rows you want to return, specified as a number. Default value is 50.

  • 返回全部：启用此选项以返回所有数据。默认值为 off。

    ¥Return all: Switch on to return all data. Default value is off.

  • 如果该行存在：指定一组条件，用于匹配数据表中存在的输入项。

¥If Row Exists: Specify a set of conditions to match input items that exist in the data table.

  • 如果行不存在：指定一组条件，用于匹配数据表中不存在的输入项。

¥If Row Does Not Exist: Specify a set of conditions to match input items that don't exist in the data table.

  • 插入：将行插入到现有表中。

¥Insert: Insert rows into an existing table.

  • 批量优化：处理大量行数据时，优化插入速度。如果你启用此选项，n8n 将不会返回已插入的数据。默认状态为 off。

    ¥Optimize Bulk: Optimize the speed of insertions when working with many rows. If you switch on this option, n8n won't return the data that was inserted. Default state is off.

  • 更新：更新一行或多行数据。

¥Update: Update one or more rows.

  • 更新/插入：更新或插入一行或多行数据。如果该行存在，则更新它；否则，将创建一个新行。

¥Upsert: Upsert one or more rows. If the row exists, it's updated; otherwise, a new row is created.

相关资源#

¥Related resources

数据表 讲解如何创建和管理数据表。

¥Data tables explains how to create and manage data tables.