Case sensitivity

AI-generated Key Takeaways

• 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

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'