JDBC Driver for Shopify

Build 24.0.9060

Changelog

General Changes

DateBuild
Number
Change
Type
Description
10/07/20249046ShopifyRemoved
  • Removed the AverageOrderAmountV2Amount and AverageOrderAmountV2CurrencyCode columns from the GraphQL-2023-04.Customers and GraphQL-2023-07.Customers tables.
  • Removed the ResourceLimitsSkuResourceLimitsAvailable, ResourceLimitsSkuResourceLimitsQuantityAvailable, ResourceLimitsSkuResourceLimitsQuantityLimit, and ResourceLimitsSkuResourceLimitsQuantityUsed columns from the GraphQL-2023-04.Shop and GraphQL-2023-07.Shop views.
08/16/20248994ShopifyAdded
  • Added 34 new views related to Segments, OrderAgreements, OrderEditAgreements, and OrderRefundAgreements to all GRAPHQL schemas.
  • Added the Segments table to all GRAPHQL schemas.
05/09/20248895GeneralChanged
  • The ROUND function previously did not accept negative precision values. That feature has now been restored.
04/15/20248871ShopifyAdded
  • Added schema GraphQL-2024-01 and REST-2024-01.
  • Added FulfillmentOrderLineItems, FulfillmentOrderLocationsForMove, PriceListPrices as tables (GraphQL 2023-07, 2023-10, 2024-01).
  • Added AccessAdmin, AccessStorefront, CapabilitiesPublishableEnabled, CapabilitiesTranslatableEnabled as columns to MetaobjectDefinitions (GraphQL 2023-07, 2023-10, 2024-01).
  • Added DefinitionId, TypeField, CapabilitiesPublishableStatus as columns to MetaObjects (GraphQL 2023-07, 2023-10, 2024-01).
  • Added CapabilitiesOnlineStoreTemplateSuffix as a column to MetaObjects (GraphQL 2023-10, 2024-01).
  • Added CapabilitiesOnlineStoreEnabled, CapabilitiesOnlineStoreDataCanCreateRedirects, CapabilitiesOnlineStoreDataUrlHandle, CapabilitiesRenderableEnabled, CapabilitiesRenderableDataMetaDescriptionKey, CapabilitiesRenderableDataMetaTitleKey as columns to MetaobjectDefinitions (GraphQL 2023-10, 2024-01).
  • Added AbandonedCheckoutLineItems, ShopifyPaymentsAccountBalanceTransactions, ShopifyPaymentsAccountBalanceTransactionAdjustmentsOrders, FulfillmentOrderLocationForMoveAvailableLineItems, FulfillmentOrderLocationForMoveUnavailableLineItems as tables (GraphQL 2024-01).
  • Added OrderCancel as a stored procedure (GraphQL 2024-01).
  • Added ThumbnailFieldKey, ThumbnailFieldThumbnailHex, ThumbnailFieldFileId, ThumbnailFieldFileAlt, ThumbnailFieldFileCreatedAt, ThumbnailFieldFileUpdatedAt, ThumbnailFieldFileFileStatus, ThumbnailFieldFileFileErrors, ThumbnailFieldFilePreviewStatus, ThumbnailFieldFilePreviewImageId, ThumbnailFieldFilePreviewImageAltText, ThumbnailFieldFilePreviewImageHeight, ThumbnailFieldFilePreviewImageWidth, ThumbnailFieldFilePreviewImageUrl as columns to MetaObjects (GraphQL 2024-01).
  • Added MultiCapturable as a column to OrderTransactions and RefundTransactions (GraphQL 2024-01).
  • Added PayoutTransactionsAdjustmentOrderTransactions as a table (REST 2024-01).
  • Added CurrentQuantity as a column to OrdersItems (REST 2024-01).
  • Added FinancialSummaries as a column to FulfillmentOrderLineItems (GraphQL 2024-01, REST 2024-01).
  • Added MediaId and MediaSrc as inputs to ProductVariants (GraphQL 2024-01).

Changed
  • Changed ProductImages table's name to ProductMediaImages (GraphQL 2024-01).

Removed
  • Removed ResourceLimitsSkuResourceLimitsAvailable, ResourceLimitsSkuResourceLimitsQuantityAvailable, ResourceLimitsSkuResourceLimitsQuantityLimit, ResourceLimitsSkuResourceLimitsQuantityUsed (GraphQL 2023-10).
  • Removed AcceptsMarketing column from Customers (GraphQL 2024-01).
