data-transformation Scenario 4 — Extract Nested List Data and Export Parquet

Written by RTILA X Engineering Team

Intermediate ~6 min

Prerequisites: data-transformation/1 data-transformation/2

What You'll Learn

Chain multiple transformations on a dataset

Real-World Use Case

Cleaning and enriching leads

LIVE DEMO

Nested List Extraction

Product items with nested tag and image lists.

Wireless Headphones

electronicssalenew

Gaming Monitor

electronicsgamingfeatured

Ergonomic Keyboard

electronicsofficenew

USB-C Charger

electronicsaccessoriessale

EXPECTED OUTPUT

Nested Items

[
  {
    "title": "Wireless Headphones",
    "tags": [
      "electronics",
      "sale",
      "new"
    ],
    "images": [
      "/images/products/headphones-1.jpg",
      "/images/products/headphones-2.jpg"
    ]
  },
  {
    "title": "Gaming Monitor",
    "tags": [
      "electronics",
      "gaming",
      "featured"
    ],
    "images": [
      "/images/products/monitor-1.jpg",
      "/images/products/monitor-2.jpg"
    ]
  },
  {
    "title": "Ergonomic Keyboard",
    "tags": [
      "electronics",
      "office",
      "new"
    ],
    "images": [
      "/images/products/keyboard-1.jpg",
      "/images/products/keyboard-2.jpg"
    ]
  },
  {
    "title": "USB-C Charger",
    "tags": [
      "electronics",
      "accessories",
      "sale"
    ],
    "images": [
      "/images/products/charger-1.jpg",
      "/images/products/charger-2.jpg"
    ]
  }
]

RTILA X PROJECT JSON

RTILA X Automation Project

extract-nested-lists.json

{
  "name": "Extract_Nested_Lists",
  "settings": {
    "urls": [
      "https://learn.rtila.com/scenarios/data-transformation/4"
    ]
  },
  "datasets": {
    "nested_items": {
      "item_selector": "css=.nested-item",
      "properties": [
        {
          "name": "title",
          "type": "text",
          "selector": "css=.nested-title"
        },
        {
          "name": "tags",
          "type": "list",
          "selector": "css=.tag",
          "properties": [
            {
              "name": "tag_name",
              "type": "text",
              "selector": "css=self"
            }
          ]
        },
        {
          "name": "images",
          "type": "list",
          "selector": "css=.nested-img",
          "properties": [
            {
              "name": "src",
              "type": "attribute",
              "selector": "css=self",
              "attribute": "src"
            }
          ]
        }
      ]
    }
  },
  "commands": [
    {
      "command": "extract_data",
      "params": {
        "dataset": "nested_items"
      }
    },
    {
      "command": "comment",
      "params": {
        "text": "Parquet export would preserve nested arrays natively"
      }
    }
  ]
}

List-type properties allow nested collection extraction. Each nested list can have its own properties, creating hierarchical data ready for formats like Parquet.

Did you complete this scenario?

Ready to run this automation?

Copy the project JSON above, open RTILA X, create a new project, and paste it.

Download RTILA X Free → View setup guide →

This scenario covers 2 RTILA X commands and is referenced in 2 learning articles.

Continue Learning

Was this helpful?