Returns a list of inventory items.

Table-Specific Information

Select

The provider uses the Shopify API to process WHERE clause conditions built with the following column and operators. The provider processes other filters client-side within the provider.

• Id supports the '=, IN' comparison operators.

For example, the following query is processed server-side:

  SELECT * FROM InventoryShipments WHERE Id = 'Val1'

Insert

The following columns can be used to create a new record:

DateCreated, TrackingArrivesAt, TrackingCompany, TrackingNumber, TrackingURL

The following pseudo-columns can be used to create a new record:

MovementId, LineItems (references InventoryShipmentLineItems)

InventoryShipmentLineItems Temporary Table Columns

Column Name	Type	Description
Id	String	The ID of the inventory item.
Quantity	Int	The quantity for the inventory item.

Update

The following columns can be updated:

TrackingArrivesAt, TrackingCompany, TrackingNumber, TrackingURL

The following pseudo-columns can be used to update a record:

MovementId, LineItems (references InventoryShipmentLineItems)

InventoryShipmentLineItems Temporary Table Columns

Column Name	Type	Description
Id	String	The ID of the inventory item.
Quantity	Int	The quantity for the inventory item.

Delete

You can delete entries by specifying the following column:

Id

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The ID of the inventory shipment.
Name	String	True		The name of the inventory shipment.
Status	String	True		The current status of the shipment.
LineItemTotalQuantity	Int	True		The total quantity of all items in the shipment.
TotalAcceptedQuantity	Int	True		The total quantity of items accepted across all line items in this shipment.
TotalReceivedQuantity	Int	True		The total quantity of items received (both accepted and rejected) across all line items in this shipment.
TotalRejectedQuantity	Int	True		The total quantity of items rejected across all line items in this shipment.
DateCreated	Datetime	True		The date the shipment was created in UTC.
DateReceived	Datetime	True		The date the shipment was initially received in UTC.
DateShipped	Datetime	True		The date the shipment was shipped in UTC.
TrackingArrivesAt	Datetime	False		The estimated date and time that the shipment will arrive.
TrackingCompany	String	False		The name of the shipping carrier company.
TrackingNumber	String	False		The tracking number used by the carrier to identify the shipment.
TrackingURL	String	False		The URL to track the shipment.

Pseudo-Columns

Pseudo-columns are fields that can only be used in the types of statements under which they are explicitly listed. They are not standard columns but instead provide additional functionality for specific operations.

Name	Type	Description
MovementId	String	The ID of the inventory movement (transfer or purchase order) this shipment belongs to.
LineItems	String	The list of line items for the inventory shipment.