Knowledge base | Datafiniti

Advanced API Queries

Here's a table of more advanced query types that will help you make more targeted search queries.

What You'd Like to DoHow to Do ItSpecific Example
Allow a field to have wildcard matching when searching on it
q=field_name:field_value*
q=name:Coffee*
Require a field be filled out in your data set
q=field_name:*
q=review:*
Require a field to be at least some value in your data set
q=field_name:[smallest_value TO *]
q=dateUpdated:[2014-01-01 TO *]
Require a field have a specific range in your data set
q=field_name:[smallest_value TO largest_value]
q=rating:[3.0 TO 4.0]
Allow a field to have multiple possible values when searching on it
q=field_name:(field_value_1 field_value_2 field_value_3)
q=category:(restaurant bar club)
Search for data from 1 or more source URLs
q=source:(*sourceURL1* *sourceURL2*)
q=source:(http\:\/\/www.amazon.com* http\:\/\/www.target.com*)
Do a negative search on a field
q=-field_name:field_value
q=-category:restaurant