ShippingRates

Returns the available Shipping rates in Stripe.

Table-Specific Information

SELECT

The connector uses the Stripe API to filter the results by the following columns and operators:


Column	Supported Operators
Id	=
Active	=
Created	=,>,>=,<,<=
AccountId	=
FixedAmountCurrency	=

The rest of the filter is executed client-side within the connector.

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

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

INSERT

DisplayName and Type are required to create a shipping rate:

INSERT INTO ShippingRates (DisplayName, Type, MetadataAggregate, FixedAmountAmount, FixedAmountCurrency) VALUES ('asdsswd', 'fixed_amount', '[{\"nsame\":\"asdsa\"}]', 230, 'usd')

UPDATE

To update a shipping rate, specify the Id:

UPDATE ShippingRates SET Active = true WHERE Id = 'shr_1OQ9ScCZ8rn6qR6h3H86TWDn'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The Id of the Shipping Rate.
Active	Boolean	False		Indicates whether the shipping rate can be used for new purchases. Its default value is true.
Created	Timestamp	True		The date and time at which the object was created, measured in seconds since the Unix epoch.
DeliveryEstimateMaximumUnit	String	False		A unit of time.
DeliveryEstimateMaximumValue	Integer	False		Must be greater than 0.
DeliveryEstimateMinimumUnit	String	False		A unit of time.
DeliveryEstimateMinimumValue	Integer	False		Must be greater than 0.
DisplayName	String	False		The name of the shipping rate, meant to be displayable to the customer.
FixedAmountAmount	Integer	False		A non-negative integer in cents representing how much to charge.
FixedAmountCurrency	String	False		Three-letter ISO currency code, in lowercase. Must be a supported currency.
Livemode	Boolean	True		Indicates whether the object exists in live mode. The value is true in live mode and false in test mode.
MetadataAggregate	String	False		Set of key-value pairs.
Object	String	True		The Object type.
TaxBehavior	String	False		Indicates whether the rate is considered inclusive of taxes or exclusive of taxes.
TaxCode	String	False		The tax code Id.
Type	String	False		The type of calculation to use on the shipping rate.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.


Name	Type	Description
AccountId	String	The Id of the connected account.