PaymentLinkLineItems
Query the available PaymentLink line items in Stripe.
Table Specific Information
Select
The add-in 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 add-in.
- PaymentLinkId supports the following operator: =.
- AccountId supports the following operator: =.
You can select from PaymentLinkLineItems with the following queries:
SELECT * FROM PaymentLinkLineItems WHERE PaymentLinkId = 'plink_1MHJbZSC4snQ4WkOqF4MChgG' SELECT * FROM PaymentLinkLineItems WHERE PaymentLinkId = 'plink_1MHJbZSC4snQ4WkOqF4MChgG' AND AccountId = 'acct_1MGcyqSC4snQ4WkO'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Id of the PaymentLinkLineItems. | |
| PaymentLinkId | String |
PaymentLinks.Id | 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. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| 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. |