03/20/20248845ShopifyAdded
  • Added FulfillmentOrderLineItems as a table in the REST-2023-04, REST-2023-07, and REST-2023-10 schema.
03/15/20248840GeneralAdded
  • Created a new SQL function called STRING_COMPARE that provides java's String.compare() ability to SQL queries. Returns a number representative of the compared value of two strings
02/27/20248823ShopifyAdded
  • Added ConfirmationNumber as a column to the Orders table in the REST-2023-07, REST-2023-10, GRAPHQL-2023-07 and GRAPHQL-2023-10 schema.
  • Added PresentmentPrices, PresentmentAmount, PresentmentCurrency, CompareAtPriceAmount, CompareAtPriceCurrency columns to ProductVariants table.
02/20/20248816ShopifyAdded
  • Added support for API version 2023-10.
  • Table Location in the GraphQL schema and the 2023-10 version now has CUD support.
  • Added two new columns OrderName and OrderProcessedAt for the FulfillmentOrders table (GraphQL schema, 2023-10 version).

Removed
  • Removed deprecated column AverageOrderAmountV2Amount and AverageOrderAmountV2CurrencyCode from the Customers table (GraphQL schema, 2023-10 version).
  • Removed deprecated column BillingOn from the UsageCharges table (REST schema, 2023-10 version).
01/25/20248790ShopifyRemoved
  • Removed deprecated column ProcessingMethod from the Orders table (REST schema).
01/18/20248783ShopifyChanged
  • Added PublishDate, IsPublished and PublicationName columns for PublicationProducts table. The column LegacyResourceId is removed.

Added
  • Added MetaObjects and MetaobjectDefinitions table for the GraphQL schema.
11/29/20238733GeneralChanged
  • The ROUND function doesn't accept the negative precision values anymore.

Changed
  • The returning types of the FDMonth, FDQuarter, FDWeek, LDMonth, LDQuarter, LDWeek functions are changed from Timestamp to Date.
  • The return type of the ABS function will be consistent with the parameter value type.
11/28/20238732GeneralAdded
  • Added the HMACSHA256 formatter to allow for secrets to be decoded if it is in base64 format
10/27/20238700JDBCChanged
  • Added support for Connection.abort() method.
09/20/20238663ShopifyAdded
  • CarrierServices is new view in the GraphQL schema.
  • AppFeedbacks, and ProductResourceFeedbacks are three new tables in the GraphQL schema.
  • CarrierServices, ResourceFeedbacks, and ProductResourceFeedbacks are three new tables in the Rest schema.
  • The following list are stored-procedures added in Rest and GraphQL schema: SendFulfillmentRequest, AcceptFulfillmentRequest, RejectFulfillmentRequest, SendCancellationRequest, AcceptCancellationRequest and RejectCancellationRequest.
08/30/20238642ShopifyAdded
  • Added Catalogs table for the GraphQL schema.
  • Added Returns table for the GraphQL schema.
  • Added ReturnLineItems table for the GraphQL schema.
  • Added PriceLists table for the GraphQL schema.
08/25/20238637ShopifyChanged
  • Changed Fulfillments.FulfillmentOrderId from pseudo-column to column.
08/22/20238634ShopifyAdded
  • Added support for API version 2023-07, the following stored procedures have been added to the GRAPHQL-2023-07 schema to reflect the new mutations: FulfillmentOrderSplit, FulfillmentOrderMerge, CompanyContactRemoveFromCompany.
