Export model data to CSV

using Speckle.Objects.Data;
using Speckle.Sdk.Models;
using Speckle.Sdk.Models.Extensions;

static string? GetProp(DataObject obj, params string[] keys)
{
    foreach (var key in keys)
        if (obj.properties.TryGetValue(key, out var val) && val is string s)
            return s;
    return null;
}

static bool IsDoor(Base obj) =>
    obj is DataObject d &&
    (GetProp(d, "category", "builtInCategory")?.Contains("Door", StringComparison.OrdinalIgnoreCase) ?? false);

var doors = root.Flatten().Where(IsDoor).Cast<DataObject>().ToList();

var outputPath = "door-schedule.csv";
await using (var writer = new StreamWriter(outputPath))
{
    await writer.WriteLineAsync("Name,Level,Type,FireRating");
    foreach (var door in doors)
    {
        var name = door.name ?? "";
        var level = GetProp(door, "level", "Level") ?? "";
        var type = GetProp(door, "type", "family", "Family") ?? "";
        var fireRating = GetProp(door, "fireRating", "Fire Rating") ?? "";

        static string CsvCell(string value) =>
            value.Contains(',') || value.Contains('"') ? $"\"{value.Replace("\"", "\"\"")}\"" : value;

        await writer.WriteLineAsync(
            $"{CsvCell(name)},{CsvCell(level)},{CsvCell(type)},{CsvCell(fireRating)}");
    }
}

Console.WriteLine($"Exported {doors.Count} doors to {outputPath}");