Idea #6319
closed
Add API endpoint for backend tables
Added by Abram Connelly over 9 years ago.
Updated about 5 years ago.
Description
Add an API endpoint to serve the backend public facing database tables. These include:
- users
- medications
- user_files
- datasets
- immunizations
- conditions
- demographic
Each of these should have at the least some RESTful API access point to download a csv/tsv file. For example, something like 'https://my.pgp-hms.org/download/users.tsv'.
- Category set to Publishing
6319-csv-exports @ 81aeac2 adds /exports/phrccr_lab_test_results.csv. If this approach looks OK, I can add more CSVs along the same lines.
It takes about 50 seconds to download 200K rows from a PGP-HMS-sized database. Not great, but surely better than scraping. I'm hoping/expecting this export will be the slowest of the lot.
- Status changed from New to In Progress
- Assigned To set to Tom Clegg
- Target version set to 2015-07-08 sprint
- Story points changed from 2.0 to 1.0
At
3f83921 with
- /exports/users.csv
- /exports/datasets.csv
- /exports/user_files.csv
- /exports/phrccr_lab_test_allergies.csv
- /exports/phrccr_lab_test_conditions.csv
- /exports/phrccr_lab_test_demographics.csv
- /exports/phrccr_lab_test_immunizations.csv
- /exports/phrccr_lab_test_results.csv
- /exports/phrccr_medications.csv
- /exports/phrccr_procedures.csv
master at 6fa6b0f - 574 tests, 1232 assertions, 252 failures, 45 errors
6319-csv-exports at 3f83921 - 585 tests, 1270 assertions, 245 failures, 46 errors
- Target version changed from 2015-07-08 sprint to 2015-07-22 sprint
- Story points changed from 1.0 to 0.5
- Status changed from In Progress to Resolved
- Target version deleted (
2015-07-22 sprint)
Also available in: Atom
PDF
Updated by 
Updated by 
Updated by