SSIS Components for Stripe

Build 24.0.9062

ApplicationFees

Returns a list of file links.

Table Specific Information

Select

Server-Side Query Support

The 本製品 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 本製品.

  • 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062