ShippingRates
Returns the available shipping rates, including delivery estimates, fixed amounts, and tax behavior details.
Table-Specific Information
SELECT
The provider 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 provider.
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 unique identifier for 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 time at which the shipping rate was created, measured in seconds since the Unix epoch. | |
| DeliveryEstimateMaximumUnit | String | False |
The unit of time used for the maximum delivery estimate. | |
| DeliveryEstimateMaximumValue | Integer | False |
The maximum delivery estimate value, in the specified unit of time. Must be greater than 0. | |
| DeliveryEstimateMinimumUnit | String | False |
The unit of time used for the minimum delivery estimate. | |
| DeliveryEstimateMinimumValue | Integer | False |
The minimum delivery estimate value, in the specified unit of time. Must be greater than 0. | |
| DisplayName | String | False |
The name of the shipping rate, meant to be displayed to the customer. | |
| FixedAmountAmount | Integer | False |
A non-negative integer, in cents, representing how much to charge. | |
| FixedAmountCurrency | String | False |
The three-letter ISO currency code, in lowercase. Must be a supported currency. | |
| Livemode | Boolean | True |
Indicates whether the object exists in live mode. Has the value true if the object exists in live mode, or the value false if the object exists in test mode. | |
| MetadataAggregate | String | False |
The set of key-value pairs that you can attach to the shipping rate. | |
| Object | String | True |
The string representing the object's type. Objects of the same type share the same value. | |
| TaxBehavior | String | False |
Indicates whether the rate is considered inclusive or exclusive of taxes. | |
| TaxCode | String | False |
The Id of the tax code applied to the shipping rate. | |
| 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. |