Changelog: Driver Update 2024.3

Review the driver-specific changes from the 2024.3 CData Driver release.

Date Entered: 02/06/2024    Last Updated: 02/17/2024

Date Build Number Provider Description Breaking Change
02/06/2025 9168 ApachePhoenix Added
  • Added the EnableCaseSensitivity connection property. When enabled, any source schemas, tables, or columns with the same name, but different casing, are automatically given the suffix '_n' to differentiate them.
No
02/06/2025 9168 Wowma Added
  • Added the EgiftTradeFlg and PontaPassCampaignApplyFlg columns to the Orders table.
  • Added the EGiftTrade pseudocolumn to the Items table.
  • Added the EGiftProductFlg and ItemOptionReqFlg columns to the Items table.
No
02/04/2025 9166 HubSpot Added
  • Added the HasUniqueValues column to sys_tablecolumns, which returns a boolean indicating whether the column has unique values.
No
01/31/2025 9162 Airtable Added
  • Added the following views to the INFORMATION_SCHEMA: IndividualCollaborators and GroupCollaborators.
Changed
  • The views BaseIndividualCollaborators and WorkspaceIndividualCollaborators in the INFORMATION_SCHEMA have been merged into IndividualCollaborators.
  • The views BaseGroupCollaborators and WorkspaceGroupCollaborators in the INFORMATION_SCHEMA have been merged into GroupCollaborators. |
No
01/31/2025 9162 Asana Added
  • Added the AuthScheme connection property with OAuthPKCE support.
No
01/31/2025 9162 DocuSign Added
  • Added the FolderIds column to the Templates view.
No
01/31/2025 9162 GoogleAnalytics Added
  • Added the PropertiesAccessBindings, PropertiesAudiences, and PropertiesKeyEvents views to the GoogleAnalytics4 data model.
  • Added the IncludeDeleted connection property.
No
01/29/2025 9160 DocuSign Added
  • Added the FolderType connection property. This property allows you to control which folder types are included in the results of queries to the Folders view.
No
01/29/2025 9160 GoogleBigQuery Added
  • Added the SupportCaseSensitiveTables connection property. Enable this property to allow multiple tables with the same name, but different casing in the listed tables.
No
01/29/2025 9160 Salesforce Added
  • Added the DefaultedOnCreate column to the sys_tablecolumns system table.
No
01/28/2025 9159 OracleSalesCloud Added
  • Added the following tables: AccountContactPoints, AccountOrganizationContacts, CompetitorAccounts, ContactContactPoints, OpportunityAssessments, OpportunityCampaigns, OpportunityRevenueItemsChildSplitRevenue, OpportunityRevenueItemsRecurringRevenues, ResourceUsers, SalesLeadContacts, SalesLeadResources, SalesLeads, SalesLeadsLeadCampaigns, SalesLeadsLeadCompetitors, SalesLeadsLeadQualifications, SalesLeadsNotes, Signatures, and TerritoryResources.
  • Added the following views: AccountAttachments, AccountHierarchy, ActivityAttachments, ContactAttachments, ContactsPictureAttachments, OpportunityAttachments, ResourceUsersResourceRoleAssignments, SalesLeadAttachments, SalesLeadsLeadOpportunity, SalesLeadsLeadTeam, SalesLeadsProductGroups, SalesLeadsProducts, and SalesLeadTerritories.
  • Added the following stored procedures: DeleteAccountsAttachment, DeleteActivityAttachment, DeleteContactsAttachment, DeleteContactsPictureAttachment, DeleteOpportunityAttachment, DeleteSalesLeadsAttachment, UpdateAccountsAttachment, UpdateActivityAttachment, UpdateContactPictureAttachment, UpdateContactsAttachment, UpdateOpportunityAttachment, UpdateSalesLeadsAttachment, UploadAccountsAttachment, UploadActivityAttachment, UploadContactAttachment, UploadContactPictureAttachment, UploadOpportunityAttachment, and UploadSalesLeadsAttachment.
No
01/27/2025 9158 MYOB Changed
  • Changed the data type from int to string for both the BankingAccountNumber column in the Accounts table and the BankAccountNumber column in the BankAccounts table to ensure compatibility with bank account number values across all regions.
Yes
01/27/2025 9158 SharePoint Added
  • Added a new stored procedure, AddImage, to the REST schema.
