ADO.NET Provider for Stripe

Build 23.0.8839


Query the available PaymentLink line items in Stripe.

Table Specific Information


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

  • PaymentLinkId supports the following operator: =.
  • AccountId supports the following operator: =.

SELECT * FROM PaymentLinkLineItems WHERE PaymentLinkId = 'plink_1MHJbZSC4snQ4WkOqF4MChgG'
SELECT * FROM PaymentLinkLineItems WHERE PaymentLinkId = 'plink_1MHJbZSC4snQ4WkOqF4MChgG' AND AccountId = 'acct_1MGcyqSC4snQ4WkO'


Name Type References Description
Id [KEY] String Id of the PaymentLinkLineItems.
PaymentLinkId String


Payment Links Id.
AmountDiscount Integer Total discount amount applied. If no discounts were applied, defaults to 0.
AmountSubtotal Integer Total before any discounts or taxes are applied.
AmountTax Integer Total tax amount applied. If no tax was applied, defaults to 0.
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.
Object String Name of the Object.
PriceActive Boolean Whether the price can be used for new purchases.
PriceBillingScheme String How to compute the price per period. Either per_unit or tiered. per_unit indicates that the fixed amount (specified in unit_amount or unit_amount_decimal) will be charged per unit in quantity (for prices with usage_type=licensed), or per unit of total usage (for prices with usage_type=metered). tiered indicates that the unit pricing will be computed using a tiering strategy as defined using the tiers and tiers_mode attributes.
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.
PriceCustomUnitAmount String When set, provides configuration for the amount to be adjusted by the customer during Checkout Sessions and Payment Links.
PriceId String Id of the price.
PriceLivemode Boolean True if the object exists in live mode. 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.
PriceNickname String A brief description of the price, hidden from customers.
PriceObject String The object name for the price.
PriceProduct String The ID of the product this price is associated with.
PriceRecurring String The recurring components of a price such as interval and usage_type.
PriceTaxBehavior String Specifies whether the price is considered inclusive of taxes or exclusive of taxes. One of inclusive, exclusive, or unspecified. Once specified as either inclusive or exclusive, it cannot be changed.
PriceTiersMode String Each element represents a pricing tier. This parameter requires billing_scheme to be set to tiered. See also the documentation for billing_scheme. This field is not included by default. To include it in the response, expand the tiers field.
PriceTransformQuantity String Apply a transformation to the reported usage or set quantity before computing the amount billed. Cannot be combined with tiers.
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 paise to be charged, represented as a whole integer if possible. Only set if billing_scheme=per_unit.
PriceUnitAmountDecimal Decimal The unit amount in paise to be charged, represented as a decimal string with at most 12 decimal places. Only set if billing_scheme=per_unit.
Quantity Integer The quantity of the products being purchased.


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

Name Type Description
AdjustableQuantityEnabled Boolean Set to true if the quantity can be adjusted to any non-negative Integer.
AdjustableQuantityMinimum Integer The maximum quantity the customer can purchase. By default this value is 99. You can specify a value up to 999.
AdjustableQuantityMaximum Integer The minimum quantity the customer can purchase. By default this value is 0. If there is only one item in the cart then that item quantity cannot go down to 0.
AccountId String The Id of the connected account.

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