PULLFIRST[THE RECORD]

Filtering

Gridify syntax for filtering, sorting, and combining conditions on list endpoints.

List endpoints accept filter and orderBy query parameters using Gridify syntax. The operators and examples below apply uniformly to paged endpoints on the API.

Operators

OperatorMeaningExample
=Equalsstatus=Issued
!=Not equalsstatus!=Expired
=*Containsname=*Roofing*
^Starts withlicenseNumber^BC
$Ends withname$LLC
> < >= <=ComparisonexpirationDate>2025-01-01
,ANDcity=Minneapolis,status=Issued
|ORstatus=Revoked|status=Suspended
/iCase-insensitivename=*roofing/i

Examples

Active contractors in Minneapolis:

filter=city=Minneapolis,status=Issued

Enforcement actions with penalties over $10k, newest first:

filter=penaltyAmount>10000&orderBy=orderDate desc

OSHA inspections with willful violations at roofing companies:

filter=establishmentName=*Roofing*,willfulViolations>0

Sorting

orderBy takes a field name with optional asc or desc:

orderBy=expirationDate desc

Chain sorts with commas:

orderBy=status asc,expirationDate desc

Pagination

Paged endpoints accept page and pageSize. Defaults are page 1 at 25 records; the maximum pageSize is 100. The response envelope carries totalCount and totalPages.