ShopifyQL parsing errors.


value-backfilldaterangenotfound
BACKFILL_DATE_RANGE_NOT_FOUND

When using GROUP BY with the ALL modifier, SINCE or DURING must be defined.

value-columnnotfound
COLUMN_NOT_FOUND

Column not found.

value-comparetoincompatibleperiod
COMPARE_TO_INCOMPATIBLE_PERIOD

The time period for COMPARE TO must be the same length as DURING.

value-comparetoinvalidperiod
COMPARE_TO_INVALID_PERIOD

Invalid COMPARE TO period specified. Make sure it's not the same as the DURING clause.

value-comparetomissingperiod
COMPARE_TO_MISSING_PERIOD

Cannot use a COMPARE TO clause without DURING or SINCE.

value-comparisonwithnonaggregatefields
COMPARISON_WITH_NON_AGGREGATE_FIELDS

Comparison queries must only contain aggregated fields.

value-dateintervalnotfound
DATE_INTERVAL_NOT_FOUND

Date interval not found.

value-datenotparsable
DATE_NOT_PARSABLE

Date isn't parsable.

value-datetimenotparsable
DATE_TIME_NOT_PARSABLE

Datetime value isn't parsable.

value-excessbackfilldimensions
EXCESS_BACKFILL_DIMENSIONS

The GROUP BY function is limited to one parameter with the ALL modifier.

value-excessdimensions
EXCESS_DIMENSIONS

The GROUP BY function has too many parameters. When using VISUALIZE with COMPARE TO use only one GROUP BY parameter.

value-excessperiods
EXCESS_PERIODS

Mixing of SINCE and/or UNTIL with DURING is not allowed.

value-excesspresentments
EXCESS_PRESENTMENTS

Use the correct syntax for either SHOW or VISUALIZE.

value-fromnotfound
FROM_NOT_FOUND

Keyword FROM not found.

value-functionargumentsnotfound
FUNCTION_ARGUMENTS_NOT_FOUND

Function is missing required argument(s).

value-functionexcessarguments
FUNCTION_EXCESS_ARGUMENTS

Function has too many arguments.

value-functionincompatibletypes
FUNCTION_INCOMPATIBLE_TYPES

Function has incompatible types.

value-functionmodifiernotfound
FUNCTION_MODIFIER_NOT_FOUND

Function does not have any valid modifiers.

value-functionnestedaggregate
FUNCTION_NESTED_AGGREGATE

An aggregate function received a nested aggregate argument, which is not allowed.

value-functionnotfound
FUNCTION_NOT_FOUND

Function not found.

value-invaliddaterange
INVALID_DATE_RANGE

The SINCE date must be before or the same as the UNTIL date.

value-limitinvalid
LIMIT_INVALID

Limit is invalid.

value-listmixedargumenttypes
LIST_MIXED_ARGUMENT_TYPES

Mixing of IN list arguments of different data types is not allowed.

value-mixedaggregateandnonaggregate
MIXED_AGGREGATE_AND_NON_AGGREGATE

Mixing an aggregate expression and a non-aggregate expression is not allowed.

value-nameddatenotfound
NAMED_DATE_NOT_FOUND

Named date not found.

value-operatorincompatibletypes
OPERATOR_INCOMPATIBLE_TYPES

Invalid arguments for operator.

value-presentmentnotfound
PRESENTMENT_NOT_FOUND

Query is missing SHOW or VISUALIZE.

value-requiredgroupbynotfound
REQUIRED_GROUP_BY_NOT_FOUND

Column must include GROUP BY arg1.

value-semanticallyinvalid
SEMANTICALLY_INVALID

Semantically invalid.

value-sortfieldnotfound
SORT_FIELD_NOT_FOUND

Sort field not found.

value-syntaxfailedpredicate
SYNTAX_FAILED_PREDICATE

A semantic predicate failed during validation.

value-syntaxinputmismatch
SYNTAX_INPUT_MISMATCH

Identifier or function out of place.

value-syntaxinvalidtoken
SYNTAX_INVALID_TOKEN

Invalid entry.

value-syntaxmissingtoken
SYNTAX_MISSING_TOKEN

Query is incomplete.

value-syntaxnotrecognized
SYNTAX_NOT_RECOGNIZED

Syntax not recognized.

value-syntaxnoviablealternative
SYNTAX_NO_VIABLE_ALTERNATIVE

Identifier after SHOW is not valid in its current position.

value-syntaxunwantedtoken
SYNTAX_UNWANTED_TOKEN

Identifier or function out of place.

value-tablenotfound
TABLE_NOT_FOUND

Table not found.

value-timefunctionnotfound
TIME_FUNCTION_NOT_FOUND

Time function is incompatible in a GROUP BY clause with the ALL modifier.

value-unbackfilledtimegroupbycomparison
UNBACKFILLED_TIME_GROUP_BY_COMPARISON

When using COMPARE TO with a time-based GROUP BY, ALL must be used.

Unknown error.

value-valuenotparsable
VALUE_NOT_PARSABLE

Value isn't parsable.

value-visualizecharttypenotfound
VISUALIZE_CHART_TYPE_NOT_FOUND

The type of visualization is invalid. Acceptable types: bar, line.

value-visualizeexcessprojections
VISUALIZE_EXCESS_PROJECTIONS

Visualize has too many projections.

value-visualizegroupbymixedbackfill
VISUALIZE_GROUP_BY_MIXED_BACKFILL

Function VISUALIZE can only use GROUP BY or GROUP BY with the ALL modifier, not both.

value-visualizegroupbynotfound
VISUALIZE_GROUP_BY_NOT_FOUND

Function VISUALIZE requires GROUP BY.

value-visualizeincompatibletypes
VISUALIZE_INCOMPATIBLE_TYPES

Function VISUALIZE contains a data type which cannot be plotted.


Was this section helpful?

An error code for the error.


Was this section helpful?
Map
ParseErrorCode

Deprecated fields from