Get all rows that match the values provided for all column-name parameters used. If the value starts with a tilde ('~'), the rest of the value is treated as a regular expression to match and the matching is case insensitive. Otherwise, the column value must match the parameter value exactly.
Param name | Description |
---|---|
limit optional |
Sets an upper bound on the number of results to return. Defaults to 200. Validations:
|
offset optional |
Set the number of rows to skip before returning matching rows. Validations:
|
key optional |
The API key to use for authorization. |
associations_mode optional |
Set the amount of data to display about associations. Default is “full_info” for the show action and “count” for the index action. Validations:
|
id optional |
|
site_id optional |
Site at which measurement was taken. |
specie_id optional |
Species on which measurement was taken. |
citation_id optional |
Citation in which data was originally reported. |
cultivar_id optional |
Cultivar information, if any. |
treatment_id optional |
Experimental treatment identification. Required, can indicate observational study. |
date optional |
Date on which measurement was made. |
dateloc optional |
Level of confidence in date. See documentation. |
time optional |
Time at which measurement was taken. Sometimes necessary, e.g. for photosynthesis measurements. |
timeloc optional |
Level of confidence in time. |
mean optional |
Mean value of trait. |
n optional |
Number of experimental replicates used to estimate mean and statistical summary. |
statname optional |
Name of reported statistic. |
stat optional |
Value of reported statistic. |
notes optional |
|
created_at optional |
|
updated_at optional |
|
variable_id optional |
Links to information in variables table that describes trait being measured. |
user_id optional |
ID of user who entered data. |
checked optional |
accepts values [-1, 0, 1]. 0 is default, and means that data have not been checked. 1 indicates that the data have been checked and are correct, -1 indicates that data have been checked and found to be incorrect or suspicious, e.g. outside of the acceptab |
access_level optional |
Level of access required to view data. |
entity_id optional |
|
method_id optional |
|
date_year optional |
|
date_month optional |
|
date_day optional |
|
time_hour optional |
|
time_minute optional |
Get all information about the row with the matching id value. Information about associated rows (those reference by foreign keys) is shown as well.
Param name | Description |
---|---|
key optional |
The API key to use for authorization. |
associations_mode optional |
Set the amount of data to display about associations. Default is “full_info” for the show action and “count” for the index action. Validations:
|
Create new traits from the data specified in the posted data. Data about traits to be inserted can be supplied in either JSON (the default), CSV (using create.csv), or XML (using create.xml) format.
Param name | Description |
---|---|
key optional |
The apikey to use for authorization. |