List Columns

Published today

List a list's columns. A column's `name` is the internal name to use as a key in list item `fields` and in filters (`fields/<name>`); `displayName` is what the SharePoint UI shows. Requires Sites.Read.All (covered by the default Sites.ReadWrite.All).

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 }))
}

/**
 * List Columns
 * List a list's columns. A column's `name` is the internal name to use as a key in list item `fields` and in filters (`fields/<name>`); `displayName` is what the SharePoint UI shows. Requires Sites.Read.All (covered by the default Sites.ReadWrite.All).
 */
export async function main(
  auth: RT.MsSharepoint,
  site_id: DynSelect_site_id,
  list_id: DynSelect_list_id
) {
  const response = await fetch(
    `${graph}/sites/${site_id}/lists/${list_id}/columns`,
    {
      headers: {
        Authorization: `Bearer ${auth.token}`,
        Accept: "application/json",
      },
    }
  )

  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`	`* List Columns`
`52`	* List a list's columns. A column's `name` is the internal name to use as a key in list item `fields` and in filters (`fields/<name>`); `displayName` is what the SharePoint UI shows. Requires Sites.Read.All (covered by the default Sites.ReadWrite.All).
`53`	`*/`
`54`	`export async function main(`
`55`	`auth: RT.MsSharepoint,`
`56`	`site_id: DynSelect_site_id,`
`57`	`list_id: DynSelect_list_id`
`58`	`) {`
`59`	`const response = await fetch(`
`60`	`${graph}/sites/${site_id}/lists/${list_id}/columns`,
`61`	`{`
`62`	`headers: {`
`63`	Authorization: `Bearer ${auth.token}`,
`64`	`Accept: "application/json",`
`65`	`},`
`66`	`}`
`67`	`)`
`68`
`69`	`if (!response.ok) {`
`70`	throw new Error(`${response.status} ${await response.text()}`)
`71`	`}`
`72`
`73`	`return await response.json()`
`74`	`}`
`75`