Create and query the available refunds 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, Charge, Created 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 Refund by specifying its Id:
SELECT * FROM Refunds WHERE Id='re_19keFRGOsuAdslZgO7zSbS2j'
-Refunds for the charge specified by Charge Id:
SELECT * FROM Refunds WHERE Charge='MyChargeId'
To insert a refund, provide a Charge Id.
INSERT INTO Refunds (Charge, Amount, Reason) VALUES ('ch_fj57lKDg460322552g', 40,'duplicate')
Update is not supported.
Delete is not supported.
The Id of the refund.
The Id of the charge that was refunded.
The Amount, in cents.
The status of the refund.
The balance transaction that describes the impact on your account balance.
The refund datetime.
Three-letter ISO code representing the currency.
The reason for the refund.
This is the transaction number that appears on email receipts sent for this refund.
The refund 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 refunds for.