How to Export Asset Metadata from Acquia DAM

Acquia DAM - Metadata Export

Acquia DAM API

import requests
import csv

BASE_URL = "https://api.widencollective.com/v2"
TOKEN = "your_api_token"
HEADERS = {"Authorization": f"Bearer {TOKEN}"}

def search_assets(query="*", limit=100):
    """Search all assets with pagination."""
    all_assets = []
    offset = 0
    while True:
        resp = requests.get(
            f"{BASE_URL}/assets/search",
            headers=HEADERS,
            params={
                "query": query,
                "limit": limit,
                "offset": offset,
                "expand": "metadata,embeds,categories",
            },
        )
        data = resp.json()
        items = data.get("items", [])
        if not items:
            break
        all_assets.extend(items)
        offset += limit
        total = data.get("total_count", 0)
        if offset >= total:
            break
    return all_assets

assets = search_assets()

with open("acquia_dam_metadata.csv", "w", newline="") as f:
    writer = csv.writer(f)
    writer.writerow([
        "ID", "File Name", "Title", "Description",
        "File Type", "File Size", "Width", "Height",
        "Created", "Modified", "Categories", "Keywords"
    ])
    for asset in assets:
        metadata = asset.get("metadata", {})
        fields = metadata.get("fields", {})
        writer.writerow([
            asset.get("id", ""),
            asset.get("filename", ""),
            fields.get("title", [""])[0] if fields.get("title") else "",
            fields.get("description", [""])[0] if fields.get("description") else "",
            asset.get("file_properties", {}).get("format_type", ""),
            asset.get("file_properties", {}).get("size_in_kbytes", ""),
            asset.get("file_properties", {}).get("image_properties", {}).get("width", ""),
            asset.get("file_properties", {}).get("image_properties", {}).get("height", ""),
            asset.get("created_date", ""),
            asset.get("last_update_date", ""),
            "; ".join(
                cat.get("name", "")
                for cat in asset.get("categories", [])
            ),
            "; ".join(fields.get("keywords", [])) if fields.get("keywords") else "",
        ])

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