Endpoint

Get Inventory Item

Name

get_inventory_item

Gets a specific inventory item. [API reference]

Parameter	Label	Required	Options	Description
location_ids	Inventory Item Id(s) - Comma separated	NO		Restrict results to records specified by a comma-separated list of IDs. Max IDs per request controlled by BatchSize property (found in PaginationParams)

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_I8`	`bigint`		`False`
Sku	`DT_WSTR`	`nvarchar(255)`	255	`False`
Cost	`DT_WSTR`	`nvarchar(255)`	255	`False`
Tracked	`DT_BOOL`	`bit`		`False`
RequiresShipping	`DT_BOOL`	`bit`		`False`
CountryCodeOfOrigin	`DT_WSTR`	`nvarchar(50)`	50	`False`
ProvinceCodeOfOrigin	`DT_WSTR`	`nvarchar(50)`	50	`False`
CountryHarmonizedSystemCodes	`DT_WSTR`	`nvarchar(4000)`	4000	`True`
HarmonizedSystemCode	`DT_I8`	`bigint`		`False`
CreatedAt	`DT_DBTIMESTAMP`	`datetime`		`False`
UpdatedAt	`DT_DBTIMESTAMP`	`datetime`		`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:

Shopify

Get Inventory Item

Shopify

Get Inventory Item

Use these SQL queries in your ODBC application data source:

SELECT * FROM get_inventory_item

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

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

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];