Reviews
Returns the reviews in Stripe.
View-Specific Information
SELECT
The connector uses the Stripe API to filter the results by the following columns and operators:
| Column | Supported Operators |
| Id | = |
| AccountId | = |
| Created | >, >=, <, <=, = |
The rest of the filter is executed client-side within the connector.
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 review. | |
| 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 | The date and 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 | Indicates whether the object exists in live mode. The value is true in live mode and false 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. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| AccountId | String | The Id of the connected account to be reviewed. |