Returns a list of items in a specified inbound shipment.

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.

• MarketplaceId supports the '=' comparison.
• ShipmentId supports the '=' comparison.
• LastUpdatedDate supports the '=', '<', '>', '<=', '>=' comparisons.

For example, the following query is processed server side:

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.