Json structured data export CSV

Question

I complicated json structure ie:

{
  "products": [
    {
      "id": "1234567890",
      "productType": {
        "name": "XYZ"
      },
      "masterData": {
        "current": {
          "masterVariant": {
            "assets": [],
            "images": [
              {
                "url": "https://www.nieuwkoopimages.com/images/123456.png",
                "dimensions": {
                  "w": 0,
                  "h": 0
                }
              }
            ]
          }
        }
      }
    }
  ]
}

I need to export this to csv file. Is it possible to do it in automated way ? that will generate for example columns: products.id, products.productType.name, products.masterData.curent etc etc

? thanks!

Only a subset of all kinds of possible JSON translate unambiguously to CSV. What result would you expect for this data? — MisterMiyagi, Sep 17 '21 at 09:31
Who is going to be using this CSV and what format is acceptable to them? — Iain Shelvington, Sep 17 '21 at 09:33
What key would there be if there were more than one product, and what keys would there be if there were another category next to product? — MisterMiyagi, Sep 17 '21 at 09:33
guys Ive already wrote it in description I want csv with columns like: products.id, products.productType.name, products.masterData.curent — FrancMo, Sep 17 '21 at 10:16
and why I received -1 ? whats wrong with my question ? omg I dont get ppl in SO. — FrancMo, Sep 17 '21 at 10:18
Does this answer your question? [How can I convert JSON to CSV?](https://stackoverflow.com/questions/1871524/how-can-i-convert-json-to-csv) — MisterMiyagi, Sep 17 '21 at 10:20

score -2 · Answer 1 · answered Sep 17 '21 at 09:34

-2

In CSV file you have only one flat table. If you want to export single product as one row, you must prepare serialization for deep objects. The biggest problem is with inner lists.

answered Sep 17 '21 at 09:34

M. Liver

97
6

yes I know that, its obvious, thats why I want to export them as name.fielda.fieldb.fieldc – FrancMo Sep 17 '21 at 10:15

Json structured data export CSV

1 Answers1