Gramática del lenguaje de consulta de Merchant Center
Esta es la referencia gramatical del lenguaje de consulta de Merchant Center (en notación de expresiones regulares):
Query -> SelectClause FromClause? WhereClause? OrderByClause? LimitClause?
SelectClause -> SELECT FieldName (, FieldName)*
FromClause -> FROM TableName
WhereClause -> WHERE Condition (AND Condition)*
OrderByClause -> ORDER BY Ordering (, Ordering)*
LimitClause -> LIMIT PositiveInteger
Condition -> FieldName Operator Value | FieldName BETWEEN Value AND Value
Operator -> = | != | > | >= | < | <= | <> | IN | NOT IN |
CONTAINS ANY | CONTAINS ALL | CONTAINS NONE | DURING |
LIKE | NOT LIKE | REGEXP_MATCH | NOT REGEXP_MATCH
Value -> Number | NumberList | String | StringList | Function
Ordering -> FieldName (ASC | DESC)?
FieldName -> [a-z] ([a-zA-Z0-9._])*
TableName -> [A-Z] ([a-zA-Z_])*
StringList -> ( String (, String)* )
NumberList -> ( Number (, Number)* )
PositiveInteger -> [1-9] ([0-9])*
Number -> -? [0-9]+ (. [0-9] [0-9]*)?
String -> (' Char* ') | (" Char* ")
Function -> LAST_14_DAYS | LAST_30_DAYS | LAST_7_DAYS |
LAST_BUSINESS_WEEK | LAST_MONTH | LAST_WEEK_MON_SUN |
LAST_WEEK_SUN_SAT | THIS_MONTH | THIS_WEEK_MON_TODAY |
THIS_WEEK_SUN_TODAY | TODAY | YESTERDAY
?
indica un elemento opcional.
*
significa cero o más. +
significa uno o más.
(xxxxxx)
indica una agrupación.
[a-z0-9]
hace referencia a los rangos de caracteres.
|
significa "o".
Salvo que se indique lo contrario, el contenido de esta página está sujeto a la licencia Atribución 4.0 de Creative Commons, y los ejemplos de código están sujetos a la licencia Apache 2.0. Para obtener más información, consulta las políticas del sitio de Google Developers. Java es una marca registrada de Oracle o sus afiliados.
Última actualización: 2024-09-20 (UTC)
[null,null,["Última actualización: 2024-09-20 (UTC)"],[[["The Merchant API is the new version of the Content API for Shopping and represents the future of product data integration."],["Developers can learn more about the Merchant API and its benefits, as well as how to participate in shaping its future, in the official announcement blog post."],["The Merchant Center Query Language uses a structured grammar, allowing developers to query data with clauses like `SELECT`, `FROM`, `WHERE`, `ORDER BY`, and `LIMIT`."],["Various operators such as comparison, range, list inclusion, and regular expression matching are supported within the `WHERE` clause to filter data effectively."],["The `REGEXP_MATCH` operator leverages RE2 syntax for flexible and powerful regular expression-based filtering capabilities."]]],["The beta version of the Merchant API, the new Content API for Shopping, is available. The Merchant Center Query Language uses a specific grammar, defined with regular expressions, including `SELECT`, `FROM`, `WHERE`, `ORDER BY`, and `LIMIT` clauses. Conditions use operators like `=`, `IN`, `CONTAINS`, and `DURING`, and values can be numbers, strings, or functions like `LAST_14_DAYS`. The `REGEXP_MATCH` operator employs RE2 syntax. The documentation details how to integrate and shape this API.\n"]]