CData Python Connector for Stripe

Build 23.0.8839


Queries the reviews.

Table Specific Information


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 本製品.

The provider supports the use of all columns as criteria in the WHERE clause of SELECT statements, as long as SupportEnhancedSQL is set to True. If the SupportEnhancedSQL property is set to False, you still can retrieve:

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


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.


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 23.0.8839