Reference

Table Payouts


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_payouts
INSERT
UPDATE
UPSERT
DELETE
LOOKUP

Examples

SSIS

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

Read from Payouts table using API Source

API Source - Shopify
Shopify Connector can be used to integrate Shopify REST API in your App / BI Tools. You can read/write data about Customers, Orders, OrderItems, Products and more.
Shopify
Payouts
Optional Parameters
Date (format: yyyy-MM-ddd)
Date maximum (format: yyyy-MM-ddd)
Date minimum(format: yyyy-MM-ddd)
Payouts before this Id
Payouts after this Id
Status
ContineOn404Error True
SSIS API Source - Read from table or endpoint

Read/write to Payouts table using API Destination

API Destination - Shopify
Shopify Connector can be used to integrate Shopify REST API in your App / BI Tools. You can read/write data about Customers, Orders, OrderItems, Products and more.
Shopify
Payouts
Select
Optional Parameters
Date (format: yyyy-MM-ddd)
Date maximum (format: yyyy-MM-ddd)
Date minimum(format: yyyy-MM-ddd)
Payouts before this Id
Payouts after this Id
Status
ContineOn404Error True
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get Payouts

SELECT * FROM Payouts

SQL Server

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

Get Payouts

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

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];