| Date | Build
Number | Change
Type | Description |
| 2/28/2023 | 8459 | Shopify | Added
- 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/2023 | 8404 | Shopify | Added
- Added FulfillmentEvents view to the GraphQL schema. The view has server-side filtering support for FulfillmentId.
|
| 12/14/2022 | 8383 | General | Changed
- Added the Default column to the sys_procedureparameters table.
|
| 11/25/2022 | 8364 | Shopify | Added
- 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.
|
| 12/7/2022 | 8347 | Shopify | Added
- In Customers table (REST and GraphQL Schema) EmailMarketingState, EmailMarketingLevel and EmailMarketingUpdatedAt columns have been added.
Changed
- From the ProductVariants table the FulfillmentService column has been removed.
- 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 AcceptsMarketing and AcceptsMarketingUpdatedAt and HasTimelineComment columns have been removed.
|
| 11/7/2022 | 8346 | Shopify | Changed
- 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/2022 | 8308 | General | Changed
- Added the IsPath column to the sys_procedureparameters table.
|
| 08/29/2022 | 8276 | Shopify | Added
- 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/17/2022 | 8264 | General | Changed
- We now support handling the keyword "COLLATE" as standard function name as well.
|
| 08/03/2022 | 8250 | Shopify | Removed
- Removed the deprecated Basic authentication. These were deprecated by Shopify in January 2022.
- The AppId and Password connection properties have been removed.
|
| 07/21/2022 | 8237 | Shopify | Added
- Added Token as an authentication scheme to be used with custom apps.
|
| 06/13/2022 | 8199 | Shopify | Deprecated
- Deprecated the RowScanDepth property.
|
| 05/19/2022 | 8174 | Shopify | Added
- Added support for the GiftCards and Users tables.
|
| 05/05/2022 | 8160 | Shopify | Added
- Added support for GraphQL Bulk operations.
- Added the UseBulkApi and BulkPageSize connection properties.
|
| 04/25/2022 | 8150 | Shopify | Added
- Added the AuthScheme connection property with the options of Basic and OAuth.
|
| 04/15/2022 | 8140 | Shopify | Changed
- Querying data from 'OrderTransactions' or 'DiscountCode' with UpdatedAt filter will push the filter to the parent table, respectively 'Orders' and 'PriceRule'.
|
| 03/04/2022 | 8098 | Shopify | Changed
- Added the view ShippingItemDiscountAllocations.
|
| 02/28/2022 | 8094 | Shopify | Changed
- Added write support for the Metafields table.
|
| 02/02/2022 | 8068 | Shopify | Changed
- 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/2021 | 8012 | Shopify | Added
- 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/2021 | 7983 | Shopify | Added
- 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/2021 | 7972 | Shopify | Changed
- Updated the api version to 2021-10.
Removed
- Removed the ForceSSL field from Shop table.
|
| 09/13/2021 | 7926 | Shopify | Changed
- Updated the primary key data type from String to Long.
|
| 09/02/2021 | 7915 | General | Added
- Added support for the STRING_SPLIT table-valued function in the CROSS APPLY clause.
|
| 08/07/2021 | 7889 | General | Changed
- Added the KeySeq column to the sys_foreignkeys table.
|
| 08/06/2021 | 7888 | General | Changed
- Added the new sys_primarykeys system table.
|
| 07/23/2021 | 7874 | General | Changed
- 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 vs te predicate. Ie: 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. Ie: WHERE col > L_LAST_MONTH(). This will continue to resolve to the same values that previously were calculated in the criteria. Note that the "L_" prefix will only work in the predicate - it not available for the projection.
|
| 07/08/2021 | 7859 | General | Added
- Added the TCP Logging Module for the logging information happening on the TCP wire protocol. The transport bytes that are incoming and ongoing will be logged at verbosity=5.
|
| 06/26/2021 | 7847 | Shopify | Added
- Added the AbandonedCheckoutsItems View.
|
| 06/25/2021 | 7846 | Shopify | Added
- Added the Articles, Assets, Blogs, Comments, Pages, Redirects, ScriptTags and Themes tables.
- Added the ApproveComment, ChangeSpamStatus, and RestoreComment stored procedures.
|
| 06/10/2021 | 7831 | Shopify | Added
- Added the Status column to the Products table.
Changed
- Updated the API Version to 2021-04.
|
| 04/23/2021 | 7785 | General | Added
- 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/2021 | 7783 | General | Changed
- 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/2021 | 7776 | General | Added
- Non-conditional updates between two columns is now available to all drivers. For example: UPDATE Table SET Col1=Col2
Changed
- Reduced the length to 255 for varchar primary key and foreign key columns.
- Updated implicit and metadata caching to improve performance and support for multiple connections. Old metadata caches are not compatible - you would need to generate new metadata caches if you are currently using CacheMetadata.
- Updated index naming convention to avoid duplicates
- Updated and standardized Getting Started connection help.
- Added the Advanced Features section to the help of all drivers.
- Categorized connection property listings in the help for all editions.
|
| 04/15 /2021 | 7775 | General | Changed
- Kerberos authentication is updated to use TCP by default, but will fall back to UDP if a TCP connection cannot be established
|
| 03/10/2021 | 7739 | Shopify | Added
- Added the ApplicationCharges, ApplicationCredit, RecurringApplicationCharges and UsageCharges tables.
|