JDBC Driver for Shopify

Build 23.0.8839

Payouts

Retrieves a list of all payouts ordered by payout date, with the most recent being first.

Table-Specific Information

Select

The 本製品 uses the Shopify API to process search criteria that refer to the Id, Status and Date columns. The supported SQL operator is '=' for Id, Status and Date columns. The 本製品 processes other filters client-side within the 本製品.

For example, the following queries are processed server-side:

SELECT * FROM Payouts WHERE Id = '123'

SELECT * FROM Payouts WHERE Status = 'pending'

SELECT * FROM Payouts WHERE Date = '2018-10-30'

Columns

Name Type References Description
Id [KEY] Long The unique identifier of the payout.
Status String The transfer status of the payout.
Currency String The ISO 4217 currency code of the payout.
Amount Decimal The total amount of the payout, in a decimal formatted string.
Date Datetime The date the payout was issued.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839