Endpoint

Get Inventory Levels

Name

get_inventory_levels

Gets inventory level for a specific location and inventory item. [API reference]

Parameter	Label	Required	Description
inventory_item_ids	inventory_item_ids	NO	Inventory Item Id(s) - Comma separated
location_ids	location_ids	NO	Location Id(s) - Comma separated
updated_at_min	Updated at or after	NO	Show inventory levels updated at or after date (format: 2019-03-19T01:21:44-04:00).
limit	Page Size	NO	The maximum number of records to show.

Label	Data Type (SSIS)	Data Type (SQL)	Raw
InventoryItemId	`DT_I8`	`bigint`	`False`
LocationId	`DT_I8`	`bigint`	`False`
UpdatedAt	`DT_DBTIMESTAMP`	`datetime`	`False`
Available	`DT_I4`	`int`	`False`

If the column you are looking for is missing, consider customizing Shopify Connector.

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Use Shopify Connector in API Source component to read data or in API Destination component to read/write data:

This Endpoint belongs to InventoryLevels table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Shopify

InventoryLevels

Select

Use these SQL queries in your ODBC application data source:

SELECT * FROM get_inventory_levels

get_inventory_levels endpoint belongs to InventoryLevels table(s), and can therefore be used via those table(s).

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_inventory_levels';

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];

get_inventory_levels endpoint belongs to InventoryLevels table(s), and can therefore be used via those table(s).