08/18/20238630ShopifyAdded
  • Added AppliesOnEachItem, DiscountOnQuantity, DiscountPercentage, DiscountQuantityToBuy, DiscountAmountToBuy, ProductsToAdd, ProductsToRemove, ProductsBuysToAdd, ProductsBuysToRemove pseudo-column to the DiscountsAutomaticBxgy table.
  • Added AppliesOnEachItem, DiscountAmount, ProductsToAdd, ProductsToRemove, MinimumQuantity, MinimumSubtotal pseudo-column to the DiscountsAutomaticBasic table.
  • Added Code, AddAllCustomers, CustomersToAdd, CustomersToRemove, CustomerSegmentsToAdd, CustomerSegmentsToRemove pseudo-column to the DiscountsCodeApp table.
  • Added Code, AppliesOnEachItem, DiscountAmount, ProductsToAdd, ProductsToRemove, AddAllCustomers, CustomersToAdd, CustomersToRemove, CustomerSegmentsToAdd, CustomerSegmentsToRemove pseudo-column to the DiscountsCodeBasic table.
  • Added Code, AppliesOnEachItem, DiscountOnQuantity, DiscountPercentage, DiscountQuantityToBuy, DiscountAmountToBuy, ProductsToAdd, ProductsToRemove, ProductsBuysToAdd, ProductsBuysToRemove, AddAllCustomers, CustomersToAdd, CustomersToRemove, CustomerSegmentsToAdd, CustomerSegmentsToRemove pseudo-column to the DiscountsCodeBxgy table.
08/17/20238629ShopifyChanged
  • Changed ThemeId of Assets table to be key for the table.
08/04/20238616ShopifyChanged
  • Changed Articles.PublishedStatus, Comments.PublishedStatus, CustomCollections.PublishedStatus, CustomCollections.ProductId, Pages.PublishedStatus, Products.PublishedStatus, SmartCollections.PublishedStatus, SmartCollections.ProductId from pseudo-columns to columns.
  • Changed names of 'Image.alt', 'Image.createdAt', 'Image.height', 'Image.src', 'Image.width', 'Image.attachment', Template_suffix', 'published_status' columns in Articles table, REST schema, to 'ImageAlt', 'ImageCreatedAt', 'ImageHeight', 'ImageSrc', 'ImageWidth', 'ImageAttachment', 'TemplateSuffix', 'PublishedStatus'.
  • Changed name of 'published_status' column in Comments table, REST schema, to 'PublishedStatus'.
  • Changed name of 'published_status' column in Pages table, REST schema, to 'PublishedStatus'.

Removed
  • Removed pseudo-column 'status' of Comments table in REST schema. Data can now be filtered server-side through 'Status' column.
07/25/20238606ShopifyAdded
  • Added TransactionItemSource pseudo-column to the OrderTransactions table.

Changed
  • Changed Authorization and Currency columns of OrderTransactions table to writable.
  • Changed Metafields column of Pages table to writable.
07/24/20238605ShopifyAdded
  • Added new stored procedure CalculateRefund in REST schema, used to calculate refund transactions based on line items and shipping.

Changed
  • Changed Metafields column of Blogs table to writeable.

Removed
  • Removed CalculateRefund pseudocolumn from Refunds table, used to access the endpoint for calculating refunds. Refunds will be calculated through the CalculateRefund stored procedure.
07/13/20238594ShopifyAdded
  • Added EnableShopifyPlus connection property, when set to true, additional columns and tables will be available in the driver. This property is only available to accounts with a ShopifyPlus membership.
07/11/20238592ShopifyAdded
  • Added Receipt column as a JSON aggregate to the OrderTransactions table.

Removed
  • Removed ReceiptTestcase and ReceiptAuthorization columns from OrderTransactions table.
06/20/20238571GeneralAdded
  • Added the new sys_lastresultinfo system table.
06/19/20238570ShopifyRemoved
  • From the ProductVariants table (in GraphQL schema) the Title column has been removed.

Changed
  • Rest schema has been modified to REST-2023-04, which represents the REST API version 2023-04.
  • GraphQL schema has been modified to GraphQL-2023-04, which represents the 2023-04 version of the GraphQL API.

Added
  • Added support for pushing metafields as custom field/columns for Products and ProductVariants in the GraphQL schema.

