Edits history of script submission #20481 for ' Get Column (smartsheet)'

  • bun
    One script reply has been approved by the moderators
    Ap­pro­ved
    //native
    type Smartsheet = {
      token: string;
      baseUrl: string;
    };
    /**
     * Get Column
     * 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).
     */
    export async function main(
      auth: Smartsheet,
      sheetId: string,
      columnId: string,
      level: string | undefined,
    ) {
      const url = new URL(
        `${auth.baseUrl}/sheets/${sheetId}/columns/${columnId}`,
      );
      for (const [k, v] of [["level", level]]) {
        if (v !== undefined && v !== "" && k !== undefined) {
          url.searchParams.append(k, v);
        }
      }
      const response = await fetch(url, {
        method: "GET",
        headers: {
          Authorization: "Bearer " + auth.token,
        },
        body: undefined,
      });
      if (!response.ok) {
        const text = await response.text();
        throw new Error(`${response.status} ${text}`);
      }
      return await response.json();
    }
    

    Submitted by hugo697 235 days ago