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 support 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:
To query the CheckoutSessionLineItems we can try the below queries.
SELECT * from CheckoutSessionLineItems
SELECT * from CheckoutSessionLineItems where checkoutsessionid = 'cs_test_c1niqxjO1iwaT5asACq3TXhErRm3T7iuPV6AEbcP5ReTfutnEloisMpGol'
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. |