Search Data Objects

# Basic search
curl -X GET "https://api.pretectum.io/dataobjects/search?query=John" \
  -H "Authorization: your_access_token"

# Search with filters
curl -X GET "https://api.pretectum.io/dataobjects/search?query=John&businessArea=Customer&schema=Individual" \
  -H "Authorization: your_access_token"

# Search with pagination
curl -X GET "https://api.pretectum.io/dataobjects/search?query=John&from=0&size=20" \
  -H "Authorization: your_access_token"

# Find records containing "John" in any field
query=John

# Find records containing both "John" and "Smith" anywhere
query=John Smith
query=John AND Smith

# Find records containing either "John" or "Jane"
query=John OR Jane

# Find records with "John" but not "Doe"
query=John NOT Doe

# Find exact phrase "John Smith"
query="John Smith"

# Find names starting with "Jo"
query=Jo*

# Complex query with grouping
query=(John OR Jane) AND (Smith OR Doe)

# Find customers where First Name equals "Tim"
query=[First Name] eq "Tim"

# Find customers where Last Name equals "Smith"
query=[Last Name] eq "Smith"

# Find customers where Status is not "Inactive"
query=[Status] ne "Inactive"

# Find customers older than 21
query=[Age] gt 21

# Find customers 65 or younger
query=[Age] le 65

# Find orders with amount greater than or equal to $100
query=[Order Amount] ge 100

# Find products with price less than $500
query=[Price] lt 500

# Find customers with email containing "example.com"
query=[Email] contains "example.com"

# Find customers whose last name starts with "Sm"
query=[Last Name] startswith "Sm"

# Find customers whose email ends with ".org"
query=[Email] endswith ".org"

# Find customers named Tim Smith
query=[First Name] eq "Tim" and [Last Name] eq "Smith"

# Find customers in CA or NY
query=[State] eq "CA" or [State] eq "NY"

# Find active customers aged 18 to 65
query=[Status] eq "Active" and [Age] ge 18 and [Age] le 65

# Find premium customers with high order value
query=[Customer Type] eq "Premium" and [Order Amount] gt 1000

# Find customers in specific cities
query=[City] eq "New York" or [City] eq "Los Angeles" or [City] eq "Chicago"

# Complex condition with grouping
query=([State] eq "CA" or [State] eq "NY") and [Status] eq "Active"

# Find inactive customers or those with no recent orders
query=[Status] eq "Inactive" or [Last Order Date] lt "2024-01-01"

# Find products in Electronics category under $500
query=[Category] eq "Electronics" and [Price] le 500 and [In Stock] eq "true"

# Combine bracket notation with standard syntax
query=[First Name] eq "Tim" AND address.state:CA

# Full-text search with comparison operator
query=premium AND [Customer Type] eq "Enterprise"

# Field-specific with comparison operator
query=email:*@example.com and [Status] eq "Active"

# Find customers with first name "John"
query=firstName:John

# Find customers with last name "Smith" or "Johnson"
query=lastName:(Smith OR Johnson)

# Find customers with email addresses from example.com
query=email:*@example.com

# Find customers in New York city
query=address.city:"New York"

# Find customers in California state
query=address.state:CA

# Find customers with a phone number on file
query=_exists_:phone

# Find customers missing email address
query=NOT _exists_:email

# Combine full-text and field-specific search
query=John AND address.state:NY

# Find customers in NY or CA with name containing "Smith"
query=lastName:*Smith* AND address.state:(NY OR CA)

# Find customers aged 18 to 65 (inclusive)
query=age:[18 TO 65]

# Find customers aged between 18 and 65 (exclusive)
query=age:{18 TO 65}

# Find customers older than 21
query=age:>21

# Find customers 65 or younger
query=age:<=65

# Find orders with amount between $100 and $1000
query=orderAmount:[100 TO 1000]

# Find records created after a specific date
query=createdDate:>2024-01-01

# Find records updated in 2024
query=updatedDate:[2024-01-01 TO 2024-12-31]

# Search by nested address fields
query=address.city:Boston
query=address.state:MA
query=address.zipCode:02101

# Search by nested contact information
query=contact.email:*@company.com
query=contact.phone.mobile:+1-555*

# Combine nested field searches
query=address.city:Boston AND address.state:MA

# Search nested objects with phrase
query=address.street:"123 Main Street"