InboundShipmentItems
Returns a list of items in a specified inbound shipment.
Select
The cmdlet 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 cmdlet.
- MarketplaceId supports the '=' comparison.
- ShipmentId supports the '=' comparison.
- LastUpdatedDate supports the '=', '<', '>', '<=', '>=' comparisons.
SELECT * FROM InboundShipmentItems WHERE MarketplaceId = 'ATVPDKIKX0DER'
SELECT * FROM InboundShipmentItems WHERE ShipmentId = 'FBA8J3K9LZPX'
SELECT * FROM InboundShipmentItems WHERE LastUpdatedDate > '2020-01-01'
Columns
Name | Type | References | Description |
ShipmentId [KEY] | String | The ID of the shipment. | |
SellerSKU [KEY] | String | The Seller SKU of the item. | |
QuantityShipped | Int | The item quantity that you are shipping. | |
QuantityInCase | Int | The item quantity in each case, for case-packed items. | |
QuantityReceived | Int | The item quantity that has been received at an Amazon fulfillment center. | |
FulfillmentNetworkSKU | String | Amazon's fulfillment network SKU of the item. | |
PrepDetailsList | String | A JSON aggregate of preparation instructions and who is responsible for that preparation. | |
MarketplaceId | String | Marketplace identifier for the report. | |
ReleaseDate | Date | The date that a pre-order item will be available for sale. |
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. |