Returns a list of items in a specified inbound shipment.

Select

The 本製品 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 本製品.

• 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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
LastUpdatedDate	Datetime		A date used for selecting inbound shipments that were last updated before/after a specified time.