Querying results

Endpoints tagged with: simple-query support simple conditions on all columns in the answer unless otherwise specified in the endpoint description.

Searching

QueryDetails
./api/ani/scolari?ascID=21Returns only school years where ascID is equal to 21
./api/ani/scolari?ascID=<21Returns only school years where ascID less than 21
./api/ani/scolari?ascID=>21Returns only school years where ascID greater than 21
./api/ani/scolari?ascID=!21Returns only school years where ascID is not 21
./api/ani/scolari?ascID=[21,22,23]Returns only school years where ascID is 21, 22 or 23.
./api/ani/scolari?ascNume=2017*Returns only school years where ascNune starts with 2017 (LIKE '2017%')
./api/ani/scolari?ascNume=*2017Returns only school years where ascNume ends in 2017 (LIKE '%2017')
./api/ani/scolari?ascNume=*2017*Returns only school years where ascNume contains 2017 (LIKE '%2017%')

Ordering

QueryDetails
./api/ani/scolari?_order=<ascIDReturns results with ascID in descending order.
./api/ani/scolari?_order=>ascIDReturns results with ascID in ascending order.
./api/ani/scolari?_order=>ascID,<ascNumeReturns the results with acID in ascending order and ascNume descending.

Pagination

QueryDetails
./api/mesaje?_limit=50&_offset=0Divides the results into pages of 15 items and returns page 2.
./api/mesaje?_limit=-1Returns results with limit = 1844674407370955169.