Edits history of script submission #20494 for ' Get Sheet (smartsheet)'

• bun

  Ap­pro­ved version

  Edit in Windmill

  Embed

  //native
  type Smartsheet = {
    token: string;
    baseUrl: string;
  };
  /**
   * Get Sheet
   * Gets a sheet in the format specified, based on the sheet Id.
   */
  export async function main(
    auth: Smartsheet,
    sheetId: string,
    accessApiLevel: string | undefined,
    include:
      | "attachments"
      | "columnType"
      | "crossSheetReferences"
      | "discussions"
      | "filters"
      | "filterDefinitions"
      | "format"
      | "ganttConfig"
      | "objectValue"
      | "ownerInfo"
      | "rowPermalink"
      | "source"
      | "writerInfo"
      | undefined,
    exclude:
      | "filteredOutRows"
      | "linkInFromCellDetails"
      | "linksOutToCellsDetails"
      | "nonexistentCells"
      | undefined,
    columnIds: string | undefined,
    filterId: string | undefined,
    ifVersionAfter: string | undefined,
    level: string | undefined,
    pageSize: string | undefined,
    page: string | undefined,
    paperSize:
      | "LETTER"
      | "LEGAL"
      | "WIDE"
      | "ARCHD"
      | "A4"
      | "A3"
      | "A2"
      | "A1"
      | "A0"
      | undefined,
    rowIds: string | undefined,
    rowNumbers: string | undefined,
    rowsModifiedSince: string | undefined,
  ) {
    const url = new URL(`${auth.baseUrl}/sheets/${sheetId}`);
    for (const [k, v] of [
      ["accessApiLevel", accessApiLevel],
      ["include", include],
      ["exclude", exclude],
      ["columnIds", columnIds],
      ["filterId", filterId],
      ["ifVersionAfter", ifVersionAfter],
      ["level", level],
      ["pageSize", pageSize],
      ["page", page],
      ["paperSize", paperSize],
      ["rowIds", rowIds],
      ["rowNumbers", rowNumbers],
      ["rowsModifiedSince", rowsModifiedSince],
    ]) {
      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