SSIS Components for Stripe

Build 24.0.9062

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062