SSIS Components for Stripe

Build 24.0.9062

変更履歴

General Changes

DateBuild
Number
Change
Type
Description
08/30/20249008StripeAdded
  • ReportTypes ビューのサポートが追加されました。
07/05/20248952StripeAdded
  • CreditNoteLineItemsDiscounts ビューのサポートが追加されました。
  • TestClocks テーブルのサポートが追加されました。
07/02/20248949StripeAdded
  • "Customers" テーブルに"SubscriptionsAggregate" カラムが追加されました。
06/28/20248945StripeRemoved
  • Cards テーブルからRecipient カラムが削除されました。
  • Charges テーブルからDestination カラムが削除されました。
  • Products テーブルからAttributesAggregate およびCaption カラムが削除されました。
  • API で廃止されたため、Orders およびSkus ビューが削除されました。
06/22/20248939StripeRemoved
  • Auto AuthScheme オプションが削除されました。AuthScheme 接続プロパティのデフォルト値はAPIKey になりました。
06/20/20248937StripeAdded
  • Events ビューにDataObject カラムが追加されました。
05/17/20248903StripeAdded
  • AvailableBalance およびPendingBalance テーブルにLiveMode カラムが追加されました。
  • Charges テーブルに21カラムが追加されました。
  • CheckoutSession テーブルにPaymentMethodOptions カラムが追加されました。
  • Events テーブルに40カラムが追加されました。
  • InvoiceLineItems テーブルに20カラムが追加されました。
  • Invoices テーブルにLines カラムが追加されました。
  • SubscriptionItems テーブルに42カラムが追加されました。
  • Subscriptions テーブルに27カラムが追加されました。

Removed
  • Charges テーブルからSourceAggregate カラムが削除されました。
  • Events テーブルからRequest カラムおよびDataObject カラムが削除されました。
05/14/20248900StripeAdded
  • CreditNoteLineItems およびCreditNotePreviewLineItems ビューが追加されました。
05/09/20248895GeneralChanged
  • 以前はROUND 関数は負の値を受け取りませんでした。その機能は復元されました。
03/22/20248847StripeAdded
  • Added column DataObject for Events view.
03/15/20248840GeneralAdded
  • Java のString.compare() 機能をSQL クエリに提供するSTRING_COMPARE という新しいSQL 関数が作成されました。2つの文字列の比較値を表す数値を返します。
02/09/20248805StripeAdded
  • Added views ApplicationFeeRefunds, ApplicationFees, Authorizations, Cardholders, IssuingCards, IssuingDisputes, Transactions, SetupAttempts, SetupIntents, FileLinks, SubscriptionSchedules, CheckoutSessionLineItems, CustomerBalanceTransactions, PaymentMethodDomains.
  • Added stored procedure DeleteCustomerDiscount and DeleteSubscriptionDiscount
  • Added CancelSubscription and ResumeSubscription stored procedure.
02/02/20248798StripeAdded
  • Added the FinalizeInvoice Stored Procedure.
02/01/20248797StripeAdded
  • Added the CancelPaymentIntent, CapturePaymentIntent and ConfirmPaymentIntent Stored Procedures.
01/31/20248796StripeAdded
  • Added the support for delete in Invoices table for deleting the draft invoices.
  • Added the VoidInvoice Stored Procedure.
01/19/20248784StripeChanged
  • Changed the data type of Amount, SourceTypeCard, SourceTypesBankAccount and SourceTypesBitcoinReceiver columns from int to long in AvailableBalance view.
  • Changed the data type of Available column from int to string in CashBalance view. As the value is returned as a hash instead of an integer.
12/22/20238756StripeChanged
  • PaymentIntent, Products and ShippingRates are now supported as tables.

Added
  • Added AutomaticPaymentMethodsAllowRedirects, PaymentMethodConfigurationDetailsId, PaymentMethodConfigurationDetailsParent columns in PaymentIntent table.
  • Added Confirm, OffSession, ErrorOnRequiresAction, Mandate, MandateDataCustomerAcceptanceType, MandateDataCustomerAcceptanceAcceptedAt, MandateDataCustomerAcceptanceOffline, MandateDataCustomerAcceptanceOnlineIPAddress, MandateDataCustomerAcceptanceOnlineUserAgent, RadarOptionsSession and ReturnURL pseudo-column in PaymentIntent table.
  • Added FeaturesAggregate column in Products table.
  • Added DeliveryEstimateMaximumUnit, DeliveryEstimateMaximumValue, DeliveryEstimateMinimumUnit, DeliveryEstimateMinimumValue and MetadataAggregate column in ShippingRates table.