No
01/27/2025 9158 Smartsheet Added
  • Added validations for data definition language (DDL) statements. A RowId column with the exact definition RowId VARCHAR PRIMARY KEY is required in CREATE TABLE statements. Only the column name and data type are supported for other columns, such as Column1 VARCHAR.
  • Added validation for ALTER TABLE statements so the RowId column cannot be modified in any way.
No
01/24/2025 9155 GoogleAnalytics Added
  • Added the Deleted column to the Accounts view.
  • Added the DeleteTime column to the Properties view.
No
01/23/2025 9154 HubSpot Added
  • Added support for server-side UPSERT statements.
No
01/23/2025 9154 Netsuite Added
  • Added the OAuthJWT option for the AuthScheme connection property in the SuiteQL schema.
No
01/23/2025 9154 SalesLoft Added
  • Added the following tables: ExternalIdConfigurations, ExternalIdMappings, OpportunityPeople, OpportunityStages, PlayRegistrations, and SignalRegistrations.
  • Added the following views: CadenceStats, CallsInstructions, CRMAccountTeamMemberRoles, CRMAccountTeamMembers, CustomRoles, Opportunities, Profiles, Requests, TasksStatistics, Transcriptions, TranscriptionsArtifact, and TranscriptionsSentences.
No
01/17/2025 9148 SAPGateway Added
  • "SAPBTP" is now a supported value for the AuthScheme connection property. Set this value to retreive authentication details from your configured SAP BTP Destination.
No
01/16/2025 9147 Airtable Added
  • Added the BaseName column to the following views in the INFORMATION_SCHEMA: Tables, BaseIndividualCollaborators, and BaseGroupCollaborators.
No
01/16/2025 9147 Confluence Added
  • Added the MediaType column to the Attachments view.
No
01/16/2025 9147 Instagram Removed
  • In the v21.0 API, removed the EmailContacts, ProfileViews, TextMessage, WebsiteClicks, PhoneCallClicks, and GetDirectionsClicks columns from the AccountInsights view.
  • In the v21.0 API, removed the VideoViews column from the MediaInsights view.
  • In the v21.0 API, removed the website_clicks and profile_views metrics from the AccountTimeSeriesFollowType, AccountTimeSeriesMediaProductType, and AccountTimeSeriesWithoutBreakdown views.
No
01/16/2025 9147 LinkedInAds Added
  • Added the following columns to the Campaigns view: ConnectedTelevisionOnly, TimeSpanDuration, TimeSpanUnit, and Frequency.
  • Added the Name column to the Creatives view.
  • Added the EventStage column to the Analytics view.
No
01/16/2025 9147 SAPGateway Added
  • Added the IsSAPMessage column to the sys_tablecolumns system table to indicate whether a column is related to an SAP message.
No
01/16/2025 9147 YouTubeAnalytics Added
  • Added the following views: MyLikedVideos, MyDislikedVideos, MostPopularVideosByRegion, and MostPopularVideosByCategory.
No
01/16/2025 9147 ZohoCRM Added
  • Added support for the Bulk Write API, enabling bulk INSERT, UPDATE, and UPSERT operations for supported tables. Bulk DELETE operations and the following tables remain supported exclusively by the REST API: Leads, Attachments, Notes, Events, and Calls.
No
01/15/2025 9146 CommonDataService Added
  • Added the success output parameter to the CreateAssociations and RemoveAssociations stored procedures.
No
01/15/2025 9146 Dynamics365 Added
  • Added the success output parameter to the CreateAssociations and RemoveAssociations stored procedures.
No
01/15/2025 9146 GoogleAnalytics Added
  • Added two new report views: KeyEvents and ScreenPageViews.
No
01/15/2025 9146 OData Added
  • Added the success output parameter to the CreateAssociations and RemoveAssociations stored procedures.
No
01/15/2025 9146 Pinterest Added
  • Added the following views: AudienceInsights, AudienceInsightsScopeAndType, LinkedBusinesses, Followers, Following, FollowingBoards, FollowingInterests, UserWebsites, UserVerificationCodeForWebsiteClaim, and CustomerLists.
  • Added the following stored procedure: VerifyWebsite.
No
01/15/2025 9146 QBOnline Added
  • Added the IncludeUnrealizedGainOrLoss attribute to the following stored procedures: CreateProfitAndLossDetailReport, CreateProfitAndLossSummaryReport, and CreateBalanceSheetSummaryReport.
