ApplicationFees
Returns a list of file links.
Table Specific Information
Select
Server-Side Query Support
The add-in 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 add-in.
- Id supports the following operator: =.
- Charge supports the following operator: =.
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 id of files. | |
| Amount | Integer | Amount, in cents. | |
| AmountRefunded | Integer | Amount in cents refunded (can be less than the amount attribute on the fee if a partial refund was issued). | |
| Application | String | ID of the Connect application that earned the fee. | |
| BalanceTransaction | String | Balance transaction that describes the impact on your account balance. | |
| Charge | String | ID of the charge that the application fee was taken from. | |
| 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. | |
| Livemode | Boolean | Has the value true if the object exists in live mode or the value false if the object exists in test mode. | |
| OriginatingTransaction | String | ID of the corresponding charge on the platform account, if this fee was the result of a charge using the destination parameter. | |
| Refunded | Boolean | Whether the fee has been fully refunded. If the fee is only partially refunded, this attribute will still be false. | |
| Refunds | String | A list of refunds that have been applied to the fee. | |
| AccountId | String | The Id of the connected account to get files for. |