CheckoutSessionLineItems
Returns a list of Checkout Sessions.
Table Specific Information
Select
Server-Side Query Support
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 本製品.
- CheckoutSessionId supports the following operator: =.
You can select from CheckoutSessionLineItems with the following queries:
SELECT * FROM CheckoutSessionLineItems WHERE CheckoutSessionId = 'cs_test_c1niqxjO1iwaT5asACq3TXhErRm3T7iuPV6AEbcP5ReTfutnEloisMpGol' SELECT * FROM CheckoutSessionLineItems WHERE Currency = 'usd' SELECT * FROM CheckoutSessionLineItems WHERE AmountTotal > 5000 SELECT * FROM CheckoutSessionLineItems WHERE PriceLiveMode = true
Columns
Name | Type | References | Description |
Id [KEY] | String | The Id of the Checkout Session line item. | |
CheckoutSessionId | String | The Id of the Checkout Session | |
Object | String | String representing the objects type. Objects of the same type share the same value. | |
AmountDiscount | Integer | Total discount amount applied. If no discounts were applied, defaults to 0. | |
AmountTax | Integer | Total tax amount applied. If no tax was applied, defaults to 0. | |
AmountSubtotal | Integer | Total before any discounts or taxes are applied. | |
AmountTotal | Integer | Total after discounts and taxes. | |
Currency | String | Three-letter ISO currency code, in lowercase. Must be a supported currency. | |
Description | String | An arbitrary string attached to the object. Often useful for displaying to users. Defaults to product name. | |
Discounts | String | The discounts applied to the line item. | |
PriceId | String | Unique identifier for the object. | |
PriceObject | String | String representing the object’s type. Objects of the same type share the same value. | |
PriceActive | Boolean | Whether the price can be used for new purchases. | |
PriceBillingScheme | String | Describes how to compute the price per period. | |
PriceCreated | Datetime | Time at which the object was created. Measured in seconds since the Unix epoch. | |
PriceCurrency | String | Three-letter ISO currency code, in lowercase. Must be a supported currency. | |
PriceCustomUnitAmountMaximum | Integer | The maximum unit amount the customer can specify for this item. | |
PriceCustomUnitAmountMinimum | Integer | The minimum unit amount the customer can specify for this item. | |
PriceCustomUnitAmountPreset | Integer | The starting unit amount which can be updated by the customer. | |
PriceLiveMode | Boolean | Has the value true if the object exists in live mode or the value false if the object exists in test mode. | |
PriceLookupKey | String | A lookup key used to retrieve prices dynamically from a static string. This may be up to 200 characters. | |
PriceMetadata | String | Set of key-value pairs that you can attach to an object. | |
PriceNickName | String | A brief description of the price, hidden from customers. | |
PriceProduct | String | The ID of the product this price is associated with. | |
PriceRecurringAggregateUsage | String | Specifies a usage aggregation strategy for prices of usage_type=metered. | |
PriceRecurringInterval | String | The frequency at which a subscription is billed. | |
PriceRecurringIntervalCount | Integer | The number of intervals | |
PriceRecurringUsageType | String | Configures how the quantity per period should be determined | |
PriceTaxBehaviour | String | Only required if a default tax behavior was not provided in the Stripe Tax settings. | |
PriceTiers | String | Each element represents a pricing tier. | |
PriceTiersMode | String | Defines if the tiering price should be graduated or volume based. | |
PriceTransformQuantityDivideBy | Integer | Divide usage by this number. | |
PriceTransformQuantityRound | String | After division, either round the result up or down. | |
PriceType | String | One of one_time or recurring depending on whether the price is for a one-time purchase or a recurring (subscription) purchase. | |
PriceUnitAmount | Integer | The unit amount in cents to be charged, represented as a whole integer if possible. | |
PriceUnitAmountDecimal | String | The unit amount in cents to be charged, represented as a decimal string with at most 12 decimal places. | |
Quantity | String | The quantity of products being purchased. | |
Taxes | String | The taxes applied to the line item. |