ShippingRates
Query the available Shipping rates in Stripe.
Table Specific Information
Select
The 本製品 uses the Stripe API to filter the results by the following columns and operators:
- Id supports the following operator: =.
- Active supports the following operator: =.
- Created supports the following operator: =,>,>=,<,<=.
- AccountId supports the following operator: =.
- FixedAmountCurrency supports the following operator: =.
The rest of the filter is executed client-side within the 本製品.
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 ShippingRate:
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 Rates. | |
Active | Boolean | False |
Whether the shipping rate can be used for new purchases. Its default value is true. | |
Created | Timestamp | True |
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 |
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 |
Set of key-value pairs | |
Object | String | True |
The Object type. | |
TaxBehavior | String | False |
Whether the rate is considered inclusive of taxes or exclusive of taxes. | |
TaxCode | String | False |
Tax code Id. | |
Type | String | False |
The type of calculation to use on the shipping rate. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
AccountId | String |
The Id of the connected account. |