No
01/15/2025 9146 SAPSuccessFactors Added
  • Added the success output parameter to the CreateAssociations and RemoveAssociations stored procedures.
No
01/14/2025 9145 QBOnline Added
  • Added the TaxClassification and TaxPayment views.
  • Added the CreateTaxSummaryReport stored procedure.
No
01/10/2025 9141 GoogleAnalytics Added
  • Added the following columns to the MetaData view: DimensionDeprecatedAPINames, MetricDeprecatedAPINames, Expressions, BlockedReasons, and Category.
  • Added the folllwing dimensions to the ActiveUsers view: AudienceId, AudienceResourceName, CityId, CountryId, EventName, MinutesAgo, StreamId, and StreamName.
  • Added the following dimensions to the Events view: AudienceId, AudienceResourceName, CityId, CountryId, MinutesAgo, StreamId, and StreamName.
No
01/10/2025 9141 Kintone Added
  • Added support for Bulk Upsert.
No
01/10/2025 9141 Monday Added
  • Added the "me:read" scope to the default OAuth scopes. This scope is required to read a user's profile information.
  • The UpdatedAt column of the Board table in the Workspace schema now supports server-side filtering. Supported operators include: >, >=.
No
01/10/2025 9141 Reckon Added
  • Added the following tables: InventorySites, JobTypes, TransferInventory, TransferInventoryLineItems, Transfers, UnitOfMeasure, UnitOfMeasureDefaultUnits, UnitOfMeasureRelatedUnits, WorkersCompCodeLines, and WorkersCompCodes.
  • Added the following views: BalanceSheetDetail, BalanceSheetStandard, BalanceSheetSummary, BillingRate, EmployeeStateTaxesDetail, ItemSites, PayrollItemDetail, PayrollReviewDetail, PayrollTransactionDetail, PayrollTransactionsByPayee, ProfitAndLossDetail, ProfitAndLossStandard, and ReceivePaymentToDeposit.
  • Added the following stored procedures: ClearTransaction, GetQBFileStatus, ListMerge, SendQBXMLFile.
No
01/09/2025 9140 Pinterest Added
  • Added the following views: Catalogs, Feeds, CatalogProcessingResultItemIssues, FeedProcessingResults, CatalogTypeRetailItems, CatalogTypeHotelItems, CatalogTypeCreativeAssetsItems, CatalogHotelReport, and CatalogRetailReport.
No
01/08/2025 9139 MYOB Added
  • Added the IncludeCFToken connection property that controls whether the x-myobapi-cftoken header is appended to requests made to the MYOB API.
No
01/08/2025 9139 YahooAds Added
  • Added the FileType, ImageAssetName, ImageAssetAspectRatio, ImageAssetFileSize, ImageAssetHeight, and ImageAssetWidth columns to the Asset table.
  • Added the SmartTargetingEnabled column to the DisplayAdsAdGroups table.
  • Added the AudienceListServiceUnavailableKeyword and AudienceListServiceIsCurrentlyTotaling columns to the AudienceLists table.
  • Added the SearchAdsAssetServiceDownloadImage and SearchAdsAssetServiceUploadImage stored procedures.
  • Added the ReportSearchAdsAsset_combinations and AudienceListServiceAdvancedSegmentsAudienceListKeyword views.
Removed
  • Removed the AudienceCategoryTargetAudienceCategoryType, AudienceCategoryTargetCategoryNameEn, and AudienceCategoryTargetCategoryNameJa from the AdGroupTargets table.
  • Removed the AudienceCategoryTargetAudienceCategoryType, AudienceCategoryTargetCategoryNameEn, and AudienceCategoryTargetCategoryNameJa from the GuaranteedAdGroupAdGroupTargets view.
  • Removed the ContentRuleAudienceListIsOpen, ContentRuleAudienceListIsPreset, ContentRuleAudienceListReachPeriod, ContentRuleAudienceListRetargetingTagId, and ContentRuleAudienceListRules from the AudienceLists table.
  • Removed the following views: AudienceCategories and AudienceListContentRuleAudienceListRules.
  • Removed the DisplayAdsUpdateFeedItem stored procedure.
Updated
  • Updated the enum values for the columns in the table/view and stored procedure schema files.
