Skip to main content

update_record

Facts

DescriptionUpdate a record
SchemaConnectors.Airtable.functions.UpdateRecord
ServiceAirtable

Input parameters

Required input parameters

airtable_access_tokenslack#/types/credential/oauth2Required

Airtable access token. See the authentication section for details.

Examples
{ credential_source: "END_USER" }
base_idstringRequired

The ID of the base containing the table that has the record you wish to update

column_valuesobjectRequired

A JSON object containing the new column values for this record. Allowed types for input values are singleLineText, multilineText, richText, number, email, phoneNumber, url, singleSelect, multipleSelects, date, and checkbox. All other columns whose types do not belong to this list will be filtered.

Examples
{"pilot_code": "bravo", "email": "xyz@abc.tld"}
search_columnstringRequired

The name of the table column to search through to find the record you wish to update

Examples
"employee_id"
search_valuestringRequired

The value in the search column for the record you wish to update

Examples
"555640"
table_idstringRequired

The ID of the table containing the record you wish to update

Output parameters

Optional output parameters

recordobjectOptional

Column values

record_idstringOptional

Record ID

record_urlstringOptional

Record URL

Authentication

End-user authentication

User workflows that include a connector function relying on end-user authentication can only be started with a link trigger.

{
"airtable_access_token": {
"credential_source": "END_USER"
}
}

End-user experience: User will be prompted to link their external account via OAuth when they first start the workflow that contains this connector.

Developer experience: Developer does not have to implement authentication in the app.

Usage info

First, import Connectors from deno-slack-hub into your project's import_map.json file, like this:

import_map.json
{
"imports": {
"deno-slack-hub/": "https://deno.land/x/deno_slack_hub@2.2.0/",
"deno-slack-sdk/": "https://deno.land/x/deno_slack_sdk@2.14.2/",
"deno-slack-api/": "https://deno.land/x/deno_slack_api@2.8.0/"
}
}

Next, import Connectors at the top of your workflow's definition file:

my_workflow_file.ts
import { Connectors } from "deno-slack-hub/mod.ts";

Finally, add the connector as a step in your workflow just like you would a Slack function.

my_workflow_file.ts
SomeWorkflow.addStep(
Connectors.Airtable.functions.UpdateRecord, {
//...

🧙🏼 Your admin may need to approve the connector first. If your workspace has been configured to only allow admin-approved apps, the CLI will prompt you to send an admin approval request the first time you try to use a connector that hasn't been approved by an admin yet. While waiting for admin approval, the CLI may report an error like this:

Workflow function X is referring to an unknown step output parameter Y

You can safely ignore this error; it will go away as soon as your workspace admin approves your request to use the connector.