SSIS Components for Stripe

Build 24.0.9062

Quotes

Creates, updates, and queries the quotes available.

Table Specific Information

Select

The 本製品 uses the Stripe API to filter the results by the following columns and operators:

  • Id supports the following operator: =.
  • CustomerId supports the following operator: =.
  • Status supports the following operator: =.
  • TestClock supports the following operator: =.

The rest of the filter is executed client-side within the 本製品.

You can select from the Quotes table with the following queries:

SELECT * FROM Quotes WHERE Id = '123124'
SELECT * FROM Quotes WHERE CustomerId = 'cus_NVasad'
SELECT * FROM Quotes WHERE Status = 'draft'
SELECT * FROM Quotes WHERE TestClock = 'clock_id'

Insert

To create a quote for the invoice:

INSERT INTO Quotes (AutomaticTaxEnabled, CollectionMethod, CustomerId, Description, InvoiceSettingsDaysUntilDue, Metadata, SubscriptionDataTrialPeriodDays) values ('false', 'send_invoice', 'cus_NBs3z63zmfCJy1', 'Thanks for using YMBusiness!!', 25, '{"name":"test name 2", "surname":"test surname", "age" : "23"}', 20)

INSERT INTO Quotes (DefaultTaxRates, FromQuote, Discounts, TransferData, LineItems) VALUES ('[\"txr_1OL7oy2eZvKYlo2CLylDtkiI\",\"txr_1OL7oo2eZvKYlo2CHliiOEZT\"]', '{\"quote\":\"qt_1N6vEL2eZvKYlo2CwySMFZbA\",\"is_revision\":\"true\"}', '{\"coupon\":\"test1\"}', '{\"destination\":\"acc_123566677\",\"amount\":\"440\",\"amount_percent\":\"23\"}', '[{\"price\":\"price_1OM02h2eZvKYlo2CiiTU7dCm\",\"quantity\":\"10\"}]')

Update

To modify a quote, specify the quote Id:

UPDATE Quotes SET InvoiceSettingsDaysUntilDue = 20 WHERE Id='123124'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

The Id of the quotes.

AmountSubtotal Integer True

The total before any discounts or taxes are applied.

AmountTotal Integer True

The total after discounts and taxes are applied.

Application String True

The Id of the Connect Application that created the quote.

ApplicationFeeAmount Integer False

The amount of the application fee.

ApplicationFeePercent Double False

A non-negative decimal between 0 and 100, with at most two decimal places.

AutomaticTaxEnabled Boolean False

Automatically calculates taxes.

AutomaticTaxStatus String True

The status of the most recent automated tax calculation for this quote.

CollectionMethod String False

The method to collect charge money, either charge_automatically or send_invoice.

ComputedRecurring String True

The definitive totals and line items the customer is charged on a recurring basis.

ComputedUpfrontAmountSubtotal Integer True

The total before any discounts or taxes are applied.

ComputedUpfrontAmountTotal Integer True

The total after discounts and taxes are applied.

ComputedUpfrontTotalDetailsAmountDiscount Integer True

The sum of all the discounts.

ComputedUpfrontTotalDetailsAmountShipping Integer True

The sum of all the shipping amounts.

ComputedUpfrontTotalDetailsAmountTax Integer True

The sum of all the tax amounts.

Created Datetime True

The time at which the object was created. Measured in seconds since the Unix epoch.

Currency String True

A three-letter ISO currency code, in lowercase.

CustomerId String False

The Id of the customer.

DefaultTaxRates String False

The tax rates applied to this quote.

Description String False

A description that is displayed on the quote PDF.

Discounts String False

The discounts applied to this quote.

ExpiresAt Datetime False

The date on which the quote is canceled if in open or draft status.

Footer String False

A footer that is displayed on the quote PDF.

FromQuote String False

Details of the quote that was cloned.

Header String False

A header that is displayed on the quote PDF.

InvoiceId String True

The Id of the invoice that was created from this quote.

InvoiceSettingsDaysUntilDue Integer False

The number of days within which a customer must pay invoices generated by this quote.

Livemode Boolean True

true if the object is in live mode andfalse if in test mode.

LineItems String False

The line items representing what is being sold. Each line item represents an item being sold.

Metadata String False

The set of key/value pairs that you can attach to a value list object.

Number String True

A unique number that identifies this particular quote.

OnBehalfOf String False

The account on behalf of which to charge.

Status String True

The status of the quote.

StatusTransitionsAcceptedAt Datetime True

The time that the quote was accepted.

StatusTransitionsCanceledAt Datetime True

The time that the quote was canceled.

StatusTransitionsFinalizedAt Datetime True

The time that the quote was finalized.

Subscription String True

The subscription that was created or updated from this quote.

SubscriptionDataDescription String False

The subscription's description, meant to be displayable to the customer.

SubscriptionDataEffectiveDate Datetime False

When creating a new subscription, the date of which the subscription schedule starts after the quote is accepted.

SubscriptionDataTrialPeriodDays Integer False

An integer representing the number of trial period days before the customer is charged for the first time.

SubscriptionSchedule String True

The subscription schedule that was created or updated from this quote.

TestClock String False

The Id of the test clock this quote belongs to.

TotalDetailsAmountDiscount Integer True

The sum of all the discounts.

TotalDetailsAmountShipping Integer True

The sum of all the shipping amounts.

TotalDetailsAmountTax Integer True

The sum of all the tax amounts.

TransferData String False

The account (if any) the payments are attributed to for tax reporting, and where funds from each payment are transferred to for each of the invoices.

AutomaticTaxLiabilityAccount String False

The connected account being referenced when type is account.

AutomaticTaxLiabilityType String False

Type of the account referenced.

InvoiceSettingsIssuerAccount String False

The connected account being referenced when type is account.

InvoiceSettingsIssuerType String False

Type of the account referenced.

使用できる値は次のとおりです。account, self

SubscriptionDataMetadata String False

Set of key-value pairs that will set metadata on the subscription or subscription schedule when the quote is accepted. If a recurring price is included in line_items, this field will be passed to the resulting subscription’s metadata field. If subscription_data.effective_date is used, this field will be passed to the resulting subscription schedule’s phases.metadata field. Unlike object-level metadata, this field is declarative. Updates will clear prior values.

Pseudo-Columns

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

Name Type Description
AccountId String

The Id of the connected account for which to get a quote.

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