ApplicationFees
Returns a list of file links.
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.
- Id support the following operator: =.
- Charge 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 ApplicationFees
SELECT * from ApplicationFees where charge = 'py_1Ofr5O2cbZNns1OzqCZGhR9a'
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. |