Many customers want to pull data out of OpenSpecimen into an external data warehouse. You can achieve this in two ways:
This page explains the option to use the OpenSpecimen Query interface to achieve this option. This option is easy to achieve.
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.
How to query for records that have been added/updated since the last run?
You may not want all data in every run. To pull only the data that has changed since the last query run, you can use the fields “Update Time” field within Participant, Visit, and Specimen objects in the query UI.
To retrieve specimens modified in the last 60 minutes, use the temporal filter given below: