Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.trydatadriver.com/llms.txt

Use this file to discover all available pages before exploring further.

Filters are how you narrow down what rows you get. The shape is always: 
{ "column_name": { "operator": value } }
Listing multiple columns means all of them must match (AND).

​
Every operator

OperatorMeansValue shapeExample
eqequalsscalar"state": {"eq": "AZ"}
neqnot equalscalar"credit_rating": {"neq": "U"}
inis one ofarray"state": {"in": ["AZ","TX"]}
not_inis none ofarray"credit_rating": {"not_in": ["U","H"]}
gtgreater thannumber/date"age": {"gt": 18}
gte>=number/date"age": {"gte": 30}
ltless thannumber/date"age": {"lt": 65}
lte<=number/date"age": {"lte": 65}
betweeninclusive range[min, max]"age": {"between": [30, 65]}
likeSQL LIKE (case-sensitive)string with %"first_name": {"like": "John%"}
ilikecase-insensitive LIKEstring with %"personal_email": {"ilike": "%@gmail.com"}
is_nullis emptytrue"facebook_url": {"is_null": true}
not_nullis not emptytrue"linkedin_url": {"not_null": true}
containsarray containsarray"interests": {"contains": ["fitness"]}

​
Combining filters (AND logic)

{
  "filters": {
    "state":     { "eq": "TX" },
    "age":       { "gte": 30 },
    "homeowner": { "eq": "Y" },
    "dnc":       { "eq": "N" }
  }
}

​
Wildcards in like / ilike

The % character matches any number of characters:
PatternMatches
"John%"John, Johnny, Johnathan
"%smith"Smith, Goldsmith
"%@gmail.com"any Gmail address
"%manager%"Manager, General Manager, Sales Mgr.