Examples
People search
Listing people by nameCompanies search
Listing companies by nameDeals search
Listing deals by nameFilter syntax
The filter syntax allows you to specify conditions for the fields you want to filter by. The syntax is as follows:?filter[<field>][<operator>]=<value>
Where:
<field>
is the field we want to filter on<operator>
is the operation we want to perform<value>
is the value we’re filtering against
Operators
The following operators are available for filtering:Operator | Meaning | Applicable to |
---|---|---|
eq | field is equal to the value | Text, numbers, and dates fields |
not_eq | field is not equal to the value | Text, numbers, and dates fields |
gt | field is greater than the value | Numbers and dates fields |
lt | field is less than the value | Numbers and dates fields |
like | field matches the value | Text |
not_like | field does not match the value | Text |
in | field is in the list of values | Reference fields |
not_in | field is not in the list of values | Reference fields |
empty | field is empty | All fields |
not_empty | field is not empty | All fields |
Filterable fields
Filterable fields for people
Field | Usage | Supported operators |
---|---|---|
fullName | ?filter[fullName][like]=John | eq , not_eq , like , not_like , empty , not_empty |
firstName | ?filter[firstName][eq]=John | eq , not_eq , like , not_like ,empty , not_empty |
lastName | ?filter[lastName][not_eq]=Doe | eq , not_eq , like , not_like ,empty , not_empty |
jobTitle | ?filter[jobTitle][like]=Developer | eq , not_eq , like , not_like ,empty , not_empty |
birthday | ?filter[birthday][gt]=1990-01-01 | eq , not_eq , gt , lt , empty , not_empty |
description | ?filter[description][like]=team player | eq , not_eq , like , not_like ,empty , not_empty |
emails | ?filter[emails][like]=@folk.app | eq , not_eq , like , not_like ,empty , not_empty |
phones | ?filter[phones][eq]=+1234567890 | eq , not_eq , like , not_like ,empty , not_empty |
addresses | ?filter[addresses][not_like]=Paris | eq , not_eq , like , not_like ,empty , not_empty |
urls | ?filter[urls][not_eq]=https://example.com | eq , not_eq , like , not_like ,empty , not_empty |
companies | ?filter[companies][in][id]=com_c5993dec-0375-407e-9e0a-a310d39f65bd | in , not_in , empty , not_empty |
groups | ?filter[groups][in][id]=grp_c5993dec-0375-407e-9e0a-a310d39f65bd | in , not_in , empty , not_empty |
createdAt (day precision) | ?filter[createdAt][gt]=2020-01-01 | eq , not_eq , gt , lt , empty , not_empty |
createdBy | ?filter[createdBy][in][email]=john@folk.app&filter[createdBy][in][id]=usr_c5993dec-0375-407e-9e0a-a310d39f65bd | in , not_in , empty , not_empty |
customFieldValues.{groupId}.Text | ?filter[customFieldValues.grp_c5993dec-0375-407e-9e0a-a310d39f65bd.Text][like]=team player | eq , not_eq , like , not_like ,empty , not_empty |
customFieldValues.{groupId}.Date | ?filter[customFieldValues.grp_c5993dec-0375-407e-9e0a-a310d39f65bd.Date][gt]=2020-01-01 | eq , not_eq , gt , lt , empty , not_empty |
customFieldValues.{groupId}.Number | ?filter[customFieldValues.grp_c5993dec-0375-407e-9e0a-a310d39f65bd.Number][lt]=200 | eq , not_eq , gt , lt , empty , not_empty |
customFieldValues.{groupId}.Status | ?filter[customFieldValues.grp_c5993dec-0375-407e-9e0a-a310d39f65bd.Status][in]=In Progress | in , not_in , empty , not_empty |
customFieldValues.{groupId}.Tags | ?filter[customFieldValues.grp_c5993dec-0375-407e-9e0a-a310d39f65bd.Tags][in]=B2B&filter[customFieldValues.grp_c5993dec-0375-407e-9e0a-a310d39f65bd.Tags][in]=B2C | in , not_in , empty , not_empty |
customFieldValues.{groupId}.Relationships | ?filter[customFieldValues.grp_c5993dec-0375-407e-9e0a-a310d39f65bd.Relationships][in][id]=per_a858d1bd-19d3-486d-87a4-c3b13d5b9a99 | in , not_in , empty , not_empty |
customFieldValues.{groupId}.Assign | ?filter[customFieldValues.grp_c5993dec-0375-407e-9e0a-a310d39f65bd.Assign][in][email]=john@folk.app&filter[customFieldValues.grp_c5993dec-0375-407e-9e0a-a310d39f65bd.Assign][in][id]=usr_d24b4748-8a5f-4a46-89fe-f19cff553a22 | in , not_in , empty , not_empty |
customFieldValues.{groupId}.Deals | ?filter[customFieldValues.grp_c5993dec-0375-407e-9e0a-a310d39f65bd.Deals][in][id]=obj_5ef2bef1-5234-4e09-bc15-f830697604b8 | in , not_in , empty , not_empty |
Filterable fields for companies
Field | Usage | Supported operators |
---|---|---|
name | ?filter[name][like]=ECMA | eq , not_eq , like , not_like ,empty , not_empty |
description | ?filter[description][like]=prospect | eq , not_eq , like , not_like ,empty , not_empty |
emails | ?filter[emails][like]=@folk.app | eq , not_eq , like , not_like ,empty , not_empty |
phones | ?filter[phones][eq]=+1234567890 | eq , not_eq , like , not_like ,empty , not_empty |
addresses | ?filter[addresses][not_like]=Paris | eq , not_eq , like , not_like ,empty , not_empty |
urls | ?filter[urls][not_eq]=https://example.com | eq , not_eq , like , not_like ,empty , not_empty |
groups | ?filter[groups][in][id]=grp_c5993dec-0375-407e-9e0a-a310d39f65bd | in , not_in , empty , not_empty |
createdAt (day precision) | ?filter[createdAt][gt]=2020-01-01 | eq , not_eq , gt , lt , empty , not_empty |
createdBy | ?filter[createdBy][in][email]=john@folk.app&filter[createdBy][in][id]=usr_c5993dec-0375-407e-9e0a-a310d39f65bd | in , not_in , empty , not_empty |
customFieldValues.{groupId}.Text | ?filter[customFieldValues.grp_c5993dec-0375-407e-9e0a-a310d39f65bd.Text][like]=team player | eq , not_eq , like , not_like ,empty , not_empty |
customFieldValues.{groupId}.Date | ?filter[customFieldValues.grp_c5993dec-0375-407e-9e0a-a310d39f65bd.Date][gt]=2020-01-01 | eq , not_eq , gt , lt , empty , not_empty |
customFieldValues.{groupId}.Number | ?filter[customFieldValues.grp_c5993dec-0375-407e-9e0a-a310d39f65bd.Number][lt]=200 | eq , not_eq , gt , lt , empty , not_empty |
customFieldValues.{groupId}.Status | ?filter[customFieldValues.grp_c5993dec-0375-407e-9e0a-a310d39f65bd.Status][in]=In Progress | in , not_in , empty , not_empty |
customFieldValues.{groupId}.Tags | ?filter[customFieldValues.grp_c5993dec-0375-407e-9e0a-a310d39f65bd.Tags][in]=B2B&filter[customFieldValues.grp_c5993dec-0375-407e-9e0a-a310d39f65bd.Tags][in]=B2C | in , not_in , empty , not_empty |
customFieldValues.{groupId}.Relationships | ?filter[customFieldValues.grp_c5993dec-0375-407e-9e0a-a310d39f65bd.Relationships][in][id]=per_a858d1bd-19d3-486d-87a4-c3b13d5b9a99 | in , not_in , empty , not_empty |
customFieldValues.{groupId}.Assign | ?filter[customFieldValues.grp_c5993dec-0375-407e-9e0a-a310d39f65bd.Assign][in][email]=john@folk.app&filter[customFieldValues.grp_c5993dec-0375-407e-9e0a-a310d39f65bd.Assign][in][id]=usr_d24b4748-8a5f-4a46-89fe-f19cff553a22 | in , not_in , empty , not_empty |
customFieldValues.{groupId}.Deals | ?filter[customFieldValues.grp_c5993dec-0375-407e-9e0a-a310d39f65bd.Deals][in][id]=obj_5ef2bef1-5234-4e09-bc15-f830697604b8 | in , not_in , empty , not_empty |
Filterable fields for deals
Field | Usage | Supported operators |
---|---|---|
name | ?filter[name][like]=Project Alpha | eq , not_eq , like , not_like ,empty , not_empty |
people | ?filter[people][in][id]=per_a858d1bd-19d3-486d-87a4-c3b13d5b9a99 | in , not_in , empty , not_empty |
companies | ?filter[companies][in][id]=com_c5993dec-0375-407e-9e0a-a310d39f65bd | in , not_in , empty , not_empty |
createdAt (day precision) | ?filter[createdAt][gt]=2020-01-01 | eq , not_eq , gt , lt , empty , not_empty |
createdBy | ?filter[createdBy][in][email]=john@folk.app&filter[createdBy][in][id]=usr_c5993dec-0375-407e-9e0a-a310d39f65bd | in , not_in , empty , not_empty |
customFieldValues.Text | ?filter[customFieldValues.Text][like]=team player | eq , not_eq , like , not_like ,empty , not_empty |
customFieldValues.Date | ?filter[customFieldValues.Date][gt]=2020-01-01 | eq , not_eq , gt , lt , empty , not_empty |
customFieldValues.Number | ?filter[customFieldValues.Number][lt]=200 | eq , not_eq , gt , lt , empty , not_empty |
customFieldValues.Status | ?filter[customFieldValues.Status][in]=In Progress | in , not_in , empty , not_empty |
customFieldValues.Tags | ?filter[customFieldValues.Tags][in]=B2B&filter[customFieldValues.Tags][in]=B2C | in , not_in , empty , not_empty |
customFieldValues.Assign | ?filter[customFieldValues.Assign][in][email]=john@folk.app&filter[customFieldValues.Assign][in][id]=usr_d24b4748-8a5f-4a46-89fe-f19cff553a22 | in , not_in , empty , not_empty |