Brandfolder Connector Reference

4 metrics42 dimensions

Fields

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

Brandfolder Fields

Brandfolder Assets fields

The Assets report of the Brandfolder connector includes 10 fields.

ID	Type	Name	Description
asset_approved	BOOLEAN	Asset Approved	Whether the asset is approved.
asset_cdn_url	IMAGE_URL	Asset CDN URL	CDN image URL of the asset.
asset_created_at	TIMESTAMP	Asset Created At	Timestamp the asset was created.
asset_description	TEXT	Asset Description	Description of the asset.
asset_id	TEXT	Asset id	Unique identifier of the asset.
asset_name	TEXT	Asset name	Name of the asset.
asset_thumbnail_url	IMAGE_URL	Asset Thumbnail URL	Thumbnail image URL of the asset.
asset_updated_at	TIMESTAMP	Asset Updated At	Timestamp the asset was last updated.
brandfolder_id	TEXT	Brandfolder ID	Unique identifier of the brandfolder the asset belongs to.
brandfolder_name	TEXT	Brandfolder Name	Name of the brandfolder the asset belongs to.

Brandfolder Attachments fields

The Attachments report of the Brandfolder connector includes 15 fields.

ID	Type	Name	Description
attachment_asset_id	TEXT	Attachment Asset ID	Identifier of the asset the attachment belongs to.
attachment_cdn_url	IMAGE_URL	Attachment CDN URL	CDN image URL of the attachment.
attachment_created_at	TIMESTAMP	Attachment Created At	Timestamp the attachment was created.
attachment_extension	TEXT	Attachment Extension	File extension of the attachment.
attachment_filename	TEXT	Attachment Filename	Filename of the attachment.
attachment_height	NUMERIC	Attachment Height	Height of the attachment in pixels.
attachment_id	TEXT	Attachment ID	Unique identifier of the attachment.
attachment_mimetype	TEXT	Attachment Mimetype	MIME type of the attachment.
attachment_original_filename	TEXT	Attachment Original Filename	Original filename of the uploaded attachment.
attachment_position	NUMERIC	Attachment Position	Position of the attachment within its asset.
attachment_size	NUMERIC	Attachment Size	Size of the attachment in bytes.
attachment_thumbnail_url	IMAGE_URL	Attachment Thumbnail URL	Thumbnail image URL of the attachment.
attachment_updated_at	TIMESTAMP	Attachment Updated At	Timestamp the attachment was last updated.
attachment_url	IMAGE_URL	Attachment URL	Downloadable file URL of the attachment.
attachment_width	NUMERIC	Attachment Width	Width of the attachment in pixels.

Brandfolder General fields

The General report of the Brandfolder connector includes 3 fields.

ID	Type	Name	Description
account_id	TEXT	Account ID	The Brandfolder organization key behind the API key.
account_name	TEXT	Account Name	The Brandfolder organization name behind the API key.
date	DATE	Date	Snapshot date of the query end date. Assets and attachments are returned in full; use the created/updated fields for real timestamps.

Brandfolder other fields

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

ID	Type	Name	Description
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
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year
year_month	TEXT	Yearmonth	Year and month, e.g. 2024\|3
year_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024\|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024\|20