Edits history of script submission #20492 for ' Get Row (smartsheet)'

  • bun
    One script reply has been approved by the moderators
    Ap­pro­ved
    //native
    type Smartsheet = {
      token: string;
      baseUrl: string;
    };
    /**
     * Get Row
     * Gets the row specified in the URL.
     */
    export async function main(
      auth: Smartsheet,
      sheetId: string,
      rowId: string,
      accessApiLevel: string | undefined,
      include: "columns" | "filters" | undefined,
      exclude:
        | "filteredOutRows"
        | "linkInFromCellDetails"
        | "linksOutToCellsDetails"
        | "nonexistentCells"
        | undefined,
      level: string | undefined,
    ) {
      const url = new URL(
        `${auth.baseUrl}/sheets/${sheetId}/rows/${rowId}`,
      );
      for (const [k, v] of [
        ["accessApiLevel", accessApiLevel],
        ["include", include],
        ["exclude", exclude],
        ["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