Pagination & Filtering

All list endpoints use cursor-based pagination and support a consistent filter syntax.

Pagination

Dalil uses cursor-based pagination. Unlike page numbers, cursors stay consistent even when records are added or removed between requests.

Parameter	Type	Default	Description
`limit`	`number`	60	Records per page
`starting_after`	`UUID`	—	Return records after this record ID
`ending_before`	`UUID`	—	Return records before this record ID

# Page 1
curl -G "https://app.usedalil.ai/rest/people" \
  -H "Authorization: Bearer YOUR_API_KEY" \
  --data-urlencode "limit=20" \
  --data-urlencode "order_by=createdAt[DescNullsLast]"

# Page 2 pass the last record's ID from page 1
curl -G "https://app.usedalil.ai/rest/people" \
  -H "Authorization: Bearer YOUR_API_KEY" \
  --data-urlencode "limit=20" \
  --data-urlencode "order_by=createdAt[DescNullsLast]" \
  --data-urlencode "starting_after=550e8400-e29b-41d4-a716-446655440000"

💡 When the response returns fewer records than your limit, you have reached the last page.

Filtering

Use the filter query parameter to narrow results. Multiple conditions are comma-separated and applied with AND logic.

Syntax

filter=field[comparator]:value

💡 Filter strings contain [ ] : characters that break raw URLs. Always URL-encode: use curl -G --data-urlencode "filter=..." or your HTTP library's query param builder.

Comparators

Comparator	Description	Example
`eq`	Exact match	`jobTitle[eq]:Engineer`
`not`	Not equal	`stage[not]:CLOSED_LOST`
`in`	Value in list	`id[in]:[uuid1,uuid2]`
`not_in`	Value not in list	`stage[not_in]:[CLOSED_WON,CLOSED_LOST]`
`ilike`	Case-insensitive contains	`jobTitle[ilike]:engineer`
`gt`	Greater than	`employees[gt]:50`
`gte`	Greater than or equal	`createdAt[gte]:2026-01-01T00:00:00Z`
`lt`	Less than	`employees[lt]:100`
`lte`	Less than or equal	`closeDate[lte]:2026-06-30T23:59:59Z`
`is`	NULL check	`companyId[is]:NULL`
`is_not`	NOT NULL check	`companyId[is_not]:NULL`

Sorting

Use order_by=field[Direction]. Append NullsLast or NullsFirst to control null placement.

order_by=createdAt[DescNullsLast]     # newest first
order_by=name[AscNullsLast]           # alphabetical, nulls at end
order_by=closeDate[AscNullsFirst]     # soonest close date first