CheckoutSessionLineItems
Returns a list of Checkout Sessions.
Table Specific Information
Select
Server-Side Query Support
The connector 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 connector.
- 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. |