Get List Item

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

}

/**

 * Get List Item

 * Get one list item with its column values in `fields`. 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,

  item_id: string

) {

  const response = await fetch(

    `${graph}/sites/${site_id}/lists/${list_id}/items/${encodeURIComponent(item_id)}?$expand=fields`,

    {

      headers: {

        Authorization: `Bearer ${auth.token}`,

        Accept: "application/json",

      },

    }

  )

  if (!response.ok) {

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

  }

  return await response.json()

}