0

Get File or Folder

by
Published today

Get the metadata of a file or folder in a site's default document library, or in another of its libraries when `drive_id` is set: name, size, web URL, parent, timestamps and a short-lived `@microsoft.graph.downloadUrl`. `item` is an id, or a path from the drive root starting with "/" (e.g. `/Reports/2026/summary.xlsx`). `expand` takes relationships such as `listItem`, `permissions` or `thumbnails`. Requires Sites.Read.All (covered by the default Sites.ReadWrite.All).

Script ms_sharepoint Verified

The script

Submitted by hugo989 Typescript (fetch-only)
Verified 5 hours ago
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_drive_id = string
30

31
export async function drive_id(auth: RT.MsSharepoint, site_id: string) {
32
  const response = await fetch(
33
    `${graph}/sites/${site_id}/drives?$select=id,name`,
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; name: string }[]
46
  }
47
  return value.map((d) => ({ value: d.id, label: d.name }))
48
}
49

50
// The site's default document library, or the library given by drive_id
51
function driveUrl(site_id: string, drive_id: string | undefined) {
52
  return drive_id != null && drive_id !== ""
53
    ? `${graph}/drives/${encodeURIComponent(drive_id)}`
54
    : `${graph}/sites/${site_id}/drive`
55
}
56

57
// An item is addressed by its id, or by a path from the drive root starting with "/"
58
function ref(item: string | undefined) {
59
  if (item == null || item === "" || item === "/") return "root"
60
  if (!item.startsWith("/")) return `items/${encodeURIComponent(item)}`
61
  const path = item
62
    .replace(/\/+$/, "")
63
    .split("/")
64
    .map(encodeURIComponent)
65
    .join("/")
66
  return `root:${path}:`
67
}
68

69
/**
70
 * Get File or Folder
71
 * Get the metadata of a file or folder in a site's default document library, or in another of its libraries when `drive_id` is set: name, size, web URL, parent, timestamps and a short-lived `@microsoft.graph.downloadUrl`. `item` is an id, or a path from the drive root starting with "/" (e.g. `/Reports/2026/summary.xlsx`). `expand` takes relationships such as `listItem`, `permissions` or `thumbnails`. Requires Sites.Read.All (covered by the default Sites.ReadWrite.All).
72
 */
73
export async function main(
74
  auth: RT.MsSharepoint,
75
  site_id: DynSelect_site_id,
76
  item: string,
77
  select: string | undefined,
78
  expand: string | undefined,
79
  drive_id: DynSelect_drive_id | undefined
80
) {
81
  const drive = driveUrl(site_id, drive_id)
82
  const url = new URL(`${drive}/${ref(item)}`)
83
  if (select != null && select !== "") {
84
    url.searchParams.append("$select", select)
85
  }
86
  if (expand != null && expand !== "") {
87
    url.searchParams.append("$expand", expand)
88
  }
89

90
  const response = await fetch(url, {
91
    headers: {
92
      Authorization: `Bearer ${auth.token}`,
93
      Accept: "application/json",
94
    },
95
  })
96

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

101
  return await response.json()
102
}
103