OrderCustomsItems
Customs Items of the Orders.
Select
The connector will use the ShipStation API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
- OrderId supports the following operator: =.
Note: OrderId is required in order to query OrderCustomsItems. For example, the following query is processed server side:
SELECT * FROM OrderCustomsItems WHERE OrderId = 2810333
Columns
Name | Type | References | Description |
CustomsItemId [KEY] | Long | Id of the customs Item. | |
CountryOfOrigin | String | Origin country of the customs Item. | |
Description | String | Description of the customs Item. | |
HarmonizedTariffCode | String | Harmonized tariff code of the customers Item. | |
Quantity | Integer | Quantity of the customs Item. | |
Value | Double | Value of the customs Item. | |
OrderId [KEY] | Long | Id of the Order. |