InboundShipments
Returns a list of inbound shipments based on criteria that you specify.
Select
The connector will use the Amazon Marketplace 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.
- ShipmentId supports the '=' and 'IN' comparisons.
- ShipmentStatus supports the '='and 'IN' comparisons.
- MarketplaceId supports the '=' comparison.
- LastUpdatedDate supports the '=', '<', '>', '<=', '>=' comparisons.
SELECT * FROM InboundShipments WHERE ShipmentStatus = 'Working'
SELECT * FROM InboundShipments WHERE ShipmentStatus IN ('Working', 'SHIPPED', 'IN_TRANSIT')
SELECT * FROM InboundShipments WHERE ShipmentId = '503-9993250-1405404'
SELECT * FROM InboundShipments WHERE MarketplaceId = 'ATVPDKIKX0DER'
SELECT * FROM InboundShipments WHERE LastUpdatedDate >= '2016-12-12'
Columns
| Name | Type | ReadOnly | References | Description |
| ShipmentId [KEY] | String | False |
The ID of the shipment. | |
| ShipmentStatus | String | False |
The status of your inbound shipment. | |
| ShipmentName | String | False |
The unique name of the inbound shipment. | |
| ShipFromPostalCode | String | False |
The PostalCode of the return address. | |
| ShipFromName | String | False |
The Name of the return address. | |
| ShipFromCountryCode | String | False |
The CountryCode of the return address. | |
| ShipFromDistrictOrCounty | String | False |
The district or county of the return address. | |
| ShipFromStateOrProvinceCode | String | False |
The State Or Province Code of the return address. | |
| ShipFromAddressLine1 | String | False |
The street address information of the return address. | |
| ShipFromAddressLine2 | String | False |
Additional street address information of the return address. | |
| ShipFromCity | String | False |
The City of the return address. | |
| LabelPrepType | String | False |
The type of label preparation. | |
| AreCasesRequired | Boolean | False |
Boolean that indicates whether or not an inbound shipment contains case-packed boxes. | |
| DestinationFulfillmentCenterId | String | False |
The Amazon fulfillment center identifier created by Amazon. | |
| ConfirmedNeedByDate | Date | False |
Date that the shipment must arrive at an Amazon fulfillment center for pre-ordered items. | |
| MarketplaceId | String | False |
Marketplace identifier for the report. | |
| BoxContentsSource | String | False |
Where the seller provided box contents information for a shipment. | |
| EstimatedBoxContentsFeeTotalUnits | Int | False |
The number of units to ship for an estimate of the manual processing fee charged by Amazon for boxes without box content information. | |
| EstimatedBoxContentsFeePerUnitCurrencyCode | String | False |
The currency code for an estimate of the manual processing fee charged by Amazon for boxes without box content information. | |
| EstimatedBoxContentsFeePerUnitValue | Decimal | False |
The manual processing fee per unit for an estimate of the manual processing fee charged by Amazon for boxes without box content information. | |
| EstimatedBoxContentsTotalFeeCurrencyCode | String | False |
The Total fee currency code for an estimate of the manual processing fee charged by Amazon for boxes without box content information. | |
| EstimatedBoxContentsTotalFeeValue | Decimal | False |
The Total fee value for an estimate of the manual processing fee charged by Amazon for boxes without box content information. |
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 |
| LastUpdatedDate | Datetime |
A date used for selecting inbound shipments that were last updated before/after a specified time. |
| InboundShipmentItemList | String |
A list of inbound shipment item information. |