ShippingRates
Query the available Shipping rates in Stripe.
Table Specific Information
Select
The adapter 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 adapter.
- 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. |