API Connectors

users-love-us medal soc2
Send your Plaid data to
Data StudioGoogle SheetsChatGPTClaudePower BIExcelTableauGoogle BigQueryAmazon S3Azure Blob StorageSnowflakeMySQLPostgreSQLPythonAzure SQLAmazon RedshiftDatabricksWindsor MCPMicrosoft FabricCopilot AgentPerplexityLovableAntigravitySupabase

Plaid Connector Reference

4 metrics30 dimensions
Fields

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