Edits history of script submission #68 for ' List Worksheets (gsheets)'

• deno

  Ap­pro­ved version

  Edit in Windmill

  Embed

  type Gsheets = {
    token: string;
  };
  export async function main(gsheets_auth: Gsheets, spreadsheetId: string) {
    const token = gsheets_auth["token"];
  
    const GET_WORKSHEET_URL = `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}?&fields=sheets.properties`;
  
    const response = await fetch(GET_WORKSHEET_URL, {
      method: "GET",
      headers: {
        Authorization: "Bearer " + token,
        "Content-Type": "application/json",
      },
    });
    const text = await response.json();
  
    let list = [];
    for (let i in text["sheets"]) {
      list.push({
        sheetId: text["sheets"][i]["properties"]["sheetId"],
        title: text["sheets"][i]["properties"]["title"],
      });
    }
  
    return list;
  }
  

  Submitted by admin 460 days ago

• deno

  Edit in Windmill

  Embed

  
  type Gsheets = {
    token: string;
  };
  export async function main(gsheets_auth: Gsheets,
      spreadsheetId: string,
  ) {
  
      const token = gsheets_auth["token"];
  
      const GET_WORKSHEET_URL =
          `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}?&fields=sheets.properties`;
  
  
      const response = await fetch(GET_WORKSHEET_URL, {
          method: "GET",
          headers: {
              Authorization: "Bearer " + token,
              "Content-Type": "application/json",
          },
      });
      const text = await response.json()
  
      let list = [];
      for (let i in text['sheets']) {
          list.push({ sheetId: text['sheets'][i]['properties']['sheetId'], title: text['sheets'][i]['properties']['title'] })
      }
  
      return list;
  }

  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,
  ) {
  
      const token = gsheets_auth["token"];
  
      const GET_WORKSHEET_URL =
          `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}?&fields=sheets.properties`;
  
  
      const response = await fetch(GET_WORKSHEET_URL, {
          method: "GET",
          headers: {
              Authorization: "Bearer " + token,
              "Content-Type": "application/json",
          },
      });
      const text = await response.json()
  
      let list = [];
      for (let i in text['sheets']) {
          list.push({ sheetId: text['sheets'][i]['properties']['sheetId'], title: text['sheets'][i]['properties']['title'] })
      }
  
      return list;
  }

  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,
  ) {
  
      const token = gsheets_auth["token"];
  
      const GET_WORKSHEET_URL =
          `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}?&fields=sheets.properties`;
  
  
      const response = await fetch(GET_WORKSHEET_URL, {
          method: "GET",
          headers: {
              Authorization: "Bearer " + token,
              "Content-Type": "application/json",
          },
      });
      const text = await response.json()
  
      let list = [];
      for (let i in text['sheets']) {
          list.push({ sheetId: text['sheets'][i]['properties']['sheetId'], title: text['sheets'][i]['properties']['title'] })
      }
  
      return list;
  }

  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,
  ) {
  
      const token = gsheets_auth["token"];
  
      const GET_WORKSHEET_URL =
          `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}?&fields=sheets.properties`;
  
  
      const response = await fetch(GET_WORKSHEET_URL, {
          method: "GET",
          headers: {
              Authorization: "Bearer " + token,
              "Content-Type": "application/json",
          },
      });
      const text = await response.json()
  
      let list = [];
      for (let i in text['sheets']) {
          list.push({ sheetId: text['sheets'][i]['properties']['sheetId'], title: text['sheets'][i]['properties']['title'] })
      }
  
      return list;
  }

  Submitted by rossmccrann 842 days ago