update_record
Facts
Connectors.Airtable.functions.UpdateRecord
Airtable
Input parameters
Required input parameters
airtable_access_token
slack#/types/credential/oauth2
RequiredAirtable access token. See the authentication section for details.
{ credential_source: "END_USER" }
base_id
string
RequiredThe ID of the base containing the table that has the record you wish to update
column_values
object
RequiredA 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.
{"pilot_code": "bravo", "email": "xyz@abc.tld"}
search_column
string
RequiredThe name of the table column to search through to find the record you wish to update
"employee_id"
search_value
string
RequiredThe value in the search column for the record you wish to update
"555640"
table_id
string
RequiredThe ID of the table containing the record you wish to update
Output parameters
Optional output parameters
record
object
OptionalColumn values
record_id
string
OptionalRecord ID
record_url
string
OptionalRecord 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:
{
"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:
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.
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.