How to turn an array of JSON positions into CSV strings

Problem

One order has an array of positions. We want each position to become a separate CSV row.

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

{
  "order": "O-001",
  "customer": "Customer 1",
  "items": [
    { "sku": "SKU-1", "qty": 2 },
    { "sku": "SKU-2", "qty": 1 }
  ]
}

It became

order,customer,sku,qty
O-001,Customer 1,SKU-1,2
O-001,Customer 1,SKU-2,1

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.