ADO.NET Provider for Stripe

Build 24.0.9062

Prices

Create, update, and query the available prices in Stripe.

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

  • Id supports the following operator: =.
  • Active supports the following operator: =.
  • Created supports the following operators: =, >=, <=, >, <.
  • Currency supports the following operator: =.
  • LookupKey supports the following operator: =.
  • MetadataAggregate supports the following operator: =.
  • Product supports the following operator: =.
  • RecurringInterval supports the following operator: =.
  • RecurringUsageType supports the following operator: =.
  • Type supports the following operator: =.
  • AccountId supports the following operator: =.

You can select:

Price by specifying its Id:

SELECT * FROM Prices WHERE Id = 'price_1HeiRmATXQzBWNrlQOSoEytH'

Prices created after a specific date(Created may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range):

SELECT * FROM Plans WHERE Created > '2016-01-03'

Insert

ProductId or ProductName, and Currency are required to create a price:

INSERT INTO Prices (Active, BillingScheme, LookupKey, Nickname, Currency, Product, RecurringInterval, RecurringAggregateUsage, RecurringIntervalCount, RecurringUsageType, TransformQuantityDivideBy, TransformQuantityRound, UnitAmount, TaxBehavior) VALUES (true, 'per_unit', 'def', 'test_insert', usd, 'prod_P8AoSHyvPlfYMp', 'month', 'max', 3, 'metered', 2, 'up', 10, 'unspecified') 

INSERT INTO Prices (Active, BillingScheme, Currency, LookupKey, MetadataAggregate, Nickname, Product, RecurringInterval, RecurringAggregateUsage, RecurringIntervalCount, RecurringUsageType, Tiersmode, TiersAggregate) values (false, 'tiered', 'usd', 'TestKey5', '[{\"A\":\"BCD\",\"E\":\"FGH\",\"I\":\"JKL\"}]', 'Nickname1', 'prod_PDm7du7ErjMSwY', 'week', 'last_during_period', 5, 'metered', 'volume', '[{\"up_to\":\"inf\",\"flat_amount_decimal\":\"356\",\"unit_amount_decimal\":\"785\"}]') 

Update

To update a price, specify the Id:

UPDATE Prices SET Active = false, MetadataAggregate = '{\"title\" : \"test price\"}'  WHERE Id = 'price_1HeiRmATXQzBWNrlQOSoEytH'

Delete

Delete is not supported.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

The Id of the price.

Active Boolean False

Whether the price can be used for new purchases.

BillingScheme String False

Describes how to compute the price per period.

Created Datetime True

The creation date.

Currency String False

Currency in which subscription will be charged.

CustomUnitAmountEnabled Boolean False

Pass in true to enable custom_unit_amount, otherwise omit custom_unit_amount.

CustomUnitAmountMaximum Integer False

The maximum unit amount the customer can specify for this item.

CustomUnitAmountMinimum Integer False

The minimum unit amount the customer can specify for this item. Must be at least the minimum charge amount.

CustomUnitAmountPreset Integer False

The starting unit amount which can be updated by the customer.

LookupKey String False

A lookup key used to retrieve prices dynamically from a static string.

MetadataAggregate String False

Set of key-value pairs that you can attach to an object.

Nickname String False

A brief description of the plan, hidden from customers.

Product String False

Products.Id

The Id of the product this price is associated with.

ProductDataName String False

These fields can be used to create a new product that this price will belong to. The product's name, meant to be displayable to the customer.

ProductDataActive Boolean False

These fields can be used to create a new product that this price will belong to. Whether the product is currently available for purchase. Defaults to true.

ProductDataMetadata String False

These fields can be used to create a new product that this price will belong to. Set of key-value pairs that you can attach to an object.

ProductDataStatementDescriptor String False

These fields can be used to create a new product that this price will belong to. An arbitrary string to be displayed on your customer's credit card or bank statement.

ProductDataTaxCode String False

These fields can be used to create a new product that this price will belong to. A tax code ID.

ProductDataUnitLabel String False

