Security News
tea.xyz Spam Plagues npm and RubyGems Package Registries
Tea.xyz, a crypto project aimed at rewarding open source contributions, is once again facing backlash due to an influx of spam packages flooding public package registries.
@twreporter/gsx2json
Advanced tools
Readme
One useful feature of Google Spreadsheets is the ability to access the data as JSON by using a particular feed URL. However, this is a bit fiddly to do, and the resulting JSON is pretty unreadable, with usable data buried deep inside objects.
This API connects to your spreadsheet and santizes the data, providing simple, readable JSON for you to use in your app.
npm install
node app
First, you must publish your spreadsheet to the web, using File -> Publish To Web
in your Google Spreadsheet.
You can then access your readable JSON API using the /api
endpoint. You can change this in app.js.
http://example.com/api?id=SPREADSHEET_ID&sheet=SHEET_NUMBER
This will update live with changes to the spreadsheet.
id (required): The ID of your document. This is the big long aplha-numeric code in the middle of your document URL.
sheet (optional): The number of the individual sheet you want to get data from. Your first sheet is 1, your second sheet is 2, etc. If no sheet is entered then 1 is the default.
q (optional): A simple query string. This is case insensitive and will add any row containing the string in any cell to the filtered result.
integers (optional - default: true): Setting 'integers' to false will return numbers as a string.
rows (optional - default: true): Setting 'rows' to false will return only column data.
columns (optional - default: true): Setting 'columns' to false will return only row data.
There are two sections to the returned data - Columns (containing the names of each column), and Rows (containing each row of data as an object.
{
columns: [
"Name",
"Age"
],
rows: [
{
name: "Nick",
age: "21"
},
{
name: "Chris ",
age: "27"
},
{
name: "Barry",
age: "67"
}
]
}
FAQs
Google Spreadsheet to JSON API app
The npm package @twreporter/gsx2json receives a total of 1 weekly downloads. As such, @twreporter/gsx2json popularity was classified as not popular.
We found that @twreporter/gsx2json demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 5 open source maintainers 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
Tea.xyz, a crypto project aimed at rewarding open source contributions, is once again facing backlash due to an influx of spam packages flooding public package registries.
Security News
As cyber threats become more autonomous, AI-powered defenses are crucial for businesses to stay ahead of attackers who can exploit software vulnerabilities at scale.
Security News
UnitedHealth Group disclosed that the ransomware attack on Change Healthcare compromised protected health information for millions in the U.S., with estimated costs to the company expected to reach $1 billion.