JDBC Driver for Stripe

Build 22.0.8462

ShippingRates

Query the available Shipping rates in Stripe.

Table Specific Information

Select

The driver will use 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 driver.

  • Id supports the following operator: =.
  • Active supports the following operator: =.
  • Created supports the following operator: =.
  • AccountId supports the following operator: =.

SELECT * FROM ShippingRates WHERE Id = 'shr_1MHKKGSC4snQ4WkONC7OYQuS'
SELECT * FROM ShippingRates WHERE Id = 'shr_1MHKKGSC4snQ4WkONC7OYQuS' AND AccountId = 'acct_1MGcyqSC4snQ4WkO'

Columns

Name Type References Description
Id [KEY] String The Id of the Shipping Rates.
Active Boolean Whether the shipping rate can be used for new purchases. Its default value is true.
Created Timestamp Time at which the object was created. Measured in seconds since the Unix epoch.
DeliveryEstimate String The estimated range for how long shipping will take, meant to be displayable to the customer.
DisplayName String The name of the shipping rate, meant to be displayable to the customer.
FixedAmountAmount Integer A non-negative integer in cents representing how much to charge.
FixedAmountCurrency String Three-letter ISO currency code, in lowercase. Must be a supported currency.
Livemode Boolean Has the value true if the object exists in live mode or the value false if the object exists in test mode.
Object String The Object type.
TaxBehavior String Whether the rate is considered inclusive of taxes or exclusive of taxes.
TaxCode String Tax code Id.
Type String The type of calculation to use on the shipping rate.

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
AccountId String The Id of the connected account.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462