Get Sheet

//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();

}