EndPoint Get Inventory Items

Contents

1 Label
2 Description
3 Parameters
4 Output Columns
5 Input Columns

Name

get_inventory_items

Description

Gets a list of inventory items. Each Product Variant has Inventory Item Id .. Its one to one relationship with Product Variant and Inventory Item. Query get_product_variants to get InventoryItemId and use as Id in this endpoint. [API reference]

Parameters

Parameter	Label	Required	Options	Description
ids	Inventory Item Id(s) - Comma separated	YES		Restrict results to records specified by a comma-separated list of IDs. Max IDs per request controlled by BatchSize property (found in PaginationParams)
limit	Page Size	NO		The maximum number of records to show.

Output Columns

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

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
Id	`DT_I8`	`bigint`		False

Required columns that you need to supply are bolded.