Tableau Connector for Stripe

Build 21.0.7930

Refunds

Create and query the available refunds in Stripe.

Table Specific Information

Select

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'

Insert

To insert a refund, provide a Charge Id.

INSERT INTO Refunds  (Charge, Amount, Reason) VALUES ('ch_fj57lKDg460322552g', 40,'duplicate')

Update

Update is not supported.

Delete

Delete is not supported.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

The Id of the refund.

Charge String False

The Id of the charge that was refunded.

Amount Integer False

The Amount, in cents.

Status String True

The status of the refund.

BalanceTransaction String False

The balance transaction that describes the impact on your account balance.

Created Datetime True

The refund datetime.

Currency String False

Three-letter ISO code representing the currency.

Reason String False

The reason for the refund.

ReceiptNumber String False

This is the transaction number that appears on email receipts sent for this refund.

MetadataAggregate String False

The refund metadata object.

Pseudo-Columns

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.

Name Type Description
AccountId String

The Id of the connected account to get refunds for.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930