Changed
  • Changed the GraphQL data model to better align with and support version 2023-04 of the API.
  • The following tables are now supported in the GraphQL schema, AppSubscriptionLineItems, AppSubscriptions, Collections, Companies, CompanyLocations, Customers, DeliveryProfiles, DiscountsAutomaticApp, DiscountsAutomaticBasic, DiscountsAutomaticBxgy, DiscountsCodeApp, DiscountsCodeBasic, DiscountsCodeBxgy, DraftOrders, FulfillmentEvents, FulfillmentOrders, Fulfillments, FulfillmentServices, FulfillmentTrackingInfo, GiftCards, InventoryItems, Metafields, Orders, OrderTransactions, ProductImages, Products, ProductVariants, Publications, Refunds, ScriptTags, SellingPlanGroups, StorefrontAccessTokens, UrlRedirects.
  • The following views are now supported in the GraphQL schema, Abandonment, AbandonmentProductsAddedToCart, AbandonmentProductsViewed, AppCredits, ArticleComments, Articles, AssignedFulfillmentOrders, Blogs, CollectionProducts, CompanyEvents, CustomerEvents, DeliveryProfileLocationGroupCountries, DeliveryProfileLocationGroupCountryProvinces, DeliveryProfileLocationGroups, DeliveryProfileLocationGroupZones, DeliveryProfileUnassignedLocations, DiscountEvents, DiscountsCodeFreeShipping, DraftOrderCustomAttributes, DraftOrderEvents, DraftOrderLineItemCustomAttributes, DraftOrderLineItems, DraftOrderLineItemTaxLines, DraftOrderTaxLines, InventoryItemCountryHarmonizedSystemCodes, InventoryItemInventoryLevels, Jobs, Locations, MarketingEvents, OrderCustomAttributes, OrderDiscountApplications, OrderEvents, OrderLineItemCustomAttributes, OrderLineItemDiscountAllocations, OrderLineItems, OrderNonFulfillableLineItems, OrderRisks, OrderTaxLines, Pages, ProductOptions, PublicationCollections, PublicationProducts, RefundDuties, RefundLineItems, RefundTransactionFees, RefundTransactions, SellingPlanGroupSellingPlans, Shop, ShopifyPaymentsAccount, ShopifyPaymentsAccountBalance, ShopifyPaymentsAccountBankAccounts, ShopifyPaymentsAccountDisputes, ShopifyPaymentsAccountPayouts, ShopifyPaymentsAccountPermittedVerificationDocuments, ShopifyPaymentsAccountVerifications, StaffMembers, TenderTransactions.
  • Tables support certain CUD statements in the GraphQL schema, refer to the Data Model documentation.
06/09/20238560ShopifyAdded
  • Added Fulfillments and Refunds as aggregate columns in Orders table of REST schema.
04/27/20238517ShopifyChanged
  • Changed GraphQL.DraftOrders.AppliedDiscountValue data type from "float" to "double".
  • Changed GraphQL.ProductVariants.Weight data type from "float" to "double".
04/25/20238515GeneralRemoved
  • Removed support for the SELECT INTO CSV statement. The core code doesn't support it anymore.
03/30/20238489ShopifyAdded
  • Added PageSize property to the Rest schema, default value is 250.
03/28/20238487ShopifyAdded
  • Added UpdateQuantity stored procedure for the Rest schema, which allows the user to update InventoryQuantity column from ProductVariants table.
02/28/20238459ShopifyAdded
  • Added Collections view to the GraphQL schema.
  • Added CollectionProducts view to the GraphQL schema.
  • Added Jobs view to the GraphQL schema.
  • Added CollectionReorder store procedure for the GraphQL schema, which allows the user to reorder a set of products within a specified collection.
01/04/20238404ShopifyAdded
  • Added FulfillmentEvents view to the GraphQL schema. The view has server-side filtering support for FulfillmentId.
12/14/20228383GeneralChanged
  • Added the Default column to the sys_procedureparameters table.
12/07/20228376ShopifyAdded
  • In Customers table (REST and GraphQL Schema) EmailMarketingState, EmailMarketingLevel and EmailMarketingUpdatedAt columns have been added.

Changed
  • In PriceRules table (REST Schema) the PrerequisiteSavedSearchIds column is based on the new customer_segment_prerequisite_ids field.

Removed
  • In Customers table (REST Schema) the AcceptsMarketing column has been removed.
  • In Customers table (GraphQL Schema) the AcceptsMarketingUpdatedAt and HasTimelineComment columns have been removed.
