Edits history of script submission #50 for ' Copy Worksheet (gsheets)'

deno

Approved version

type Gsheets = {
  token: string;
};
export async function main(
  gsheets_auth: Gsheets,
  sheet_id: string,
  spreadsheet_id_1: string,
  spreadsheet_id_2: string,
) {
  const token = gsheets_auth["token"];

  const COPY_TO_URL = `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheet_id_1}/sheets/${sheet_id}:copyTo`;

  const req = {
    destinationSpreadsheetId: spreadsheet_id_2,
  };

  const response = await fetch(COPY_TO_URL, {
    method: "POST",
    body: JSON.stringify(req),
    headers: {
      Authorization: "Bearer " + token,
      "Content-Type": "application/json",
    },
  });

  return await response.text();
}

Submitted by admin 257 days ago

deno


type Gsheets = {
  token: string;
};
export async function main(gsheets_auth: Gsheets,
    sheet_id: string,
    spreadsheet_id_1: string,
    spreadsheet_id_2: string,
) {

    const token = gsheets_auth["token"];

    const COPY_TO_URL =
        `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheet_id_1}/sheets/${sheet_id}:copyTo`;

    const req = {
        "destinationSpreadsheetId": spreadsheet_id_2,
    };

    const response = await fetch(COPY_TO_URL, {
        method: "POST",
        body: JSON.stringify(req),
        headers: {
            Authorization: "Bearer " + token,
            "Content-Type": "application/json",
        },
    });

    return await response.text();
}

Submitted by admin 260 days ago

deno

import * as wmill from "https://deno.land/x/windmill@v1.85.0/mod.ts";

export async function main(gsheets_auth: wmill.Resource<"gsheets">,
    sheet_id: string,
    spreadsheet_id_1: string,
    spreadsheet_id_2: string,
) {

    const token = gsheets_auth["token"];

    const COPY_TO_URL =
        `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheet_id_1}/sheets/${sheet_id}:copyTo`;

    const req = {
        "destinationSpreadsheetId": spreadsheet_id_2,
    };

    const response = await fetch(COPY_TO_URL, {
        method: "POST",
        body: JSON.stringify(req),
        headers: {
            Authorization: "Bearer " + token,
            "Content-Type": "application/json",
        },
    });

    return await response.text();
}

Submitted by adam186 389 days ago

deno

import * as wmill from "https://deno.land/x/windmill@v1.70.1/mod.ts";

export async function main(gsheets_auth: wmill.Resource<"gsheets">,
    sheet_id: string,
    spreadsheet_id_1: string,
    spreadsheet_id_2: string,
) {

    const token = gsheets_auth["token"];

    const COPY_TO_URL =
        `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheet_id_1}/sheets/${sheet_id}:copyTo`;

    const req = {
        "destinationSpreadsheetId": spreadsheet_id_2,
    };

    const response = await fetch(COPY_TO_URL, {
        method: "POST",
        body: JSON.stringify(req),
        headers: {
            Authorization: "Bearer " + token,
            "Content-Type": "application/json",
        },
    });

    return await response.text();
}

Submitted by adam186 424 days ago

deno

import * as wmill from "https://deno.land/x/windmill@v1.23.0/mod.ts";

export async function main(gsheets_auth: wmill.Resource<"gsheets">,
    sheet_id: string,
    spreadsheet_id_1: string,
    spreadsheet_id_2: string,
) {

    const token = gsheets_auth["token"];

    const COPY_TO_URL =
        `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheet_id_1}/sheets/${sheet_id}:copyTo`;

    const req = {
        "destinationSpreadsheetId": spreadsheet_id_2,
    };

    const response = await fetch(COPY_TO_URL, {
        method: "POST",
        body: JSON.stringify(req),
        headers: {
            Authorization: "Bearer " + token,
            "Content-Type": "application/json",
        },
    });

    return await response.text();
}

Submitted by rossmccrann 640 days ago

← Back to the list of replies