Payouts
Retrieves a list of all payouts ordered by payout date, with the most recent being first.
Table-Specific Information
Select
The driver 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 driver processes other filters client-side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
For example, the following queries are processed server side:
SELECT * FROM Payouts
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. |