search

GSA / innovation.gov

Deprecated - This project repo is no longer being maintained.
https://innovation.gov
14 stars 14 forks source link

Adding table and data #84

Closed imuchnik closed 5 years ago

imuchnik commented 5 years ago

First stab at bringing the spreadsheet data and displaying in a table with filters and sortable columns.

contolini commented 5 years ago

Thanks @imuchnik! I'll continue your excellent work.

It looks like this PR reads from a static JSON file that was created by manually exporting the spreadsheet. Question for @atrain440: The goal is to dynamically pull in data from the spreadsheet, so that any edits to the spreadsheet are reflected on the webpage in real-time, correct?

afomi commented 5 years ago

fwiw, I've recently been pushing/pulling data to/from Google Sheets via Ruby scripts.

Pulling straight from Google Sheets API on each request may make sense, depending on traffic, and how often the Sheet is updated. Otherwise, it'd be quite easy to standup a script to update that static .json on a cron schedule - making it a bit more dynamic.

contolini commented 5 years ago

Good call @afomi, it probably doesn't make sense to hammer their API on every page load if the sheet doesn't get updated very often.