Skip to main content

Filtering and Sorting

The Kojo API offers several options for sorting and filtering data.

These parameters are often used in combination with pagination.

Sorting​

Records may be sorted using the orderBy and direction parameters. The Kojo API supports sorting for every field that is a string, numeric, or datetime type.

When using pagination, sorting will be done across all records in the database, prior to paginating the records.

Filter by field containing a string​

Many objects include string fields that can be used to filter query results. For specifics, see each object's details page in this documention.

Retrieving Records Based on Timestamp​

When integrating Kojo with another system, you may want to only get records that have been modified since your last sync. You can do this through the Kojo API by using the updatedAfter parameter. When using this parameter, Kojo will only return records that were created or updated after the specified time.

The updatedAfter parameter should be a UTC timestamp in the accepted date format. If the updatedAfter parameter is not provided, Kojo will return all records regardless of when they were last modified.