3
| Table of Contents | ||||
|---|---|---|---|---|
|
...
Importantly, this avoids outside developers learning OpenSpecimen APIs and writing custom programs. Writing programs need a lot of programming efforts, can be a maintenance overhead in the long run, and can be error-prone.
Overview
| Gliffy | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Notes/References
...
Refer to Reporting to learn how to create queries.
...
Refer to Query Results view on including columns and renaming column header names.
...
Refer to Scheduling Queries on how to schedule queries.
...
Exporting data
Create a Query using OpenSpecimen Query module. Reference Reporting
Include all the fields needed in the data warehouse. Reference Query Results view.
Save the query
Create a Scheduled Job for the saved query using the Jobs module. Select frequency of job run as nightly, weekly, monthly, etc. Reference Scheduling Queries
OpenSpecimen creates a CSV file every time the job is run at the scheduled frequency.
Fetching data Via APIs - (Prefered Option)
Refer to https://openspecimen.atlassian.net/l/c/xi6pnzz0 on how to run the scheduled jobs and download the data output via API.
How to query for records that have been added/updated since the last run?
...