0

Get Column

by
Published Oct 17, 2025

Gets definitions for the column specified in the URL. **NOTE:** If you need to see the values of individual cells within the column, use [Get Sheet](#operation/getSheet) or [Get Row](#operation/row-get).

Script smartsheet Verified

The script

Submitted by hugo697 Bun
Verified 235 days ago
1
//native
2
type Smartsheet = {
3
  token: string;
4
  baseUrl: string;
5
};
6
/**
7
 * Get Column
8
 * Gets definitions for the column specified in the URL. **NOTE:** If you need to see the values of individual cells within the column, use [Get Sheet](#operation/getSheet) or [Get Row](#operation/row-get).
9
 */
10
export async function main(
11
  auth: Smartsheet,
12
  sheetId: string,
13
  columnId: string,
14
  level: string | undefined,
15
) {
16
  const url = new URL(
17
    `${auth.baseUrl}/sheets/${sheetId}/columns/${columnId}`,
18
  );
19
  for (const [k, v] of [["level", level]]) {
20
    if (v !== undefined && v !== "" && k !== undefined) {
21
      url.searchParams.append(k, v);
22
    }
23
  }
24
  const response = await fetch(url, {
25
    method: "GET",
26
    headers: {
27
      Authorization: "Bearer " + auth.token,
28
    },
29
    body: undefined,
30
  });
31
  if (!response.ok) {
32
    const text = await response.text();
33
    throw new Error(`${response.status} ${text}`);
34
  }
35
  return await response.json();
36
}
37