Transactions
Returns a list of Issuing Transaction objects. The objects are sorted in descending order by creation date, with the most recently created object appearing first.
View-Specific Information
SELECT
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.
| Column | Supported Operators |
| Id | = |
| Card | = |
| Cardholder | = |
| Type | = |
| Created | =, >, >=, <, <= |
You can select from Transactions with the following queries:
SELECT * FROM Transactions WHERE Id = 'ipi_1ODMLL2eZvKYlo2CoarGZSSp'
SELECT * FROM Transactions WHERE Card = 'card_1GhPzLJXTn'
SELECT * FROM Transactions WHERE Cardholder = 'cardholder_12345'
SELECT * FROM Transactions WHERE Type = 'purchase'
SELECT * FROM Transactions WHERE Created >= '2024-01-01'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Unique identifier for the object. | |
| Amount | Integer | The transaction amount, which is reflected in your balance. | |
| AmountDetailsAtmFee | Integer | The fee charged by the ATM for the cash withdrawal. | |
| AmountDetailsCashbackAmount | Integer | The amount of cash requested by the cardholder. | |
| Authorization | String | The Authorization object that led to this transaction. | |
| BalanceTransaction | String | The balance transaction that describes the impact on your account balance. | |
| Card | String | The card used to make this transaction. | |
| Cardholder | String | The cardholder to whom this transaction belongs. | |
| Currency | String | The three-letter ISO currency code, in lowercase. Must be a supported currency. | |
| MetadataAggregate | String | The set of key-value pairs that you can attach to an object. | |
| Type | String | The nature of the transaction. | |
| Created | Datetime | The date and time at which the object was created, measured in seconds since the Unix epoch. | |
| Dispute | String | If you have disputed the transaction, the Id of the dispute. | |
| Livemode | Boolean | Indicates whether the object exists in live mode. The value is true in live mode and false in test mode. | |
| MerchantAmount | Integer | The amount that the merchant receives, denominated in merchant_currency and in the smallest currency unit. | |
| MerchantCurrency | String | The currency with which the merchant is taking payment. | |
| MerchantDataCategory | String | A categorization of the seller's type of business. | |
| MerchantDataCategoryCode | String | The merchant category code for the seller's business. | |
| MerchantDataCity | String | The city where the seller is located. | |
| MerchantDataCountry | String | The country where the seller is located. | |
| MerchantDataName | String | The name of the seller. | |
| MerchantDataNetworkId | String | The identifier assigned to the seller by the card network. | |
| MerchantDataPostalCode | String | The postal code where the seller is located. | |
| MerchantDataState | String | The state where the seller is located. | |
| MerchantDataTerminalId | String | An Id assigned by the seller to the location of the sale. | |
| MerchantDataURL | String | The URL provided by the merchant on a 3DS request. | |
| NetworkDataAuthorizationCode | String | A code created by Stripe which is shared with the merchant to validate the authorization. | |
| NetworkDataProcessingDate | String | The date the transaction was processed by the card network. | |
| NetworkDataTransactionId | String | Unique identifier for the authorization assigned by the card network used to match subsequent messages, disputes, and transactions. | |
| PurchaseDetailsFlight | String | Information about the flight that was purchased with this transaction. | |
| PurchaseDetailsFuel | String | Information about fuel that was purchased with this transaction. | |
| PurchaseDetailsLodging | String | Information about lodging that was purchased with this transaction. | |
| PurchaseDetailsReceipt | String | The line items in the purchase. | |
| PurchaseDetailsReference | String | A merchant-specific order number. | |
| Token | String | The token object used for this transaction. | |
| Wallet | String | The digital wallet used for this transaction. | |
| MerchantDataTaxId | String | The tax Id of the seller. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| AccountId | String | The Id of the connected account to get transactions for. |