12/21/20238755StripeAdded
  • Added SourcesAggregate, TaxAutomaticTax, TaxIPAddress, TaxCountry, TaxState and TaxSource column to Customers table.
  • Added TaxValidateLocation pseudo column to Customers table.

Changed
  • Changed the datatype of LiveMode column from integer to boolean in CustomerSubscriptions view.
  • Changed the key of CustomerSubscriptions view from CustomerId to Id.

Removed
  • Removed CustomerSources and CustomerTax views.
12/20/20238754StripeChanged
  • Changed the name of column SourceTypesFpx to SourceTypesBitcoinReceiver in AvailableBalance and PendingBalance views.
  • Changed the name of column SourceTypesCardAggregate to SourceTypesAggregate in PendingBalance view.
12/18/20238752StripeAdded
  • Added column CVC for Cards table

Removed
  • Removed column ResultLinksData from Reports
12/14/20238748StripeRemoved
  • Removed CustomerDiscounts and SubscriptionDiscounts views.

Added
  • Added DiscountId, DiscountCheckoutSession, DiscountCustomer, DiscountStart, DiscountEnd, DiscountInvoice, DiscountInvoiceItem, DiscountPromotionCode, DiscountSubscription, DiscountCouponCreatedAt, DiscountCouponCurrency, DiscountCouponName, DiscountCouponDuration, DiscountCouponDurationInMonths, DiscountCouponAmountOff, DiscountCouponPercentOff, DiscountCouponValid, DiscountCouponMaxRedemptions, DiscountCouponRedeemBy, DiscountCouponTimesRedeemed, DiscountCouponObject, DiscountCouponLiveMode, DiscountCouponMetadataAggregate columns in Subscriptions tables.
  • Added CouponId, DiscountCheckoutSession, DiscountCustomer, DiscountStart, DiscountEnd, DiscountInvoice, DiscountInvoiceItem, DiscountPromotionCode, DiscountSubscription, DiscountCouponCreatedAt, DiscountCouponCurrency, DiscountCouponName, DiscountCouponDuration, DiscountCouponDurationInMonths, DiscountCouponAmountOff, DiscountCouponPercentOff, DiscountCouponValid, DiscountCouponMaxRedemptions, DiscountCouponRedeemBy, DiscountCouponTimesRedeemed, DiscountCouponObject, DiscountCouponLiveMode, DiscountCouponMetadataAggregate columns in Customers tables
  • Added columns PriceDataProduct, PriceDataCurrency, PriceDataTaxBehaviour, PriceDataUnitAmount,PriceDataUnitAmountDecimal, TaxBehaviour, TaxCode for InvoiceItems table.
12/12/20238746StripeRemoved
  • Removed column Customer from Invoices table.
12/11/20238745StripeChanged
  • Updated column ResultLinksDataId column to ResultLinksDataAggregate of Reports view.
  • Changed the data type of InventoryValue column from Double to String in Skus view.

Removed
  • Removed columns ResultLinksDataObject, ResultLinksDataCreated, ResultLinksDataExpired, ResultLinksDataExpiresAt, ResultLinksDataFile, ResultLinksDataLivemode, ResultLinksDataMetaDataAggregate, ResultLinksDataUrl of Reports view
12/08/20238742StripeAdded
  • Added PauseCollectionResumesAt, PauseCollectionBehavior, PendingInvoiceItemIntervalCount, CancellationDetailsFeedback, CancellationDetailsComment, CancellationDetailsReason, Currency, TrialSettingsEndBehaviorPaymentMethod, OnBehalfOf columns in the Subscriptions table.

Removed
  • Removed AutomaticTaxStatus, PauseCollection, CancellationDetails columns from Subscriptions table.

Changed
  • Updated column name Start to StartDate in Subscriptions table.
12/07/20238741StripeAdded
  • Added PaymentMethodDetails column in the Disputes table.
  • Added Submit Psuedo column in the Disputes table.
12/06/20238740StripeChanged
  • Changed Description to Psuedo column as its gets updated in the Metadata field in the TransferReversals table.
12/05/20238739StripeRemoved
  • Removed RecurringAggregate and TransformQuantity columns from Prices Table.

