Update List Item

Published today

Update column values of a list item. `fields` maps column internal names to the new values; columns left out keep their value. Returns the item's full field set. Requires Sites.ReadWrite.All (a connection default).

Script ms_sharepoint Verified

Use in Windmill

The script

Submitted by hugo989 Typescript (fetch-only)

Verified 5 hours ago

All edits

Permalink

//native

const graph = "https://graph.microsoft.com/v1.0"

export type DynSelect_site_id = string

export async function site_id(auth: RT.MsSharepoint) {
  const response = await fetch(
    `${graph}/sites?search=*&$select=id,displayName,webUrl&$top=200`,
    {
      headers: {
        Authorization: `Bearer ${auth.token}`,
        Accept: "application/json",
      },
    }
  )
  if (!response.ok) {
    throw new Error(`${response.status} ${await response.text()}`)
  }
  const { value } = (await response.json()) as {
    value: { id: string; displayName: string; webUrl: string }[]
  }
  return value.map((s) => ({
    value: s.id,
    label: `${s.displayName} (${s.webUrl})`,
  }))
}

export type DynSelect_list_id = string

export async function list_id(auth: RT.MsSharepoint, site_id: string) {
  const response = await fetch(
    `${graph}/sites/${site_id}/lists?$select=id,displayName`,
    {
      headers: {
        Authorization: `Bearer ${auth.token}`,
        Accept: "application/json",
      },
    }
  )
  if (!response.ok) {
    throw new Error(`${response.status} ${await response.text()}`)
  }
  const { value } = (await response.json()) as {
    value: { id: string; displayName: string }[]
  }
  return value.map((l) => ({ value: l.id, label: l.displayName }))
}

/**
 * Update List Item
 * Update column values of a list item. `fields` maps column internal names to the new values; columns left out keep their value. Returns the item's full field set. Requires Sites.ReadWrite.All (a connection default).
 */
export async function main(
  auth: RT.MsSharepoint,
  site_id: DynSelect_site_id,
  list_id: DynSelect_list_id,
  item_id: string,
  fields: { [key: string]: any }
) {
  const response = await fetch(
    `${graph}/sites/${site_id}/lists/${list_id}/items/${encodeURIComponent(item_id)}/fields`,
    {
      method: "PATCH",
      headers: {
        Authorization: `Bearer ${auth.token}`,
        "Content-Type": "application/json",
        Accept: "application/json",
      },
      body: JSON.stringify(fields),
    }
  )

  if (!response.ok) {
    throw new Error(`${response.status} ${await response.text()}`)
  }

  return await response.json()
}


`1`	`//native`
`2`
`3`	`const graph = "https://graph.microsoft.com/v1.0"`
`4`
`5`	`export type DynSelect_site_id = string`
`6`
`7`	`export async function site_id(auth: RT.MsSharepoint) {`
`8`	`const response = await fetch(`
`9`	`${graph}/sites?search=*&$select=id,displayName,webUrl&$top=200`,
`10`	`{`
`11`	`headers: {`
`12`	Authorization: `Bearer ${auth.token}`,
`13`	`Accept: "application/json",`
`14`	`},`
`15`	`}`
`16`	`)`
`17`	`if (!response.ok) {`
`18`	throw new Error(`${response.status} ${await response.text()}`)
`19`	`}`
`20`	`const { value } = (await response.json()) as {`
`21`	`value: { id: string; displayName: string; webUrl: string }[]`
`22`	`}`
`23`	`return value.map((s) => ({`
`24`	`value: s.id,`
`25`	label: `${s.displayName} (${s.webUrl})`,
`26`	`}))`
`27`	`}`
`28`
`29`	`export type DynSelect_list_id = string`
`30`
`31`	`export async function list_id(auth: RT.MsSharepoint, site_id: string) {`
`32`	`const response = await fetch(`
`33`	`${graph}/sites/${site_id}/lists?$select=id,displayName`,
`34`	`{`
`35`	`headers: {`
`36`	Authorization: `Bearer ${auth.token}`,
`37`	`Accept: "application/json",`
`38`	`},`
`39`	`}`
`40`	`)`
`41`	`if (!response.ok) {`
`42`	throw new Error(`${response.status} ${await response.text()}`)
`43`	`}`
`44`	`const { value } = (await response.json()) as {`
`45`	`value: { id: string; displayName: string }[]`
`46`	`}`
`47`	`return value.map((l) => ({ value: l.id, label: l.displayName }))`
`48`	`}`
`49`
`50`	`/**`
`51`	`* Update List Item`
`52`	* Update column values of a list item. `fields` maps column internal names to the new values; columns left out keep their value. Returns the item's full field set. Requires Sites.ReadWrite.All (a connection default).
`53`	`*/`
`54`	`export async function main(`
`55`	`auth: RT.MsSharepoint,`
`56`	`site_id: DynSelect_site_id,`
`57`	`list_id: DynSelect_list_id,`
`58`	`item_id: string,`
`59`	`fields: { [key: string]: any }`
`60`	`) {`
`61`	`const response = await fetch(`
`62`	`${graph}/sites/${site_id}/lists/${list_id}/items/${encodeURIComponent(item_id)}/fields`,
`63`	`{`
`64`	`method: "PATCH",`
`65`	`headers: {`
`66`	Authorization: `Bearer ${auth.token}`,
`67`	`"Content-Type": "application/json",`
`68`	`Accept: "application/json",`
`69`	`},`
`70`	`body: JSON.stringify(fields),`
`71`	`}`
`72`	`)`
`73`
`74`	`if (!response.ok) {`
`75`	throw new Error(`${response.status} ${await response.text()}`)
`76`	`}`
`77`
`78`	`return await response.json()`
`79`	`}`
`80`