Security News
CISA Brings KEV Data to GitHub
CISA's KEV data is now on GitHub, offering easier access, API integration, commit history tracking, and automated updates for security teams and researchers.
gsheet-object
Advanced tools
yarn add gsheet-object googleapis
You first need to set an environment variable to your sheet ID: SPREADSHEET_ID=YOUR SHEET ID
Let's use a sheet called Cities, with the following data:
City | Country Name |
---|---|
Paris | France |
London | UK |
interface ICity {
city: string;
countryName: string;
}
async function demo() {
const sheet = await GoogleSheet.load<ICity>("Cities");
const cities = await sheet.getData();
const paris = cities[0]; // { city: 'Paris', countryName: 'France', _row: 1 }
const indexed = await sheet.getIndexed(x => x.city);
console.log(indexed["Paris"]); // { city: 'Paris', countryName: 'France', _row: 1 }
const pairs = await sheet.getPairs(
x => x.city,
x => x.countryName
);
console.log(pairs["Paris"]); // France
await sheet.append({
city: "Toulouse",
countryName: "France",
});
// Update line
await sheet.update(paris, "countryName", "USA");
// or
await sheet.update(0, "countryName", "USA");
await sheet.delete(paris);
}
FAQs
## Install
We found that gsheet-object demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
CISA's KEV data is now on GitHub, offering easier access, API integration, commit history tracking, and automated updates for security teams and researchers.
Security News
Opengrep forks Semgrep to preserve open source SAST in response to controversial licensing changes.
Security News
Critics call the Node.js EOL CVE a misuse of the system, sparking debate over CVE standards and the growing noise in vulnerability databases.