Case sensitivity

We would like to introduce the beta version of the Merchant API. It is the new version of the Content API for Shopping and the future.

For information about how Merchant API can improve your integration and how you can help shape the future, see Announcing the Merchant API Beta.

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

Key Point: REGEXP_MATCH and NOT REGEXP_MATCH are case-sensitive by default, but you can include (?i) as described in the RE2 syntax to make them case-insensitive.

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'