Yes
01/06/2025 9137 Airtable Added
  • Added the following views to the INFORMATION_SCHEMA: Bases, Tables, BaseIndividualCollaborators, and BaseGroupCollaborators.
No
01/06/2025 9137 Monday Added
  • Added support for API version 2024-10.
  • Added the TimelineItems and CustomActivities tables to the Information schema.
  • Added the PinUpdate and UnpinUpdate stored procedures to the Information and Workspace schemas.
  • Added the Reactions and PinnedToTopItemIds columns to the Updates table in the Information schema.
No
01/06/2025 9137 OData Added
  • Added the DecodeXMLNames connection property.
No
01/06/2025 9137 QBOnline Added
  • Added the VoidPayment and VoidSalesReceipt stored procedures.
No
01/06/2025 9137 SalesLoft Changed
  • Changed the datatype of the GroupsId column in the EmailTemplates table from integer to string.
Yes
01/06/2025 9137 SharePoint Added
  • Added the SiteURL input parameter to the CreateFolder stored procedure in the REST schema.
No
01/06/2025 9137 Shopify Added
  • Added support for API Version 2024-07 which corresponds to the following new schemas: GRAPHQL-2024-07 and REST-2024-07.
  • Added the RetailLocationId column to the Orders table for schema GRAPHQL-2024-07.
  • Added the AdjustmentReason column to the PayoutTransactions view for schema REST-2024-07.
  • Added the DiscountCodes, AcceptAutomaticDiscounts, AllowDiscountCodesInCheckout, Warnings, and PlatformDiscountIds columns to the DraftOrder table for schema GRAPHQL-2024-07.
  • Added INSERT/UPDATE support for the DiscountCodes, AcceptAutomaticDiscounts, and AllowDiscountCodesInCheckout columns in the DraftOrder table for schema GRAPHQL-2024-07.
  • Added the DeliveryMethodSourceReference column to the FulfillmentOrders and AssignedFulfillmentOrders tables for schema GRAPHQL-2024-07.
  • Added the SourceType, Type, Test, Amount, AmountCurrencyCode, FeeAmount, FeeCurrencyCode, AssociatedOrderId, AssociatedOrderName, AssociatedPayoutId, and AssociatedPayoutStatus columns to the ShopifyPaymentsAccountBalanceTransactions view for schema GRAPHQL-2024-07.
  • Added the Files table for schema GRAPHQL-2024-07.
  • Added the CreateFile and UpdateFile stored procedures for schema GRAPHQL-2024-07.
  • Added the selling_plan enum value for the Metafields table's OwnerResource filter column for schema GRAPHQL-2024-07.
Changed
  • Changed the default schema to GRAPHQL-2024-07. The REST API is marked as legacy by Shopify.
Removed
  • Removed tables Countries and Provinces for schema REST-2024-07.
Yes
01/05/2025 9136 Paypal Added
  • Added the following views to the REST Schema: UserInfo, Templates, and PaymentTokens.
  • Added enum values for status and related columns across the following views in the REST Schema: OrderDetails, RefundDetails, Subscriptions, SubscriptionTransactions, TransactionReports, AuthorizationDetails, CaptureDetails, and Plans.
  • Added multiple new columns to the following views in the REST Schema: Disputes, DisputeTransactions, OrderDetails, RefundDetails, Subscriptions, SubscriptionTransactions, TransactionReports, TransactionReportsCartInfoItemDetails, PayoutDetails, PayoutItems, and PaymentTransactions.
No
01/03/2025 9134 Highrise Added
  • Added the ColorTheme column to the Accounts view.
  • Added the Parties column to the Cases table.
  • Added the SubjectData column to the Companies table.
  • Added the Attachments column to the Emails view.
  • Added the Attachments column to the Notes table.
  • Added the RecordingId column to the Tasks view.
No
01/03/2025 9134 OracleSCM Added
  • Added support for RecallNoticesrecallBusinessUnits, RecallTaskHistoryattachments, LocatorItems, CostInventoryOrgsLOV, SubinventoryItems, CostScenarios, ItemTransactionDefaults, and AvailableSupplySources views in the Inventory Management schema.
  • Added support for AssetWarrantyClaims, AssetHierarchiesLOV, and AssetWarrantyProviderRates views in the Maintenance schema.
  • Added support for WorkOrdersWorkOrderMaterialWorkOrderOperationSubstituteMaterial view in the Manufacturing schema.
  • Added support for ChannelCustomerMassClaimActions and SalesOrdersForOrderHubRequestsLinesChargesManualPriceAdjustments in the Order Management schema.
  • Added support for ProductionSchedulingPlansresourceGroupUtilization and ProductionSchedulingPlansassignedAttributeValues in the Supply Chain Planning schema.
