Endpoint

Insert Inventory Levels

Name

post_inventory_level

Description

No description available

Related Tables

InventoryLevels

Parameters

Parameter	Label	Required	Options	Description
There are no parameters

Output Columns

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.

Input Columns

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

Required columns that you need to supply are bolded.

Examples

SSIS

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

Insert into InventoryLevels table using API Destination

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

Shopify

InventoryLevels

Insert

SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Insert Inventory Levels

-- We are out of SQL query examples for this Endpoint, sorry!
-- But will try to get some very very soon!

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

SQL Server

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

Insert Inventory Levels

DECLARE @MyQuery NVARCHAR(MAX) = '-- We are out of SQL query examples for this Endpoint, sorry!
-- But will try to get some very very soon!';

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];

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