Send feedback
Case sensitivity
Stay organized with collections
Save and categorize content based on your preferences.
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 '
Send feedback
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License , and code samples are licensed under the Apache 2.0 License . For details, see the Google Developers Site Policies . Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-07-03 UTC.
[{
"type": "thumb-down",
"id": "missingTheInformationINeed",
"label":"Missing the information I need"
},{
"type": "thumb-down",
"id": "tooComplicatedTooManySteps",
"label":"Too complicated / too many steps"
},{
"type": "thumb-down",
"id": "outOfDate",
"label":"Out of date"
},{
"type": "thumb-down",
"id": "samplesCodeIssue",
"label":"Samples / code issue"
},{
"type": "thumb-down",
"id": "otherDown",
"label":"Other"
}]
[{
"type": "thumb-up",
"id": "easyToUnderstand",
"label":"Easy to understand"
},{
"type": "thumb-up",
"id": "solvedMyProblem",
"label":"Solved my problem"
},{
"type": "thumb-up",
"id": "otherUp",
"label":"Other"
}]
Need to tell us more?
{"lastModified": "Last updated 2024-07-03 UTC."}
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-07-03 UTC."]]