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 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.