SSIS Components for Stripe

Build 24.0.9062

Reviews

Queries the reviews.

Table Specific Information

Select

The 本製品 uses the Stripe API to filter the results by the following columns and operators:

  • Id and AccountId supports the following operator: =.
  • Created supports the following operators: >, >=, <, <=, =.

The rest of the filter is executed client-side within the 本製品.

You can select from Reviews with the following queries:

    SELECT * FROM Reviews WHERE Id = '123321'
    SELECT * FROM Reviews WHERE Created >= '2023-07-14T05:36:46.000-04:00'

Columns

Name Type References Description
Id [KEY] String The Id of the reviews.
BillingZip String The ZIP or postal code of the card used, if applicable.
Charge String The charge associated with this review.
ClosedReason String The reason the review was closed, or null if it has not yet been closed.
Created Datetime Time at which the object was created. Measured in seconds since the Unix epoch.
IpAddress String The IP address where the payment originated.
IpAddressLocation String Information related to the location of the payment.
Livemode Boolean true if the object exists in live mode andfalse if in test mode.
Open Boolean If true, the review needs action.
OpenedReason String The reason the review was opened. Either rule or manual.
PaymentIntent String The PaymentIntent ID associated with this review, if one exists.
Reason String The reason the review is currently open or closed. Possible values are rule, manual, approved, refunded, refunded_as_fraud, disputed, or redacted.
Session String Information related to the browsing session of the user who initiated the payment.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
AccountId String The Id of the connected account to be reviewed.

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