Windsor brings all your Plaid data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Plaid Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| balance__account_id | TEXT | balance.account_id | balance.account_id | balance |
| balance__available | NUMERIC | balance.available | balance.available | balance |
| balance__current | NUMERIC | balance.current | balance.current | balance |
| balance__iso_currency_code | TEXT | balance.iso_currency_code | balance.iso_currency_code | balance |
| balance__limit | NUMERIC | balance.limit | balance.limit | balance |
| balance__unofficial_currency_code | TEXT | balance.unofficial_currency_code | balance.unofficial_currency_code | balance |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| transaction__account_id | TEXT | transaction.account_id | transaction.account_id | transaction |
| transaction__account_owner | TEXT | transaction.account_owner | transaction.account_owner | transaction |
| transaction__amount | NUMERIC | transaction.amount | transaction.amount | transaction |
| transaction__authorized_date | TEXT | transaction.authorized_date | transaction.authorized_date | transaction |
| transaction__authorized_datetime | TEXT | transaction.authorized_datetime | transaction.authorized_datetime | transaction |
| transaction__category | OBJECT | transaction.category | transaction.category | transaction |
| transaction__category_id | TEXT | transaction.category_id | transaction.category_id | transaction |
| transaction__check_number | TEXT | transaction.check_number | transaction.check_number | transaction |
| transaction__date | TEXT | transaction.date | transaction.date | transaction |
| transaction__datetime | TEXT | transaction.datetime | transaction.datetime | transaction |
| transaction__iso_currency_code | TEXT | transaction.iso_currency_code | transaction.iso_currency_code | transaction |
| transaction__location | OBJECT | transaction.location | transaction.location | transaction |
| transaction__merchant_name | TEXT | transaction.merchant_name | transaction.merchant_name | transaction |
| transaction__name | TEXT | transaction.name | transaction.name | transaction |
| transaction__payment_channel | TEXT | transaction.payment_channel | transaction.payment_channel | transaction |
| transaction__payment_meta | OBJECT | transaction.payment_meta | transaction.payment_meta | transaction |
| transaction__pending | BOOLEAN | transaction.pending | transaction.pending | transaction |
| transaction__pending_transaction_id | TEXT | transaction.pending_transaction_id | transaction.pending_transaction_id | transaction |
| transaction__personal_finance_category | TEXT | transaction.personal_finance_category | transaction.personal_finance_category | transaction |
| transaction__transaction_code | TEXT | transaction.transaction_code | transaction.transaction_code | transaction |
| transaction__transaction_id | TEXT | transaction.transaction_id | transaction.transaction_id | transaction |
| transaction__transaction_type | TEXT | transaction.transaction_type | transaction.transaction_type | transaction |
| transaction__unofficial_currency_code | TEXT | transaction.unofficial_currency_code | transaction.unofficial_currency_code | transaction |