Plaid Connector Reference

The Plaid connector exposes 34 fields (4 metrics, 30 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Plaid Fields

Plaid balance fields

The balance report of the Plaid connector includes 6 fields.

ID	Type	Name	Description
balance__account_id	TEXT	balance.account_id	balance.account_id
balance__available	NUMERIC	balance.available	balance.available
balance__current	NUMERIC	balance.current	balance.current
balance__iso_currency_code	TEXT	balance.iso_currency_code	balance.iso_currency_code
balance__limit	NUMERIC	balance.limit	balance.limit
balance__unofficial_currency_code	TEXT	balance.unofficial_currency_code	balance.unofficial_currency_code

Plaid transaction fields

The transaction report of the Plaid connector includes 23 fields.

ID	Type	Name	Description
transaction__account_id	TEXT	transaction.account_id	transaction.account_id
transaction__account_owner	TEXT	transaction.account_owner	transaction.account_owner
transaction__amount	NUMERIC	transaction.amount	transaction.amount
transaction__authorized_date	TEXT	transaction.authorized_date	transaction.authorized_date
transaction__authorized_datetime	TEXT	transaction.authorized_datetime	transaction.authorized_datetime
transaction__category	OBJECT	transaction.category	transaction.category
transaction__category_id	TEXT	transaction.category_id	transaction.category_id
transaction__check_number	TEXT	transaction.check_number	transaction.check_number
transaction__date	TEXT	transaction.date	transaction.date
transaction__datetime	TEXT	transaction.datetime	transaction.datetime
transaction__iso_currency_code	TEXT	transaction.iso_currency_code	transaction.iso_currency_code
transaction__location	OBJECT	transaction.location	transaction.location
transaction__merchant_name	TEXT	transaction.merchant_name	transaction.merchant_name
transaction__name	TEXT	transaction.name	transaction.name
transaction__payment_channel	TEXT	transaction.payment_channel	transaction.payment_channel
transaction__payment_meta	OBJECT	transaction.payment_meta	transaction.payment_meta
transaction__pending	BOOLEAN	transaction.pending	transaction.pending
transaction__pending_transaction_id	TEXT	transaction.pending_transaction_id	transaction.pending_transaction_id
transaction__personal_finance_category	TEXT	transaction.personal_finance_category	transaction.personal_finance_category
transaction__transaction_code	TEXT	transaction.transaction_code	transaction.transaction_code
transaction__transaction_id	TEXT	transaction.transaction_id	transaction.transaction_id
transaction__transaction_type	TEXT	transaction.transaction_type	transaction.transaction_type
transaction__unofficial_currency_code	TEXT	transaction.unofficial_currency_code	transaction.unofficial_currency_code

Plaid other fields

The Plaid connector has 5 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description	Report
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date