Events
Returns the available events in Stripe.
View-Specific Information
SELECT
The add-in uses the Stripe API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the add-in.
| Column | Supported Operators |
| Id | = |
| Type | = |
| AccountId | = |
| Created | <, >, >=, <, <=, = |
You can select:
- An event by specifying its Id:
SELECT * FROM Events WHERE Id = 'dp_12345678'
- Events that happened after a specific date:
SELECT * FROM Events WHERE Created > '2018-01-01'
- Created can also be used twice to specify a range:
SELECT * FROM Events WHERE Created >= '2018-01-01 00:00:00.0' AND Created <= '2018-12-31 23:59:59.0'
- Created can also be used twice to specify a range:
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The Id of the event. | |
| ApiVersion | String | The Stripe API version used to render data. | |
| Created | Datetime | The date and time at which the event was created. | |
| ObjectId | String | The Id of the object related to the event. | |
| ObjectName | String | The object name for which the event occurred. | |
| Livemode | Boolean | Indicates whether the event is in live mode. | |
| PendingWebhooks | Integer | The number of webhooks yet to be delivered successfully (return a 20x response) to the URLs you have specified. | |
| RequestId | String | The Id of the API request that caused the event. | |
| RequestIdempotencyKey | String | The idempotency key transmitted during the request, if any. Note: This property is populated only for events on or after May 23, 2017. | |
| Type | String | The type of the event. | |
| Description | String | An arbitrary string attached to the object. Often useful for displaying to users. The description field on invoice line items has a maximum character length limit of 500. | |
| PreviousAttributes | String | An object containing the names of the attributes that have changed. | |
| DataObject | String | An object containing the API resource relevant to the event. | |
| DataObjectAmount | Integer | The data object amount. | |
| DataObjectAmountCapturable | Integer | The data object capturable amount. | |
| DataObjectAmountDetails | String | The data object amount details. | |
| DataObjectAmountReceived | Integer | The data object received amount. | |
| DataObjectApplication | String | The data object application. | |
| DataObjectApplicationFeeAmount | String | The data object application fee amount. | |
| DataObjectAutomaticPaymentMethods | String | The data object automatic payment methods. | |
| DataObjectCanceledAt | Datetime | The date and time at which the data object was canceled. | |
| DataObjectCancellationReason | String | The cancellation reason. | |
| DataObjectCaptureMethod | String | The capture method. | |
| DataObjectClientSecret | String | The client secret. | |
| DataObjectConfirmationMethod | String | The confirmation method. | |
| DataObjectCreated | Datetime | The created timestamp. | |
| DataObjectCurrency | String | The currency code. | |
| DataObjectCustomer | String | The customer Id. | |
| DataObjectDescription | String | The description. | |
| DataObjectInvoice | String | The invoice Id of the data object. | |
| DataObjectLastPaymentError | String | The last payment error. | |
| DataObjectLatestCharge | String | The latest charge. | |
| DataObjectLivemode | Boolean | The boolean value of livemode. | |
| DataObjectMetadata | String | The metadata. | |
| DataObjectNextAction | String | The next action details. | |
| DataObjectOnBehalfOf | String | The account on behalf of which the charge is made. | |
| DataObjectPaymentMethod | String | The payment method. | |
| DataObjectPaymentMethodConfigurationDetails | String | The payment method configuration details. | |
| DataObjectPaymentMethodOptions | String | The payment method options. | |
| DataObjectPaymentMethodTypes | String | The payment method types. | |
| DataObjectProcessing | String | The processing details. | |
| DataObjectReceiptEmail | String | The receipt email. | |
| DataObjectReview | String | The review. | |
| DataObjectSetupFutureUsage | String | The setup future usage. | |
| DataObjectShipping | String | The shipping details. | |
| DataObjectSource | String | The source. | |
| DataObjectStatementDescriptor | String | The statement descriptor. | |
| DataObjectStatementDescriptorSuffix | String | The statement descriptor suffix. | |
| DataObjectStatus | String | The status. | |
| DataObjectTransferData | String | The transfer data. | |
| DataObjectTransferGroup | String | The transfer group. |
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 get events for. |