Events

Query the available events in Stripe.

Table Specific Information

Select

Server-Side Query Support

The adapter will use 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 adapter.

Id, Created, and Type support the following operators: <,>>=,<,<=,=.

The provider supports all columns to be used as criteria in the WHERE clause of SELECT statement, as long as SupportEnhancedSQL is set to True. If SupportEnhancedSQL property is set to False, you still can retrieve:

-an Event by specifying its Id:

SELECT * FROM Events WHERE Id = 'dp_12345678'

-Events that happened after a specific date (Created may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range):

SELECT * FROM Events WHERE Created > '2016-01-03'

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 datetime event was created.
ObjectId	String		The event Id.
ObjectName	String		The object name for which event occured.
Livemode	String		Tells if the event is in livemode.
PendingWebhooks	Integer		The number of webhooks yet to be delivered successfully (return a 20x response) to the URLs you've specified.
Request	String		The Id of the API request that caused the event.
Type	String		The description 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		Object containing the names of the attributes that have changed.

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.