ApplicationFees
Returns the application fees that Connect platforms collect from connected accounts, including the fee amount, currency, and associated charge.
View-Specific Information
SELECT
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.
| 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'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier for the application fee. | |
| Amount | Integer | The fee amount, in cents. | |
| AmountRefunded | Integer | The amount refunded, in cents. This can be less than the amount 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 of this fee on your account balance. | |
| Charge | String |
Charges.Id | The Id of the charge that the application fee was taken from. |
| Currency | String | The three-letter ISO currency code, in lowercase. Must be a supported currency. | |
| Created | Datetime | The time at which the fee was created, measured in seconds since the Unix epoch. | |
| Livemode | Boolean | Indicates whether the object exists in live mode. Returns false if the object exists 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. Returns false if the fee is only partially refunded. | |
| Refunds | String | A list of refunds that have been applied to the fee. | |
| SettlementType | String | DEPRECATED. The settlement type classification for this application fee. | |
| FeeSourceType | String | The type of the source of this fee. | |
| AccountId | String |
Accounts.Id | The Id of the connected account for which to retrieve application fees. |