Stripe Field Reference
Sample
https://connectors.windsor.ai/stripe?api_key=[your API key]&date_preset=last_7d&fields=date,transaction_id,amount,currency,fee,email&_renderer=csv
Fields
| ID | Type | Name | Description | Report |
|---|
| amount | NUMERIC | Amount | The transaction amount | transaction |
| balance__amount | NUMERIC | Balance amount | The balance amount currently on your Stripe account. | balance |
| balance__currency | TEXT | Balance currency | The balance three-letter ISO currency code, in lowercase. | balance |
| balance__source_types__bank_account | NUMERIC | Balance bank account amount | Breakdown of balance by bank account. | balance |
| balance__source_types__card | NUMERIC | Balance card amount | Breakdown of balance by card. | balance |
| balance__source_types__fpx | NUMERIC | Balance FPX amount | Breakdown of balance by FPX. | balance |
| currency | TEXT | Currency | The transaction three-letter ISO currency code, in lowercase. | transaction |
| customer_id | TEXT | Customers ID | The Stripe customer ID | transaction |
| date | DATE | Date | Date | |
| description | TEXT | Description | Transaction Description | transaction |
| email | TEXT | Email | The email address of the customer placing the order. | transaction |
| fee | NUMERIC | Transaction fee | The transaction fee | transaction |
| net | NUMERIC | Net Amount | Net amount of the transaction, in pence. | transaction |
| refund__amount | NUMERIC | Refund amount | The refund amount. | refund |
| refund__currency | TEXT | Refund currency | The refund three-letter ISO currency code, in lowercase. | refund |
| refund__description | TEXT | Refund description | The refund description. | refund |
| refund__id | TEXT | Refund ID | The refund id. | refund |
| refund__reason | TEXT | Refund reason | Reason for the refund. | refund |
| refund__status | TEXT | Refund status | Status of the refund. | refund |
| status | TEXT | Status | The transaction status | transaction |
| transaction__amount | NUMERIC | Transaction amount | The transaction amount | transaction |
| transaction__currency | TEXT | Transaction currency | The transaction three-letter ISO currency code, in lowercase. | transaction |
| transaction__description | TEXT | Transaction description | The transaction description | transaction |
| transaction__email | TEXT | Transaction email | The email address of the customer placing the order. | transaction |
| transaction__fee | NUMERIC | Transaction fee (same as fee) | The transaction fee | transaction |
| transaction__id | TEXT | Transaction ID (same as transactionid) | The transaction id | transaction |
| transaction__net | NUMERIC | Transaction net amount | Net amount of the transaction. | transaction |
| transaction__status | TEXT | Transaction status | The transaction status | transaction |
| transaction__type | TEXT | Transaction type | The transaction type | transaction |
| transactionid | TEXT | Transaction ID | The transaction id | transaction |
| type | TEXT | Type | Transaction Type | transaction |
| today | DATE | Today | Today's date | |