API Examples


The purpose of this page is to show common examples of using the Validere API.

Incremental Load

For some data warehousing applications, incremental load is the preferred activity to update a database, as it is more efficient than a full load. The lab_results API has parameters to enable this in 2 ways:

  1. Using the created_after and updated_after parameters to check for any newly added or recently modified data after a specified date. The date must be provided in ISO 8601 format.
  2. Using the from and until parameters to check for samples taken during a specified time period. 

Connecting Tests to Facilities

The lab_results API provides the parent stream associated with tests and samples. To add more context to the sample, the streams API can be used by including the stream ID in the query to pull additional information such as the phase (ex. gas or liquid), product type (ex. natural gas or condensate), or facility geography and regulatory codes.