Clarabase
  • Welcome
  • Introduction
    • What is Clarabase?
  • Basics
    • Creating a Resource (Schema)
    • Making Requests
      • Pagination & Filtering
    • Code Generation
    • Data Viewer
  • Database Guides
    • Postgres
    • MySQL
    • MongoDB
    • Oracle
    • Firestore
    • SQL Server
  • Guides
    • Filtering on user data
    • Adding a Clarabase API to your projects
Powered by GitBook
On this page
  1. Basics
  2. Making Requests

Pagination & Filtering

In your GET /items requests, you can pass in pagination params: page (aka offset) and pageSize (aka limit). For example:

GET /posts?page=1&pageSize=30

Note: default pageis 1 and the default pageSizeis 25. There's a max pageSize of 200.

Filtering

You can filter your results using the qparam and the filtering DML. The basic format is: "?q=<field_name>[operator]<value>;<field_name>[operator]<value>`

For example, let's say we want to filter a "BlogPosts" resource where it has at least 3 comments and more than 5 likes. Our request would be: `GET /blogposts?q=comments>=3;likes>4`

Supported operators are: `<`, `<=`, `=`, `>=`, and `>`.

PreviousMaking RequestsNextCode Generation

Last updated 3 months ago