Skip to content

Airtable 节点#

¥Airtable node

使用 Airtable 节点，实现 Airtable 中的自动化操作，并将 Airtable 与其他应用集成。n8n 内置支持 Airtable 的多种功能，包括创建、读取、列出、更新和删除表格。

¥Use the Airtable node to automate work in Airtable, and integrate Airtable with other applications. n8n has built-in support for a wide range of Airtable features, including creating, reading, listing, updating and deleting tables.

本页列出了 Airtable 节点支持的操作列表以及更多资源的链接。

¥On this page, you'll find a list of operations the Airtable node supports and links to more resources.

Credentials

请参阅 Airtable 凭据 以了解有关设置身份验证的指导。

¥Refer to Airtable credentials for guidance on setting up authentication.

操作#

¥Operations

  • 将数据追加到表格中。

¥Append the data to a table

  • 从表中删除数据。

¥Delete data from a table

  • 列出表中的数据

¥List data from a table

  • 从表格中读取数据。

¥Read data from a table

  • 更新表格中的数据

¥Update data in a table

模板和示例#

¥Templates and examples

Template widget placeholder.

相关资源#

¥Related resources

n8n 提供了一个用于 Airtable 的触发节点。你可以找到触发节点文档 此处。

¥n8n provides a trigger node for Airtable. You can find the trigger node docs here.

有关服务的更多信息，请参阅 Airtable 文档。

¥Refer to Airtable's documentation for more information about the service.

What to do if your operation isn't supported#

If this node doesn't support the operation you want to do, you can use the HTTP Request node to call the service's API.

You can use the credential you created for this service in the HTTP Request node:

  1. In the HTTP Request node, select Authentication > Predefined Credential Type.
  2. Select the service you want to connect to.
  3. Select your credential.

Refer to Custom API operations for more information.

节点引用#

¥Node reference

获取记录 ID#

¥Get the Record ID

要获取特定记录的数据，你需要记录 ID。你可以通过两种方式获取记录 ID。

¥To fetch data for a particular record, you need the Record ID. There are two ways to get the Record ID.

在 Airtable 中创建记录 ID 列#

¥Create a Record ID column in Airtable

要在表格中创建 Record ID 列，请参考此 article。然后你可以在 Airtable 节点中使用此记录 ID。

¥To create a Record ID column in your table, refer to this article. You can then use this Record ID in your Airtable node.

使用列表操作#

¥Use the List operation

要获取记录的记录 ID，你可以使用 Airtable 节点的列表操作。此操作将返回记录 ID 及其字段。然后你可以在 Airtable 节点中使用此记录 ID。

¥To get the Record ID of your record, you can use the List operation of the Airtable node. This operation will return the Record ID along with the fields. You can then use this Record ID in your Airtable node.

筛选记录使用列表操作时#

¥Filter records when using the List operation

要从 Airtable 数据库中筛选记录，请使用“按公式筛选”选项。例如，如果你希望返回属于组织 n8n 的所有用户，请按照以下步骤操作：

¥To filter records from your Airtable base, use the Filter By Formula option. For example, if you want to return all the users that belong to the organization n8n, follow the steps mentioned below:

  1. 从“操作”下拉列表中选择 '列表'。

¥Select 'List' from the Operation dropdown list. 2. 分别在“基本 ID”和“表”字段中输入基本 ID 和表名称。

¥Enter the base ID and the table name in the Base ID and Table field, respectively. 3. 点击“添加选项”，然后从下拉列表中选择 '按公式筛选'。

¥Click on Add Option and select 'Filter By Formula' from the dropdown list. 4. 在“筛选依据公式”字段中输入以下公式：{Organization}='n8n'。

¥Enter the following formula in the Filter By Formula field: {Organization}='n8n'.

同样，如果你想返回所有不属于 n8n 组织的用户，请使用以下公式：NOT({Organization}='n8n')。

¥Similarly, if you want to return all the users that don't belong to the organization n8n, use the following formula: NOT({Organization}='n8n').

请参阅 Airtable documentation 文档，了解更多关于公式的信息。

¥Refer to the Airtable documentation to learn more about the formulas.

常见问题#

¥Common issues

有关常见错误或问题以及建议的解决方法，请参阅 常见问题。

¥For common errors or issues and suggested resolution steps, refer to Common Issues.