Ctrl K

Update Comment

Published today

Replace the text of a comment the token's user wrote.

Script airtable Verified

Use in Windmill

The script

Submitted by hugo989 Typescript (fetch-only)

Verified 2 hours ago

All edits

Permalink

//native

export type DynSelect_base_id = string
export type DynSelect_table_id = string

// Dropdown of the bases the token can access.
export async function base_id(auth: RT.Airtable) {
  const options: { value: string; label: string }[] = []
  let offset: string | undefined = undefined
  do {
    const url = new URL("https://api.airtable.com/v0/meta/bases")
    if (offset) {
      url.searchParams.append("offset", offset)
    }
    const response = await fetch(url, {
      headers: {
        Authorization: `Bearer ${auth.apiKey}`,
        Accept: "application/json",
      },
    })
    if (!response.ok) {
      throw new Error(`${response.status} ${await response.text()}`)
    }
    const page = (await response.json()) as {
      bases: { id: string; name: string }[]
      offset?: string
    }
    options.push(...page.bases.map((b) => ({ value: b.id, label: b.name })))
    offset = page.offset
  } while (offset)
  return options
}

async function listTables(auth: RT.Airtable, base_id: string) {
  if (!base_id) {
    return []
  }
  const response = await fetch(
    `https://api.airtable.com/v0/meta/bases/${base_id}/tables`,
    {
      headers: {
        Authorization: `Bearer ${auth.apiKey}`,
        Accept: "application/json",
      },
    }
  )
  if (!response.ok) {
    throw new Error(`${response.status} ${await response.text()}`)
  }
  const { tables } = (await response.json()) as {
    tables: {
      id: string
      name: string
      fields: { id: string; name: string; type: string }[]
      views: { id: string; name: string }[]
    }[]
  }
  return tables
}

// Dropdown of the tables in the chosen base.
export async function table_id(auth: RT.Airtable, base_id: DynSelect_base_id) {
  return (await listTables(auth, base_id)).map((t) => ({
    value: t.id,
    label: t.name,
  }))
}

/**
 * Update Comment
 * Replace the text of a comment. Only the comment's author can edit it. Requires the data.recordComments:write scope.
 */
export async function main(
  auth: RT.Airtable,
  base_id: DynSelect_base_id,
  table_id: DynSelect_table_id,
  record_id: string,
  comment_id: string,
  text: string
) {
  const response = await fetch(
    `https://api.airtable.com/v0/${base_id}/${table_id}/${record_id}/comments/${comment_id}`,
    {
      method: "PATCH",
      headers: {
        Authorization: `Bearer ${auth.apiKey}`,
        "Content-Type": "application/json",
        Accept: "application/json",
      },
      body: JSON.stringify({ text }),
    }
  )
  if (!response.ok) {
    throw new Error(`${response.status} ${await response.text()}`)
  }

  return await response.json()
}


`1`	`//native`
`2`
`3`	`export type DynSelect_base_id = string`
`4`	`export type DynSelect_table_id = string`
`5`
`6`	`// Dropdown of the bases the token can access.`
`7`	`export async function base_id(auth: RT.Airtable) {`
`8`	`const options: { value: string; label: string }[] = []`
`9`	`let offset: string \| undefined = undefined`
`10`	`do {`
`11`	`const url = new URL("https://api.airtable.com/v0/meta/bases")`
`12`	`if (offset) {`
`13`	`url.searchParams.append("offset", offset)`
`14`	`}`
`15`	`const response = await fetch(url, {`
`16`	`headers: {`
`17`	Authorization: `Bearer ${auth.apiKey}`,
`18`	`Accept: "application/json",`
`19`	`},`
`20`	`})`
`21`	`if (!response.ok) {`
`22`	throw new Error(`${response.status} ${await response.text()}`)
`23`	`}`
`24`	`const page = (await response.json()) as {`
`25`	`bases: { id: string; name: string }[]`
`26`	`offset?: string`
`27`	`}`
`28`	`options.push(...page.bases.map((b) => ({ value: b.id, label: b.name })))`
`29`	`offset = page.offset`
`30`	`} while (offset)`
`31`	`return options`
`32`	`}`
`33`
`34`	`async function listTables(auth: RT.Airtable, base_id: string) {`
`35`	`if (!base_id) {`
`36`	`return []`
`37`	`}`
`38`	`const response = await fetch(`
`39`	`https://api.airtable.com/v0/meta/bases/${base_id}/tables`,
`40`	`{`
`41`	`headers: {`
`42`	Authorization: `Bearer ${auth.apiKey}`,
`43`	`Accept: "application/json",`
`44`	`},`
`45`	`}`
`46`	`)`
`47`	`if (!response.ok) {`
`48`	throw new Error(`${response.status} ${await response.text()}`)
`49`	`}`
`50`	`const { tables } = (await response.json()) as {`
`51`	`tables: {`
`52`	`id: string`
`53`	`name: string`
`54`	`fields: { id: string; name: string; type: string }[]`
`55`	`views: { id: string; name: string }[]`
`56`	`}[]`
`57`	`}`
`58`	`return tables`
`59`	`}`
`60`
`61`	`// Dropdown of the tables in the chosen base.`
`62`	`export async function table_id(auth: RT.Airtable, base_id: DynSelect_base_id) {`
`63`	`return (await listTables(auth, base_id)).map((t) => ({`
`64`	`value: t.id,`
`65`	`label: t.name,`
`66`	`}))`
`67`	`}`
`68`
`69`	`/**`
`70`	`* Update Comment`
`71`	`* Replace the text of a comment. Only the comment's author can edit it. Requires the data.recordComments:write scope.`
`72`	`*/`
`73`	`export async function main(`
`74`	`auth: RT.Airtable,`
`75`	`base_id: DynSelect_base_id,`
`76`	`table_id: DynSelect_table_id,`
`77`	`record_id: string,`
`78`	`comment_id: string,`
`79`	`text: string`
`80`	`) {`
`81`	`const response = await fetch(`
`82`	`https://api.airtable.com/v0/${base_id}/${table_id}/${record_id}/comments/${comment_id}`,
`83`	`{`
`84`	`method: "PATCH",`
`85`	`headers: {`
`86`	Authorization: `Bearer ${auth.apiKey}`,
`87`	`"Content-Type": "application/json",`
`88`	`Accept: "application/json",`
`89`	`},`
`90`	`body: JSON.stringify({ text }),`
`91`	`}`
`92`	`)`
`93`	`if (!response.ok) {`
`94`	throw new Error(`${response.status} ${await response.text()}`)
`95`	`}`
`96`
`97`	`return await response.json()`
`98`	`}`
`99`