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.
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. |