Edits history of script submission #69 for ' Clear Row (gsheets)'

• deno

  Ap­pro­ved version

  Edit in Windmill

  Embed

  type Gsheets = {
    token: string;
  };
  export async function main(
    gsheets_auth: Gsheets,
    spreadsheetId: string,
    sheetId: number,
    start_index: number,
    end_index: number,
  ) {
    const token = gsheets_auth["token"];
  
    const DELETE_ROWS_URL = `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}:batchUpdate`;
  
    const body = {
      requests: [
        {
          deleteDimension: {
            range: {
              sheetId: sheetId,
              dimension: "ROWS",
              startIndex: start_index,
              endIndex: end_index,
            },
          },
        },
      ],
    };
    const response = await fetch(DELETE_ROWS_URL, {
      method: "POST",
      body: JSON.stringify(body),
      headers: {
        Authorization: "Bearer " + token,
        "Content-Type": "application/json",
      },
    });
    const text = await response.json();
  
    return "Rows deleted.";
  }
  

  Submitted by admin 460 days ago

• deno

  Edit in Windmill

  Embed

  
  type Gsheets = {
    token: string;
  };
  export async function main(gsheets_auth: Gsheets,
      spreadsheetId: string,
      sheetId: number,
      start_index: number,
      end_index: number
  ) {
  
      const token = gsheets_auth["token"];
  
      const DELETE_ROWS_URL =
          `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}:batchUpdate`;
  
      const body = {
          "requests": [
              {
                  "deleteDimension": {
                      "range": {
                          "sheetId": sheetId,
                          "dimension": "ROWS",
                          "startIndex": start_index,
                          "endIndex": end_index
                      }
                  }
              },
          ],
      };
      const response = await fetch(DELETE_ROWS_URL, {
          method: "POST",
          body: JSON.stringify(body),
          headers: {
              Authorization: "Bearer " + token,
              "Content-Type": "application/json",
          },
      });
      const text = await response.json()
  
      return 'Rows deleted.';
  }

  Submitted by admin 463 days ago

• deno

  Edit in Windmill

  Embed

  import * as wmill from "https://deno.land/x/windmill@v1.85.0/mod.ts";
  
  export async function main(gsheets_auth: wmill.Resource<"gsheets">,
      spreadsheetId: string,
      sheetId: number,
      start_index: number,
      end_index: number
  ) {
  
      const token = gsheets_auth["token"];
  
      const DELETE_ROWS_URL =
          `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}:batchUpdate`;
  
      const body = {
          "requests": [
              {
                  "deleteDimension": {
                      "range": {
                          "sheetId": sheetId,
                          "dimension": "ROWS",
                          "startIndex": start_index,
                          "endIndex": end_index
                      }
                  }
              },
          ],
      };
      const response = await fetch(DELETE_ROWS_URL, {
          method: "POST",
          body: JSON.stringify(body),
          headers: {
              Authorization: "Bearer " + token,
              "Content-Type": "application/json",
          },
      });
      const text = await response.json()
  
      return 'Rows deleted.';
  }

  Submitted by adam186 592 days ago

• deno

  Edit in Windmill

  Embed

  import * as wmill from "https://deno.land/x/windmill@v1.70.1/mod.ts";
  
  export async function main(gsheets_auth: wmill.Resource<"gsheets">,
      spreadsheetId: string,
      sheetId: number,
      start_index: number,
      end_index: number
  ) {
  
      const token = gsheets_auth["token"];
  
      const DELETE_ROWS_URL =
          `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}:batchUpdate`;
  
      const body = {
          "requests": [
              {
                  "deleteDimension": {
                      "range": {
                          "sheetId": sheetId,
                          "dimension": "ROWS",
                          "startIndex": start_index,
                          "endIndex": end_index
                      }
                  }
              },
          ],
      };
      const response = await fetch(DELETE_ROWS_URL, {
          method: "POST",
          body: JSON.stringify(body),
          headers: {
              Authorization: "Bearer " + token,
              "Content-Type": "application/json",
          },
      });
      const text = await response.json()
  
      return 'Rows deleted.';
  }

  Submitted by adam186 626 days ago

• deno

  Edit in Windmill

  Embed

  import * as wmill from "https://deno.land/x/windmill@v1.24.1/mod.ts";
  
  export async function main(gsheets_auth: wmill.Resource<"gsheets">,
      spreadsheetId: string,
      sheetId: number,
      start_index: number,
      end_index: number
  ) {
  
      const token = gsheets_auth["token"];
  
      const DELETE_ROWS_URL =
          `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}:batchUpdate`;
  
      const body = {
          "requests": [
              {
                  "deleteDimension": {
                      "range": {
                          "sheetId": sheetId,
                          "dimension": "ROWS",
                          "startIndex": start_index,
                          "endIndex": end_index
                      }
                  }
              },
          ],
      };
      const response = await fetch(DELETE_ROWS_URL, {
          method: "POST",
          body: JSON.stringify(body),
          headers: {
              Authorization: "Bearer " + token,
              "Content-Type": "application/json",
          },
      });
      const text = await response.json()
  
      return 'Rows deleted.';
  }

  Submitted by rossmccrann 842 days ago