11/25/20228364ShopifyAdded
  • Added Metafields view to the GraphQL schema. OwnerResource is required and only accepts "product" or "variant" as values. The view has server-side filtering support for Id and OwnerId. The GraphQL.Metafields columns Id, LegacyResourceId, Namespace, Key, Value, Type, Description, OwnerId, OwnerResource, CreatedAt and UpdatedAt correspond to the same name columns in the REST table, except for Id and LegacyResourceId. GraphQL.Metafields.Id corresponds to REST.Metafields. AdminGraphqlApiId, and GraphQL.Metafields.LegacyResourceId corresponds to REST.Metafields.Id.
  • Added Products view to the GraphQL schema. GraphQL.Products supports server-side filtering for the following columns: Id, Title, ProductType, Status, Vendor, TotalInventory, HasOnlyDefautlVariant, UpdatedAt and CreatedAt.
  • Added ProductVariants view to the GraphQL schema. GraphQL.ProductVariants supports server-side filtering for the following columns: Id, ProductId, Title, Barcode, Sku, Taxable, UpdatedAt, CreatedAt, InventoryQuantity and DeliveryProfileId.
  • Added ProductImages and ProductOptions view to the GraphQL schema.

Changed
  • Changed REST.GraphQL.Metafields.OwnerResource column to required (except when Id is specified), and limited to the following values: shop,draft_order,product,variant,page,article,order,customer,collection,blog,product_image.
11/07/20228346ShopifyChanged
  • For the Fulfillments table in Rest the FulfillmentOrderId pseudo column is required. The value of this column can be found in the FulfillmentOrders table. Example: Insert Into OrdersItems#Temp (ItemId) Values ('6578878840855') Insert INTO Fulfillments (FulfillmentOrderId, LocationId, LineAggregate) VALUES (315766505495, 1448280087, 'OrdersItems#Temp')
  • For the Fulfillments table in Rest, only the tracking information (TrackingCompany, TrackingNumbers, TrackingUrls) is updatable.
  • Changed how a Fulfillment is canceled. To cancel, the Status of the Fulfillment should be updated to cancel.
  • In the MetaField the new `type` field is being used to determine the data type.

Removed
  • HasNote and OrdersCount columns from the Customers table in GraphQL.
09/30/20228308GeneralChanged
  • Added the IsPath column to the sys_procedureparameters table.
08/29/20228276ShopifyAdded
  • Added INSERT support for MetaFields and dynamic tables (Products, ProductVariants).

Changed
  • Changed how custom field names are handled. Custom fields will be pushed as either 'key' or 'namespace_key' depending on duplicates.
08/03/20228250ShopifyRemoved
  • Removed the deprecated Basic authentication. These were deprecated by Shopify in January 2022.
  • The AppId and Password connection properties have been removed.
07/21/20228237ShopifyAdded
  • Added Token as an authentication scheme to be used with custom apps.
06/13/20228199ShopifyDeprecated
  • Deprecated the RowScanDepth property.
06/11/20228197JDBCChanged
  • The method GetJDBCMinorVersion() and GetJDBCMajorVersion() return 4.2 as the supported JDBC major / minor version.
05/19/20228174ShopifyAdded
  • Added support for the GiftCards and Users tables.
05/05/20228160ShopifyAdded
  • Added support for GraphQL Bulk operations.
  • Added the UseBulkApi and BulkPageSize connection properties.
04/28/20228153JDBCChanged
  • Removed support for JRE 1.6. JRE 1.8 and above is now required.
04/25/20228150ShopifyAdded
  • Added the AuthScheme connection property with the options of Basic and OAuth.
04/15/20228140ShopifyChanged
  • Querying data from 'OrderTransactions' or 'DiscountCode' with UpdatedAt filter will push the filter to the parent table, respectively 'Orders' and 'PriceRule'.
03/04/20228098ShopifyChanged
  • Added the view ShippingItemDiscountAllocations.
02/28/20228094ShopifyChanged
  • Added write support for the Metafields table.
02/25/20228091JDBCChanged
  • The method DatabaseMetaData.getTypeInfo() now returns all of the data types that the driver supports. Previously, it was returning only a portion of the data types. The types include: tinyint, smallint, int, bigint, float, double, numeric, decimal, bit, date, datetime, time, varchar, binary, uuid.
02/24/20228090JDBCChanged
  • Corrected the return value of method DatabaseMetaData.supportsOuterJoins(), which used to return an incorrect value.
02/02/20228068ShopifyChanged
  • Changed the datatype for the ShippingZones.ProfileId and ShippingZones.LocationGroupId columns from long to string as they were marked with the incorrect data type.