No
01/03/2025 9134 Slack Added
  • Added a new table, Bookmarks.
No
01/02/2025 9133 DocuSign Added
  • Added support for the following views: SharedAccessUser, SharedAccessEnvelopes, SharedAccessTemplates, SharedAccessFolders, PrincipalUserAuthorizations, and AgentUserAuthorizations.
No
01/02/2025 9133 MongoDB Added
  • Added the connection property, Compression, to support MongoDB's compression feature.
No
01/01/2025 9132 Kintone Added
  • Added support for the REST and USER data models, including the following views in the USER data model: Users, UserGroups, and UserDepartments.
No
12/31/2024 9131 Asana Added
  • Added the Allocations and TaskTemplates tables.
  • Added the TaskDependencies, TaskDependents, and TimePeriods views.
  • Added the InstantiateTaskFromTemplate stored procedure.
No
12/30/2024 9130 Azure Added
  • Added support for AzureServicePrincipal and AzureServicePrincipalCert authentication.
No
12/30/2024 9130 Smartsheet Added
  • Added the UseIdAsTableName connection property. This property determines whether the provider uses IDs instead of sheet and report names as table identifiers.
No
12/27/2024 9127 OracleERP Added
  • Added the UploadedText input parameter to the following stored procedures: UploadInvoicesAttachment, UploadReceivablesCreditMemosAttachment, UploadReceivablesInvoicesAttachment, UploadStandardReceiptsAttachment, UploadDraftPurchaseOrdersLinesAttachment, UploadPurchaseRequisitionsAttachment, and UploadSuppliersAttachment.
Changed
  • Changed the data type of CurrencyUnitPrice in the RequisitionProductDetails view from long to decimal.
Yes
12/27/2024 9127 PingOne Added
  • Added the following views to the Environment Data Model: ParentGroupAssociations, UserGroupAssociations, UserLinkedAccounts, IdentityProviders, IdentityProviderAttributeMappings, AuthenticationPolicies, Agreements, UserAgreementConsents, UserOAuthScopeConsents, ApplicationGrants, ApplicationAttributeMappings, ApplicationAuthenticationPolicyAssignments, Resources, ResourceScopes, ResourceAttributeMappings.
No
12/27/2024 9127 QBOnline Added
  • Added the ThrowMoreDataError connection property. This property throws an exception if the date range in the report exceeds the allowed range message returned by the API.
No
12/27/2024 9127 Square Added
  • Added support for the following stored procedures in the v2 Data Model: CancelPaymentByIdempotencyKey, CancelPayment, and CompletePayment.
No
12/23/2024 9123 LinkedIn Added
  • Added the INSERT, UPDATE, and DELETE operations for the Comments table.
No
12/20/2024 9120 Dynamics365BusinessCentral Changed
  • Exposed a new connection property, minimumColumnSize.
No
12/20/2024 9120 Exchange Added
  • Added the following connection property: UseInplaceArchive. It is a boolean that defaults to false. When set to true, operations on the inbox and deleted items folders are executed in the inplace archive's inbox and deleted items folders instead. The affected operations are CreateFolder, CreateItem, FindFolder, FindItem, and SendItem, which apply only when the schema is Exchange Web Services (EWS).
No
12/20/2024 9120 HubSpot Added
  • Added the ErrorMessage and ErrorCode output fields to the following stored procedures: CreateCustomObject, CreateCustomProperty, DeleteCustomObject, DeleteCustomProperty, UpdateCustomObject, and UpdateCustomProperty.
No
12/20/2024 9120 PCASales Added
  • Added the ZeiritsuUchiwakeOutputHikazei column to the KihonJoho table.
No
12/20/2024 9120 SalesLoft Added
  • Added the Conversations view.
Removed
  • Removed the ConversationsCalls view.
Yes
12/20/2024 9120 SAPGateway Added
  • "OAuthPKCE" is now a supported value for the AuthScheme connection property. Set this value to authenticate with the Proof Key of Code Exchange (PKCE) extension of the standard OAuth 2.0 flow.
