Payouts
Retrieves a list of all payouts ordered by payout date, with the most recent being first.
Table-Specific Information
Select
The adapter 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 adapter processes other filters client-side within the adapter.
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. |