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 |
|
|
city optional |
Nearest city to site. |
|
state optional |
If in the United States, state in which study is conducted. |
|
country optional |
|
|
mat optional |
Mean Annual Temperature (C) |
|
map optional |
Mean Annual Precipitation (mm) |
|
soil optional |
Soil type, as described in documentation. |
|
som optional |
Depreciated |
|
notes optional |
|
|
soilnotes optional |
|
|
created_at optional |
|
|
updated_at optional |
|
|
sitename optional |
|
|
greenhouse optional |
Boolean: indicates if study was conducted in a field (0) or greenhouse, pot, or growth chamber (1) |
|
user_id optional |
|
|
sand_pct optional |
|
|
clay_pct optional |
|
|
geometry optional |
|
|
time_zone 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:
|