Reviews
Queries the reviews.
Table Specific Information
Select
The connector 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 connector.
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 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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| AccountId | String | The Id of the connected account to be reviewed. |