How to Export Asset Metadata from Canto

Canto Library - Metadata Export

Canto REST API

import requests
import csv

CANTO_DOMAIN = "your-org.canto.com"
ACCESS_TOKEN = "your_access_token"
HEADERS = {"Authorization": f"Bearer {ACCESS_TOKEN}"}

def search_assets(keyword="*", limit=100):
    """Search all assets with pagination."""
    all_assets = []
    start = 0
    while True:
        resp = requests.get(
            f"https://{CANTO_DOMAIN}/api/v1/search",
            headers=HEADERS,
            params={
                "keyword": keyword,
                "limit": limit,
                "start": start,
                "scheme": "image,video,document,audio,presentation,other",
                "sortBy": "time",
                "sortDirection": "descending",
            },
        )
        data = resp.json()
        results = data.get("results", [])
        if not results:
            break
        all_assets.extend(results)
        start += limit
        if start >= data.get("found", 0):
            break
    return all_assets

assets = search_assets()

with open("canto_metadata.csv", "w", newline="") as f:
    writer = csv.writer(f)
    writer.writerow([
        "ID", "Name", "Description", "Scheme", "Size",
        "Width", "Height", "Created", "Modified",
        "Tags", "Categories", "Copyright"
    ])
    for asset in assets:
        default = asset.get("default", {})
        writer.writerow([
            asset.get("id", ""),
            asset.get("name", ""),
            default.get("Description", ""),
            asset.get("scheme", ""),
            asset.get("size", ""),
            default.get("Image Width", ""),
            default.get("Image Height", ""),
            default.get("Date uploaded", ""),
            default.get("Date modified", ""),
            ", ".join(asset.get("tag", [])) if asset.get("tag") else "",
            ", ".join(
                cat.get("name", "") for cat in asset.get("relatedCategories", [])
            ) if asset.get("relatedCategories") else "",
            default.get("Copyright", ""),
        ])

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