Filtering Records

Certain endpoints allow you to filter your records according to certain attributes. Let's take a look at this process.

# Filtering injuries by created_at date

curl \
  https://go.daisybill.com/api/v1/patients/288941/injuries\?api_token=abcdefghijklmnopqrstuvwxyz123456 \
  -s \
  -G \
 -d created_at[gt]=12/15/2016 \
 -d created_at[lt]=12/23/2016

The above code will retrieve injuries that have a created_at date greater than (after) 12/15/2016 and less than (before) 12/23/2016. Other date filtering options are below:

Date Filtering Operators	Meaning
eq	"equal to"
gt	"greater than"
lt	"less than"
gteq	"greater than or equal to"
lteq	"less than or equal to"

These date filtering operators can be combined like in the example above, to provide more flexible queries. Only several endpoints allow this type of filtering at the moment. However check back soon, as this list is expected to increase. Please refer to the table below for endpoints that currently allow filtering:

Filterable endpoint URI	Description	Filterable Attributes
/billing_providers/:id/injuries	List Injuries for Billing Provider	claim_number, created_at, updated_at
/billing_providers/:id/remittances	List Remittances for Billing Provider	created_at, effective_date, deposited_on
/patients/:id/injuries	List Injuries for Patient	claim_number, created_at, updated_at
/billing_providers/:id/bills	List Bills for Billing Provider	created_at, updated_at, date_of_service
/billing_providers/:id/pharmacy_bills	List Pharmacy Bills for Billing Provider	created_at, updated_at, date_of_service
/billing_providers/:id/tasks	List Tasks for Billing Provider	completed, created_at, updated_at, due_date
/billing_providers	List of Billing Providers	created_at, updated_at
/claims_administrators	List of Claims Administrators	created_at, updated_at
/patients	List of Patients	created_at, updated_at
/billing_providers/:id/referring_providers	List Referring Providers for Billing Provider	created_at, updated_at
/billing_providers/:id/rendering_providers	List Rendering Providers for Billing Provider	created_at, updated_at
/billing_providers/:id/events	List Events	type, created_at
billing_providers/:id/requesting_physicians	List Requesting Physicians	created_at, updated_at, npi
billing_providers/:id/practice_contacts	List Practice Contacts	created_at, updated_at, email
billing_providers/:id/practice_locations	List Practice Locations	created_at, updated_at