No
12/20/2024 9120 Square Added
  • Added support for the OrderEntries endpoint.
No
12/20/2024 9120 TSheets Changed
  • Exposed CustomFields as an individual "customfields" column in 4 tables: JobCodes, CurrentUser, ProjectReport, and TimesheetsDeleted.
No
12/20/2024 9120 YahooShopping Added
  • Added the following columns to the OrderDetails table: ChannelGoodsPlanId, ChannelGoodsPlanName, InsuranceStatus, ShipCompanyMethodCode, ShipCompanyReceivedDatetime, and ShipContactlessDeliveryCode.
No
12/19/2024 9119 AzureDevOps Changed
  • Changed the primary key of WorkItemsHistory from Id to a composite key consisting of Id and WorkItemId. Since the Id is not unique, using the composite key insures that the result set contains all applicable records.
Yes
12/18/2024 9118 Airtable Added
  • Added the INFORMATION_SCHEMA schema with the following views: Groups, GroupMembers, WorkspaceGroupCollaborators, and WorkspaceIndividualCollaborators.
No
12/18/2024 9118 Gmail Changed
  • Changed the OAuthJWTSubject connection property to be required for AuthScheme=OAuthJWT and exposed the optional OAuthJWTIssuer property for consistency with other Google providers.
Yes
12/18/2024 9118 SalesLoft Added
  • Added support for the "integration" task type in the Tasks table. The "integration" value is now accepted in the TaskType column. Additionally, the following integration-related columns have been added: IntegrationId, IntegrationName, IntegrationStepId, IntegrationTaskId, and IntegrationTaskTypeLabel.
No
12/18/2024 9118 SAP Added
  • Added the MapRAWToVarchar connection property. When set to True, this property maps the SAP RAW and LRAW types to Varchar type.
No
12/17/2024 9117 AmazonMarketplace Added
  • Added support for accessing the Ireland Marketplace by specifying it in the Marketplace schema connection property.
Removed
  • Views (Seller Central Data Model): InboundPreparationInstructions, InboundShipmentPreorders, and InboundShipmentTransportDetails.
  • Table (Seller Central Data Model): InboundShipmentTransportDetails.
  • Stored procedures (Seller Central Data Model): ConfirmInboundShipmentPreorder, ConfirmInboundShipmentTransport, CreateInboundShipmentPlan, and EstimateInboundShipmentTransport.
Replaced
  • InboundShipmentPreorders table (Seller Central Data Model) is replaced by InboundShipmentContentUpdatePreview.
  • InboundShipmentTransportDetails view (Seller Central Data Model) is replaced by InboundTransportationOptions.
  • ConfirmInboundShipmentTransport and ConfirmInboundShipmentPreorder stored procedures (Seller Central Data Model) are replaced by ConfirmTransportationOptions and ConfirmShipmentContentUpdatePreview respectively.
  • CreateInboundShipmentPlan is replaced by INSERT operation in InboundPlan table (Seller Central Data Model).
Added
  • Added the SalesRankings column to the CompetitivePricing view in the SellerCentral schema. This column contains the JSON aggregate of sales rank information for the specified item.
Removed
  • Removed the ProductCategoryId and Rank columns from the CompetitivePricing view in the SellerCentral schema.
Yes
12/17/2024 9117 ApacheKafka Added
  • Added support for reading data using multiple versions of Avro schemas from Confluent registries. Refer to the documentation for the SchemaMergeMode property to understand how different modes impact the data model and their applicable restrictions.
No
12/17/2024 9117 Dynamics365BusinessCentral Changed
  • Exposed the Pagesize connection property.
No
12/17/2024 9117 Monday Added
  • Added the BoardURL column to the Groups table in the Information schema.
No
12/17/2024 9117 SAP Added
  • Added the MapNUMCToVarchar connection property. This property allows the client to map SAP NUMC and ACCP fields as numeric types.
No
12/17/2024 9117 Shopify Removed
  • Removed the AcceptsMarketing column from the Customers table in:
    • GRAPHQL-2023-04
    • GRAPHQL-2023-07
    • GRAPHQL-2023-10
  • Removed the FulfillmentId key from the FulfillmentTrackingInfo table in:
    • GRAPHQL-2023-04
    • GRAPHQL-2023-07
    • GRAPHQL-2023-10
    • GRAPHQL-2024-01
    • GRAPHQL-2024-04
