Reviews
Returns radar reviews, including the charge or payment intent under review, the reason it was opened or closed, and the originating IP address and session details.
View-Specific Information
SELECT
The driver 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 driver.
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 unique identifier for the review. | |
| BillingZip | String | The ZIP or postal code of the card used, if applicable. | |
| Charge | String |
Charges.Id | 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 time at which the review 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. Has the value true if the object exists in live mode, or the value false if the object exists in test mode. | |
| Open | Boolean | Indicates whether the review needs action. | |
| OpenedReason | String | The reason the review was opened. Either rule or manual. | |
| PaymentIntent | String | The Id of the payment intent 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. |