WBEA Integrated Data API
This API is intended to be used to supply data files to a more user friendly page located on wbea.org.
The database contains sample data. The sample data was collected from various WBEA Programs.
api/catalog/{name}
Details
GET
Returns a catalog table of the name requested.
| Parameter | Description |
|---|---|
| Name | samplecounts, samplelocationcounts |
api/lut/{table}
Details
GET
Returns the lookup table(lut) at the end of the url.
| Parameter | Description |
|---|---|
| table | sample_type,location,unit,parameter,mm,lab,sample_use_type |
api/search
Details
POST
Accepts a string of json. Be sure to set application/json in your POST header. Returns a file with data based on the request parameters. If no data is found returns a 400 Bad Request.
Response sets content-type:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
For a sample to be selected its start and end dates must be contained in the search range.
| Parameter | Description |
|---|---|
| start_range | The start date of the range to search. Use format of YYYY-MM-DD |
| end_range | The end date of the range to search. Use format of YYYY-MM-DD |
| sample_type | The integer id of the sample type corresponding to the sample_type table. |
| locations | Optional. A list of integer ids for the locations |