POST https://www.activityinfo.org/resources/query/rows
application/json
| object |
| formId |
string |
|
required |
| columns |
array[object] |
|
required |
| id |
string |
The id of the column. This is used to identify the column in the resulting table. |
required |
| formula |
string |
|
required |
| filter |
string |
A boolean-valued formula to filter the records included in this query. |
optional |
| sort |
array[object] |
|
required |
| field |
string |
The field on which to sort. |
required |
| dir |
string |
The direction to sort. Values:
-
ASC
-
DESC
|
required |
| filterSets |
array[object] |
Zero or more set-based filters to apply. Resulting rows must match both the {@link #filter} formula, if provided, and all of the provided filterSets. |
required |
| columnFormula |
string |
|
required |
| values |
array[string] |
|
required |
| Status Code |
Error Code |
Description |
| 401 |
AUTHENTICATION_REQUIRED |
The request must be authenticated |