How to parse nested JSON object into CSV columns

Problem

The JSON has nested objects with price and category. I need a CSV where each nested field becomes a separate column.

Short answer

Use a JSON editor: select the desired node, set transformations and upload the result to the target structure.

Sample task

The data below is educational. They show the conversion form, not the users' actual files.

It was

{
  "id": "P-001",
  "name": "Product 1",
  "category": {
    "name": "Section A",
    "code": "A"
  },
  "price": {
    "value": 1200,
    "currency": "EUR"
  }
}

It became

id,name,category_name,category_code,price_value,price_currency
P-001,Product 1,Section A,A,1200,EUR

How to set up

1. Upload your file and go to the JSON editor.
2. In the editor, find the desired value or node and click on it to open the settings window.
3. In the block "Transformations" add rules for selecting, renaming, or assembling values.
4. If some records need to be excluded, use a block "Unloading conditions".
5. Save the settings and download the result in the target format.