...
`sort(+|-propertyA,+|-propertyB,...) ` - Sorts by the given property/properties in order specified by the prefix (+ for ascending, - for descending)
`select(property,property,...) ` - Trims each object down to the set of properties defined in the arguments
`limit(numberOfRecords,offset) ` - Returns the given range of objects from the result set (numberOfRecords = how many records should be returned, offset = how many records should be skipped; to return a stream of all records call 'limit(-1)'.)
Cacheing
Cacheing can be used to help improve query return reliability and speed up the return of data from a dataset. This is done by adding the term cache=true
Code Block |
---|
cache=true |
. An example of that being used is shown below:
https://api.usmart.io/org/92610836-6c2b-4a26-a0a0-b903bde0dc46/4dd7a850-858c-4e65-a456-772f76e93ec1/latest/urql?limit(-1)>(Timestamp,Date1)&cache=true
Others
`format(ouputFormat) ` - Sets the output format - valid values are 'json' (default) and 'csv' (comma separated text file).
...
Page Properties | ||
---|---|---|
| ||
|