Changed
  • Changed keys to AbandonedCheckoutPayloadId, ProductId, and VariantId (AbandonmentProductsAddedToCart table) in:
    • GRAPHQL-2023-04
    • GRAPHQL-2023-07
    • GRAPHQL-2023-10
    • GRAPHQL-2024-01
    • GRAPHQL-2024-04
Added
  • Added the RefundId column to the RefundTransactionFees and RefundLineItemDuties tables in:
    • GRAPHQL-2023-04
    • GRAPHQL-2023-07
    • GRAPHQL-2023-10
    • GRAPHQL-2024-01
    • GRAPHQL-2024-04
  • Added the CollectionId (CollectionProducts), Key (DraftOrderCustomAttributes, DraftOrderLineItemCustomAttributes, OrderCustomAttributes, OrderLineItemCustomAttributes), and PublicationId (PublicationCollections) keys in:
    • GRAPHQL-2023-04
    • GRAPHQL-2023-07
    • GRAPHQL-2023-10
    • GRAPHQL-2024-01
    • GRAPHQL-2024-04
Yes
12/16/2024 9116 AvalaraAvatax Added
  • Added the following views: PostalCodes, Regions, TaxRatesByAddress, and TaxRatesByZipCode.
No
12/16/2024 9116 Outreach Removed
  • Removed SpecialProfileExists from the stored procedure because it is non-functional.
Yes
12/13/2024 9113 DocuSign Added
  • Added the AccountPermissionProfiles and BulkSendBatch views.
No
12/13/2024 9113 FHIR Changed
  • Migrated insurance-related columns from the Claim view into the new ClaimsInsurances view.
Added
  • Added the ClaimsInsurances column to the Claim table. This is an aggregate column that holds the content of the Insurance node.
Yes
12/13/2024 9113 Jira Added
  • Added the ProjectId and ProjectName columns to the Comments and Attachments tables.
No
12/13/2024 9113 ZohoCreator Added
  • Added the ShowHiddenColumns connection property. This property toggles the display of hidden columns in query results.
No
12/12/2024 9112 DBAmpSalesforce Added
  • Added the BulkAPIVersion connection property. This property controls the version of the Bulk API used by the driver. The default is v1.
  • Added support for the Ingest API v2. To use this API, set BulkAPIVersion to v2.
Changed
  • The default version of the Salesforce API used by the driver (set in the APIVersion connection property) has changed from 61.0 to 62.0.
No
12/12/2024 9112 FinancialForce Added
  • Added the BulkAPIVersion connection property. This property controls the version of the Bulk API used by the driver. The default is v1.
  • Added support for the Ingest API v2. To use this API, set BulkAPIVersion to v2.
Changed
  • The default version of the FinancialForce API used by the driver (set in the APIVersion connection property) has changed from 61.0 to 62.0.
No
12/12/2024 9112 Jira Added
  • Added the ItemURL column to Worklogs table.
No
12/12/2024 9112 Salesforce Added
  • Added the BulkAPIVersion connection property. This property controls the version of the Bulk API used by the driver. The default is v1.
  • Added support for the Ingest API v2. To use this API, set BulkAPIVersion to v2.
Changed
  • The default version of the Salesforce API used by the driver (set in the APIVersion connection property) has changed from 61.0 to 62.0.
No
12/12/2024 9112 SAPByDesign Added
  • Added the MaxReportDimension connection property. This property sets the default number of dimensions that are requested by the driver when executing SELECT * queries.
No
12/12/2024 9112 UMSaaSCloud Added
  • Added the BulkAPIVersion connection property. This property controls the version of the Bulk API used by the driver. The default is v1.
  • Added support for the Ingest API v2. To use this API, set BulkAPIVersion to v2.
Changed
  • The default version of the Salesforce API used by the driver (set in the APIVersion connection property) has changed from 61.0 to 62.0.
No
12/11/2024 9111 GoogleSpanner Changed
  • The logic for supporting complex data types has been refactored to extend support and resolve issues with the array data type during record insertion and retrieval. JSON standards now represent complex values that apply to both reads and writes.
No
12/11/2024 9111 SalesLoft Added
  • Added the UserGUID column for Calls table.
No

We appreciate your feedback.  If you have any questions, comments, or suggestions about this entry, please contact our support team at [email protected].