Added
  • Added CustomUnitAmountMaximum, CustomUnitAmountMinimum, CustomUnitAmountPreset, TransformQuantityDivideBy, TransformQuantityRound, RecurringInterval, RecurringAggregateUsage, RecurringIntervalCount, RecurringUsageType columns in the Prices table.
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
09/07/20238650StripeAdded
  • Added ApproveReview, AccpetQuote, CancelQuote, DownloadFile, DownloadQuote, FinalizeQuote, UploadFile, VoidCreditNotes stored procedures.
08/30/20238642StripeAdded
  • Added CashBalance, EarlyFraudWarning, Files, and Reviews views.
  • Added CheckoutSession, CreditNotes, Persons, PromotionCodes, Quotes, TaxRates, TopUps, UsageRecords, ValueListItems, and ValueLists tables.
08/01/20238613StripeAdded
  • Added EffectiveAt column in Invoices table.
  • Added CashAppBuyerId, CashAppCashTag, PaypalPayerId, PaypalPayerEmail columns and Enum type zip in the PaymentMethods table.
07/28/20238609StripeChanged
  • Added Created as server-side filterable column for Accounts table.
  • Added Date as server-side filterable column for InvoiceItems table.
06/20/20238571GeneralAdded
  • Added the new sys_lastresultinfo system table.
06/07/20238558StripeAdded
  • Added AmountShipping, ShippingDetails, ShippingCost columns in Invoices table.
  • Added CustomFields aggregate column in PaymentLinks table.
  • Added CancellationDetails column in Subscriptions table.
06/04/20238555StripeAdded
  • Added CustomerSources, CustomerSubscriptions, CustomerTax, InvoiceDiscounts, InvoiceItemDiscounts, InvoiceLineItemDiscounts child views.

Removed
  • Removed SourcesdataAggregate, TaxAggregate from Customers table and are now implemented as a child views.
05/24/20238544StripeAdded
  • Added update functionality in Disputes Table.
05/16/20238536StripeChanged
  • Updated the API version to 2022-11-15.

Removed
  • Removed SubscriptionsDataAggregate column from Customers table.
  • Removed Charges column from PaymentIntent table. As it was deprecated in the Stripe API, LatestCharge column will have the data of Charges column.
05/11/20238531SSISRemoved
  • Removed support for SQL Server Integration Services 2012 and Visual Studio 2012/2013.
04/25/20238515GeneralRemoved
  • Removed support for the SELECT INTO CSV statement. The core code doesn't support it anymore.
02/01/20238432StripeAdded
  • Added PaymentMethods Table.
  • Added AttachPaymentMethodToCustomer and DetachPaymentMethodFromCustomer Stored Procedures.
01/12/20238412StripeAdded
  • Added PaymentIntent view.
01/03/20238403StripeAdded
  • Added ShippingRates and PaymentLinkLineItems view.
  • Added PaymentLinks table.
12/14/20228383GeneralChanged
  • Added the Default column to the sys_procedureparameters table.
12/06/20228375StripeChanged
  • The InvoiceLineItems table is renamed to InvoiceItems.

Added
  • Added InvoiceLineItems table that will lists the line items of an invoice.
12/05/20228374SSISAdded
  • Added support for SQL Server Integration Services 2022 and Visual Studio 2022
09/30/20228308GeneralChanged
  • Added the IsPath column to the sys_procedureparameters table.
09/26/20228304StripeChanged
  • The Accounts table will now show only authenticated account details in case of OAuth.
08/18/20228265SSISChanged
  • Changed Azure module to Az module.
08/16/20228263StripeAdded
  • Added the pseudo-column PendingInvoiceItemsBehavior to the Invoices table.
05/10/20228165StripeAdded
  • Added columns from the 2020-08-27 schema.
04/29/20228154StripeChanged
  • Changed the data type of Type column on the Accounts table from boolean to string.
  • Changed the data type of Amount column on the Plans table from decimal to int.
10/13/20217956StripeRemoved
  • Removed the BalanceHistory table, as it was deprecated in in the Stripe API.

Replacements
  • Use the BalanceTransactions table as a replacement. This is recommended by Stripe.
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.
07/22/20217873SSISAdded
  • Added a UI type editor for the SQLStatement property of the SQLExecutor component.
05/26/20217816SSISAdded
  • Added support for semicolon-separated SQL queries.
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/20217776SSISAdded
  • Added a create table button for the Destination Component to make it easier to add a new destination in SSIS.
  • Improved user experience for Source Component by allowing users to select columns via a new checkbox dialog.

Changed
  • Improved query dialog for building parameterized statements.

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