Case sensitivity

  • The Merchant API is the new version of the Content API for Shopping and represents the future of the platform.

  • Developers can learn more about the Merchant API and its benefits in the official announcement blog post.

  • Merchant Center Query Language allows for data filtering with various operators, with differing case sensitivities for string values.

  • The REGEXP_MATCH operator is case-sensitive by default, but offers case-insensitivity through the (?i) flag.

The Merchant Center Query Language lets you filter the returned data set with a number of different operators. When filtering on string values, the default case sensitivity of each operator plays an important part in correctly filtering your results.

Operators Case Sensitivity
= or != Case sensitive
(NOT) IN Case sensitive
(NOT) LIKE Case sensitive
CONTAINS (...) Case sensitive
REGEXP_MATCH Optionally Both

Example

  SELECT 
  
 segments 
 . 
 offer_id 
 , 
  
 metrics 
 . 
 clicks 
 FROM 
  
 MerchantPerformanceView 
 WHERE 
  
 segments 
 . 
 offer_id 
  
 REGEXP_MATCH 
  
 "(?i)AmazingOffer\d+" 
  
 AND 
  
 segments 
 . 
 date 
  
 BETWEEN 
  
 '2021-01-01' 
  
 AND 
  
 '2021-01-31' 
 
Create a Mobile Website
View Site in Mobile | Classic
Share by: