AzureCosmosDB / data-migration-desktop-tool

MIT License
129 stars 53 forks source link

Nested arrays are not supported with CSV Sink #94

Open SudhakarNandigam-TomTom opened 1 year ago

SudhakarNandigam-TomTom commented 1 year ago

Hi, The following is a document in Cosmos NoSQL:

{
    "entitlements": [
        {
            "id": "test1",
            "expiry": "date1"
        },
        {
            "id": "test2",
            "expiry": "date2"
        }
    ]
}

When using CSV sink, the document is exported as follows:

entitlements
System.Collections.Generic.List`1[System.Object]

Is there a way I can export the entitlements content in csv?

Thanks!

bowencode commented 9 months ago

What would you expect to see in the CSV output? Converting hierarchical to tabular data requires some type of flattening and that can be tricky for a tool like this that can accept any arbitrary data.