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 480 days ago
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 483 days ago
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 612 days ago
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 647 days ago
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 862 days ago