ApplicationFees
Returns a list of application fees.
View-Specific Information
SELECT
The driver 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 driver.
| Column | Supported Operators |
| Id | = |
| Charge | = |
| Created | =, >, >=, <, <= |
You can select from ApplicationFees with the following queries:
SELECT * FROM ApplicationFees WHERE charge = 'py_1Ofr5O2cbZNns1OzqCZGhR9a'
SELECT * FROM ApplicationFees WHERE Created > '2024-01-01'
SELECT * FROM ApplicationFees WHERE Refunded = true
SELECT * FROM ApplicationFees WHERE Currency = 'usd'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier for the application fee. | |
| Amount | Integer | The amount, in cents. | |
| AmountRefunded | Integer | The amount, in cents, refunded. This can be less than the amount attribute on the fee if a partial refund was issued. | |
| Application | String | The Id of the Connect application that earned the fee. | |
| BalanceTransaction | String | The balance transaction that describes the impact on your account balance. | |
| Charge | String | The Id of the charge that the application fee was taken from. | |
| Currency | String | The three-letter ISO currency code, in lowercase. It must be a supported currency. | |
| Created | Datetime | The date and time at which the object was created, measured in seconds since the Unix epoch. | |
| Livemode | Boolean | Indicates whether the object exists in live mode. The value is true in live mode and false in test mode. | |
| OriginatingTransaction | String | The Id of the corresponding charge on the platform account, if this fee was the result of a charge using the destination parameter. | |
| Refunded | Boolean | Indicates whether the fee has been fully refunded. If the fee is only partially refunded, this attribute is still false. | |
| Refunds | String | A list of refunds that have been applied to the fee. | |
| AccountId | String | The Id of the connected account to get application fees for. |