ApplicationFeeRefunds
Returns a list of application fees youve previously collected.
Table Specific Information
Select
Server-Side Query Support
The connector uses 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.
- ApplicationFeeId support the following operator: =.
- Id support the following operator: =.
The provider supports the use of all columns as criteria in the WHERE clause of SELECT statements, as long as SupportEnhancedSQL is set to True. If SupportEnhancedSQL property is set to False, you still can retrieve:
To query the ApplicationFees we can try the below queries.
SELECT * from ApplicationFeeRefunds
SELECT * from ApplicationFeeRefunds where applicationfeeid = 'fee_1ACvR6I2xUg5aQMAnqlDqwJY'
SELECT * from ApplicationFeeRefunds where id = 'fr_A2ZYOWsSreeFvP'
Columns
Name | Type | References | Description |
Id [KEY] | String | The id of files. | |
ApplicationFeeId [KEY] | String | The Id of the application fee. | |
Amount | Integer | Amount, in cents. | |
BalanceTransaction | String | Balance transaction that describes the impact on your account balance. | |
Currency | String | Three-letter ISO currency code, in lowercase. Must be a supported currency. | |
Created | Datetime | Time at which the object was created. Measured in seconds since the Unix epoch. | |
MetadataAggregate | String | The set of key/value pairs that you can attach to a an 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 files for. |