How to Export Asset Metadata from Brandfolder

Download as CSV (the metasheet)

Brandfolder API (v4)

import csv
import requests

API_KEY = "your_api_key"          # brandfolder.com/profile#integrations
BRANDFOLDER_ID = "your_brandfolder_id"

BASE = "https://brandfolder.com/api/v4"
HEADERS = {
    "Authorization": f"Bearer {API_KEY}",
    "Content-Type": "application/json",
    "Accept": "application/json",
}


def fetch_assets(brandfolder_id):
    """Page through every asset, keeping the included custom fields and tags."""
    assets, included = [], []
    page, per = 1, 3000          # 3000 is the documented maximum page size

    while True:
        resp = requests.get(
            f"{BASE}/brandfolders/{brandfolder_id}/assets",
            headers=HEADERS,
            params={
                "page": page,
                "per": per,
                "include": "custom_fields,tags",
                "fields": "created_at,updated_at",
            },
        )
        resp.raise_for_status()
        payload = resp.json()

        assets.extend(payload.get("data", []))
        included.extend(payload.get("included", []))

        meta = payload.get("meta", {})
        if not meta.get("next_page"):
            break
        page = meta["next_page"]

    return assets, included


def index_included(included):
    """Custom fields and tags arrive in a separate array, keyed by id."""
    lookup = {}
    for item in included:
        lookup[(item.get("type"), item.get("id"))] = item.get("attributes", {})
    return lookup


assets, included = fetch_assets(BRANDFOLDER_ID)
lookup = index_included(included)

rows = []
custom_field_names = set()

for asset in assets:
    attrs = asset.get("attributes", {})
    rels = asset.get("relationships", {})

    row = {
        "Asset ID": asset.get("id", ""),
        "Name": attrs.get("name", ""),
        "Description": attrs.get("description", ""),
        "Approved": attrs.get("approved", ""),
        "Created": attrs.get("created_at", ""),
        "Updated": attrs.get("updated_at", ""),
    }

    tags = []
    for ref in rels.get("tags", {}).get("data", []) or []:
        tag = lookup.get(("tags", ref.get("id")), {})
        if tag.get("name"):
            tags.append(tag["name"])
    row["Tags"] = "; ".join(tags)

    # Custom fields become their own columns, one per key.
    for ref in rels.get("custom_fields", {}).get("data", []) or []:
        field = lookup.get(("custom_fields", ref.get("id")), {})
        key = field.get("key") or field.get("name")
        value = field.get("value")
        if not key:
            continue
        custom_field_names.add(key)
        row[key] = f"{row[key]}; {value}" if key in row else value

    rows.append(row)

columns = [
    "Asset ID", "Name", "Description", "Approved",
    "Created", "Updated", "Tags",
] + sorted(custom_field_names)

with open("brandfolder_metadata.csv", "w", newline="", encoding="utf-8") as f:
    writer = csv.DictWriter(f, fieldnames=columns, extrasaction="ignore")
    writer.writeheader()
    for row in rows:
        writer.writerow(row)

print(f"Exported {len(rows)} assets to brandfolder_metadata.csv")