Reference

Table OrderItems

Description

No description available

Supported Operations

Below section contains supported CRUD operations. Each operation is executed by some EndPoint behind the scene.
Method Supported Reference EndPoint
SELECT get_order_items
INSERT
UPDATE
UPSERT
DELETE
LOOKUP get_order_items

Examples

SSIS

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

Read from OrderItems table using API Source

API Source - Shopify
Read and write Shopify data effortlessly. Integrate, manage, and automate customers, orders, products, and inventory — almost no coding required.
Shopify
OrderItems
Optional Parameters
Order Id(s) - Comma separated
SSIS API Source - Read from table or endpoint

Read/write to OrderItems table using API Destination

API Destination - Shopify
Read and write Shopify data effortlessly. Integrate, manage, and automate customers, orders, products, and inventory — almost no coding required.
Shopify
OrderItems
Select
Optional Parameters
Order Id(s) - Comma separated
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Read order line items

<p>Gets line items for all orders from the <code>OrderItems</code> table.</p> 

SELECT * FROM OrderItems

Read order line items by order ID

<p>Gets line items for a specific order. Supply the <code>OrderId</code> in the <code>WHERE</code> clause.</p> 

SELECT * FROM OrderItems Where OrderId=1111111111111

Read order line items by multiple order IDs

<p>Gets line items for multiple orders by supplying a comma-separated list of order IDs in the <code>ids</code> parameter within the <code>WITH</code> clause.</p> 

SELECT * FROM OrderItems WITH(ids='1111111111111,2222222222222,3333333333333')

SQL Server

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

Read order line items

<p>Gets line items for all orders from the <code>OrderItems</code> table.</p> 

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

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];

Read order line items by order ID

<p>Gets line items for a specific order. Supply the <code>OrderId</code> in the <code>WHERE</code> clause.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM OrderItems Where OrderId=1111111111111';

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];

Read order line items by multiple order IDs

<p>Gets line items for multiple orders by supplying a comma-separated list of order IDs in the <code>ids</code> parameter within the <code>WITH</code> clause.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM OrderItems WITH(ids=''1111111111111,2222222222222,3333333333333'')';

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];