These fields can be used to create a new product that this price will belong to. A label that represents units of this product. When set, this will be included in customers' receipts, invoices, Checkout, and the customer portal.

RecurringInterval String False

The frequency at which a subscription is billed. One of day, week, month or year.

使用できる値は次のとおりです。day, month, week, year

RecurringAggregateUsage String False

Specifies a usage aggregation strategy for prices of usage_type=metered.

RecurringIntervalCount Integer False

The number of intervals (specified in the interval attribute) between subscription billings. For example, interval=month and interval_count=3 bills every 3 months.

RecurringUsageType String False

Configures how the quantity per period should be determined. Can be either metered or licensed. Defaults to licensed.

使用できる値は次のとおりです。licensed, metered

Type String True

Value is either 'one_time' or 'recurring' depending on whether the price is for a one-time purchase or a recurring (subscription) purchase.

使用できる値は次のとおりです。one_time, recurring

TiersAggregate String False

Array of elements representing a pricing tier.

TiersMode String False

Defines if the tiering price should be graduated or volume based.

TransformQuantityDivideBy Integer False

Apply a transformation to the reported usage or set quantity before computing the billed price. Cannot be combined with tiers. Divide usage by this number.

TransformQuantityRound String False

Apply a transformation to the reported usage or set quantity before computing the billed price. Cannot be combined with tiers. After division, either round the result up or down.

UnitAmount Integer False

The unit amount in paise to be charged, represented as a whole integer if possible.

UnitAmountDecimal String False

The unit amount in paise to be charged, represented as a decimal string

Object String True

String representing the object's type. Objects of the same type share the same value.

Livemode Boolean True

Has the value true if the object exists in live mode or the value false if the object exists in test mode.

TaxBehavior String False

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.

ProductDataDefaultPrice String True

These fields can be used to view the fields of the product that this price will belong to. The ID of the Price object that is the default price for this product.

ProductDataDescription String True

These fields can be used to view the fields of the product that this price will belong to. The product’s description, meant to be displayable to the customer. Use this field to optionally store a long form explanation of the product being sold for your own rendering purposes.

ProductDataObject String True

These fields can be used to view the fields of the product that this price will belong to. String representing the object’s type. Objects of the same type share the same value.

ProductDataCreated Datetime True

These fields can be used to view the fields of the product that this price will belong to. String representing the object’s type. Time at which the object was created.

ProductDataImages String True

These fields can be used to view the fields of the product that this price will belong to. A list of up to 8 URLs of images for this product, meant to be displayable to the customer.

ProductDataLivemode Boolean True

These fields can be used to view the fields of the product that this price will belong to. Has the value true if the object exists in live mode or the value false if the object exists in test mode.

ProductDataMarketingFeatures String True

These fields can be used to view the fields of the product that this price will belong to. A list of up to 15 marketing features for this product. These are displayed in pricing tables.

ProductDataPackageDimensionsHeight Double True

These fields can be used to view the fields of the product that this price will belong to. Height, in inches.

ProductDataPackageDimensionsLength Double True

These fields can be used to view the fields of the product that this price will belong to. Length, in inches.

ProductDataPackageDimensionsWeight Double True

These fields can be used to view the fields of the product that this price will belong to. Weight, in inches.

ProductDataPackageDimensionsWidth Double True

These fields can be used to view the fields of the product that this price will belong to. Width, in inches.

ProductDataShippable Boolean True

These fields can be used to view the fields of the product that this price will belong to. Whether this product is shipped (i.e., physical goods).

ProductDataUpdated Datetime True

These fields can be used to view the fields of the product that this price will belong to. Time at which the object was last updated.

ProductDataUrl String True

These fields can be used to view the fields of the product that this price will belong to. A URL of a publicly-accessible webpage for this product.

Pseudo-Columns

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

Name Type Description
AccountId String

The Id of the connected account to get prices for.

TransferLookupKey Boolean

If set to true, will atomically remove the lookup key from the existing price, and assign it to this price.

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