Customs Items of the Orders.

Select

The driver 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 driver.

• 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

You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

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.