UsageRecords

Creates and retrieves the customer usage and metrics to Stripe for metered billing for subscription prices.

Table Specific Information

Select

The 本製品 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 本製品.

Id supports the following operator: =.
SubscriptionItem supports the following operator: =.
AccountId supports the following operator: =.

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 SupportEnhancedSQL property is set to False, you still can retrieve the UsageRecords:

To fetch UsageRecords SubscriptionItem is required

SELECT * FROM UsageRecords WHERE SubscriptionItem='si_NBswnjzMefKen7'

Insert

To create a usage record for the subscription item, atleast SubscriptionItem is required:

INSERT INTO UsageRecords (SubscriptionItem, Timestamp, Quantity) values ('si_NBswnjzMefKen7', '2023-07-14T05:36:46.000-04:00', 100)

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The Id of the usage record.
Invoice	String	True		The Id of the invoice.
Livemode	Boolean	True		true if the object is in live mode andfalse if in test mode.
PeriodEnd	Datetime	True		The time of the period end.
PeriodStart	Datetime	True		The time of the period start.
Quantity	Integer	False		The usage quantity for the specified date.
SubscriptionItem	String	True		The Id of the subscription item.
Timestamp	Datetime	False		The timestamp for the usage event.
TotalUsage	Integer	True		The total usage.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。