12/08/20218012ShopifyAdded
  • The following columns were added to the Orders Table: TotalShippingPriceSetShopMoneyAmount and TotalShippingPriceSetShopMoneyCurrencyCode.
  • Added the Metafields view.
  • Added the column OrderUpdatedAt to tables OrderItemDiscountAllocations and OrderItemProperties.
  • Added support for delta replication for columns OrderUpdatedAt, ProductUpdatedAt and CustomerUpdatedAt.
11/09/20217983ShopifyAdded
  • The following columns were added to the FullfillmentOrders Table: FullfillAt, Fullfillmentholds, InternationalDuties.
  • The following columns were added to the Orders Table: PaymentTermsAmount, PaymentTermsCurrency, PaymentTermsPaymentTermsName, PaymentTermsPaymentTermsType, PaymentTermsDueInDays, PaymentTermsPaymentSchedules.
  • The following columns were added to the OrderTransactions Table: PaymentsRefundsAttributesStatus, PaymentsRefundsAttributesAcquirerReferenceNumber.
  • Added the ChannelLiable column to the TaxItems table.
10/29/20217972ShopifyChanged
  • Updated the api version to 2021-10.

Removed
  • Removed the ForceSSL field from Shop table.
10/27/20217970JDBCChanged
  • Added support for JDK 17
09/13/20217926ShopifyChanged
  • Updated the primary key data type from String to Long.
09/12/20217925JDBCRemoved
  • Removed the IS_READONLY, IS_KEY, NUMERIC_PRECISION, and DECIMAL_DIGITS columns from DatabaseMetadata.GetColumns(), as they are not part of the JDBC Specification. This information is still available via other metadata calls.
09/02/20217915GeneralAdded
  • Added support for the STRING_SPLIT table-valued function in the CROSS APPLY clause.
08/07/20217889GeneralChanged
  • Added the KeySeq column to the sys_foreignkeys table.
08/06/20217888GeneralChanged
  • Added the new sys_primarykeys system table.
07/23/20217874GeneralChanged
  • Updated the Literal Function Names for relative date/datetime functions. Previously, relative date/datetime functions resolved to a different value when used in the projection as opposed to the predicate. For example: SELECT LAST_MONTH() AS lm, Col FROM Table WHERE Col > LAST_MONTH(). Formerly, the two LAST_MONTH() methods would resolve to different datetimes. Now, they will match.
  • As a replacement for the previous behavior, the relative date/datetime functions in the criteria may have an 'L' appended to them. For example: WHERE col > L_LAST_MONTH(). This will continue to resolve to the same values that were previously calculated in the criteria. Note that the "L_" prefix will only work in the predicate - it not available for the projection.
06/26/20217847ShopifyAdded
  • Added the AbandonedCheckoutsItems View.
06/25/20217846ShopifyAdded
  • Added the Articles, Assets, Blogs, Comments, Pages, Redirects, ScriptTags and Themes tables.
  • Added the ApproveComment, ChangeSpamStatus, and RestoreComment stored procedures.
06/10/20217831ShopifyAdded
  • Added the Status column to the Products table.

Changed
  • Updated the API Version to 2021-04.
04/25/20217785GeneralAdded
  • Added support for handling client side formulas during insert / update. For example: UPDATE Table SET Col1 = CONCAT(Col1, " - ", Col2) WHERE Col2 LIKE 'A%'
04/23/20217783GeneralChanged
  • Updated how display sizes are determined for varchar primary key and foreign key columns so they will match the reported length of the column.
04/16/20217776GeneralAdded
  • Non-conditional updates between two columns is now available to all drivers. For example: UPDATE Table SET Col1=Col2
04/16/20217776GeneralChanged
  • Reduced the length to 255 for varchar primary key and foreign key columns.

Changed
  • Updated index naming convention to avoid duplicates.
04/16/20217776GeneralChanged
  • Updated implicit and metadata caching to improve performance and support for multiple connections. Old metadata caches are not compatible - you need to generate new metadata caches if you are currently using CacheMetadata.
03/10/20217739ShopifyAdded
  • Added the ApplicationCharges, ApplicationCredit, RecurringApplicationCharges and UsageCharges tables.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060