JSON Export Sample

JSON is the format for developers. If the data goes into your own code, a database or another service, JSON is easier to work with than CSV: each product is one object, and lists like images, categories and variants stay real lists instead of text joined with separators.

Download

Download JSON sample

The sample has 5 demo products from a clothing store, including products with variants and one item out of stock.

Structure

The file is an array of products. One product looks like this (shortened):

{
  "id": "101",
  "type": "variable",
  "sku": "NF-TS01",
  "name": "Classic Cotton T-Shirt",
  "regular_price": "19.90",
  "sale_price": "15.90",
  "currency": "USD",
  "in_stock": "yes",
  "categories": ["Clothing", "T-Shirts"],
  "brand": "Northfield",
  "attributes": [{"name": "Material", "values": ["100% cotton"]}],
  "options": [
    {"name": "Color", "values": ["White", "Black"]},
    {"name": "Size", "values": ["M", "L"]}
  ],
  "images": ["https://demo-store.example.com/images/nf-ts01-1.jpg"],
  "description": "<p>Soft cotton t-shirt with a regular fit.</p>",
  "url": "https://demo-store.example.com/product/nf-ts01/",
  "variations": [
    {
      "id": "10101",
      "sku": "NF-TS01-WHI-M",
      "attributes": [{"name": "Color", "value": "White"}, {"name": "Size", "value": "M"}],
      "regular_price": "19.90",
      "in_stock": "yes",
      "stock_qty": "12"
    }
  ]
}

A few things to know before you write the parser:

Reading it in Python

import json

with open('sample-products.json', encoding='utf-8') as f:
    products = json.load(f)

for p in products:
    price = float(p['sale_price'] or p['regular_price'] or 0)
    print(p['sku'], p['name'], price, len(p['variations']), 'variants')

JSON From Any Website With the AI Scraper

The sample above follows our store exporter format. With the AI web scraping tool you choose the structure yourself: describe the fields and say "save as result.json, an array of objects, prices as numbers". As a real example, here is the output of a scraper built from one paragraph for the public test catalog books.toscrape.com: 1,000 books with category, price, stock count, rating, UPC and image link.

Download aiscript-books.json   The same run also produced CSV and Excel files.

[
  {
    "title": "A Light in the Attic",
    "category": "Poetry",
    "price_gbp": 51.77,
    "availability_count": 22,
    "star_rating": 3,
    "product_url": "https://books.toscrape.com/catalogue/a-light-in-the-attic_1000/index.html",
    "image_url": "https://books.toscrape.com/media/cache/fe/72/fe72f0532301ec28892ae79a629a293c.jpg",
    "upc": "a897fe39b1053632"
  },
  {
    "title": "Tipping the Velvet",
    "category": "Historical Fiction",
    "price_gbp": 53.74,
    "availability_count": 20,
    "star_rating": 1,
    "product_url": "https://books.toscrape.com/catalogue/tipping-the-velvet_999/index.html",
    "image_url": "https://books.toscrape.com/media/cache/08/e9/08e94f3731d7d6b760dfbfbc02ca5c62.jpg",
    "upc": "90fa61229261140a"
  },
  ...
]

Need the data from an API instead of a file? Every AIScript task has an export API that returns the latest JSON file by URL, or tell us how you want to receive it.

AI

Have a scraping or integration task? Let our AI solve it.

Describe what data you need or which systems to connect — our AI builds and runs the scraper or integration for you. No coding required.

Free for 30 days, no card needed · already have an account?