Create, update, and query the available transfers in Stripe.
Table Specific Information
Server-Side Query Support
The connector will use the Stripe API to filter the results by the following columns and operators while the rest of the filter is executed client side within the connector.
- Id, Destination support the following operators:=.
The provider supports all columns to be used as criteria in the Where clause of Select statement, as long as SupportEnhancedSQL is set to True. If SupportEnhancedSQL property is set to False, you still can retreive:
-a Transfer by specifying its Id:
SELECT * FROM Transfers WHERE Id='tr_12345678'
-Transfers created after a specific date (Created may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range):
SELECT * FROM Transfers WHERE Created>'12/2/2015'
Currency, Amount, and Destination are required to insert into this table. The Destination is the Id of a connected Stripe account:
INSERT INTO Transfers (Amount, Currency, Destination) VALUES (1000, 'USD', 'acct_19abC2DFGl5DVRzj' )
To update a transfer set a description and specify an Id in the WHERE clause:
UPDATE Transfers SET Description='New desc' WHERE Id='tr_123456788' )
Delete is not supported.
The Id of the transfer.
Amount (in cents) to be transferred to your bank account.
Amount in cents reversed (can be less than the amount attribute on the transfer if a partial reversal was issued).
The application fee.
Balance transaction that describes the impact of this transfer on your account balance.
Time that this record of the transfer was first created.
Date the transfer is scheduled to arrive in the bank. This doesn't factor in delays like weekends or bank holidays.
Internal-only description of the transfer.
The Id of the bank account, card, or Stripe account the transfer was sent to.
If the destination is a Stripe account, this will be the Id of the payment that the destination account received for the transfer.
Error code explaining reason for transfer failure if available.
Message to user further explaining reason for transfer failure if available.
Whether or not the transfer has been fully reversed. If the transfer is only partially reversed, this attribute will still be false.
The Id of the charge (or other transaction) that was used to fund the transfer. If null, the transfer was funded from the available balance.
The source balance this transfer came from.
Extra information about a transfer to be displayed on the user's bank statement.
Current status of the transfer.
The type of the transfer.Can be card, bank_account, or stripe_account.
The transfer metadata object.
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
The Id of the connected account to get transfers for.