Sample Orders JSON (Nested)

Forty order records with nested line-item arrays, computed totals, statuses, and foreign keys to the users dataset - deliberately nested for testing code that traverses structure.

https://jsonconsole.com/api/orders.json

40 records20 KBCORS: *

Download orders.json·Free for any use, no attribution required (CC0). Endpoint is stable - safe to use in tutorials and READMEs.

Preview

[
  {
    "id": 1,
    "orderNumber": "ORD-20260001",
    "userId": 54,
    "items": [
      {
        "productId": 16,
        "name": "Smart Charger",
        "quantity": 1,
        "unitPrice": 34.52
      },
      {
        "productId": 51,
        "name": "Ultra-Light Backpack",
        "quantity": 3,
        "unitPrice": 132.2
      },
      {
        "productId": 14,
        "name": "Modular Backpack",
        "quantity": 1,
        "unitPrice": 40.23
      }
    ],
    "total": 471.35,
    "currency": "USD",
    "status": "cancelled",
    "createdAt": "2025-10-07T07:21:00Z"
  },
  {
    "id": 2,
    "orderNumber": "ORD-20260002",
    "userId": 55,
    "items": [
      {
        "productId": 51,
        "name": "Ultra-Light Backpack",
        "quantity": 3,
        "unitPrice": 132.2
      },
      {
        "productId": 1,
        "name": "Ultra-Light Mouse",
        "quantity": 2,
        "unitPrice": 240.67
      }
    ],
    "total": 877.94,
    "currency": "USD",
    "status": "processing",
    "createdAt": "2025-09-09T05:07:00Z"
  },
  {
    "id": 3,
    "orderNumber": "ORD-20260003",
    "userId": 23,
    "items": [
      {
        "productId": 9,
        "name": "Ergonomic Monitor Stand",
        "quantity": 1,
        "unitPrice": 290.63
      }
    ],
    "total": 290.63,
    "currency": "USD",
    "status": "processing",
    "createdAt": "2026-01-06T08:03:00Z"
  }
]

First 3 records shown - the full file has 40 records.

Fields

Field	Type	Notes
id / orderNumber	number / string	ORD-2026NNNN format
userId	number	Foreign key into /api/users.json
items	object[]	Nested line items: productId, name, quantity, unitPrice
total	number	Sum of quantity × unitPrice
status	string	pending \| processing \| shipped \| delivered \| cancelled
createdAt	string (ISO 8601)	Order timestamp

Fetch it in code

JavaScript

const res = await fetch(
  "https://jsonconsole.com/api/orders.json"
);
const data = await res.json();

Python

import requests

data = requests.get(
    "https://jsonconsole.com/api/orders.json"
).json()

What this dataset is good for

Testing nested-JSON handling: flattening, table views, JSONPath queries
Joining across datasets (orders.userId → users.id) in tutorials
Order-status dashboards and state-machine UI prototypes

More sample data

Sample Users JSON Sample Products JSON Sample Employees JSON Sample Todos JSON

You might also need

Free and in-browser, like everything on JSON Console. Browse all tools →

Mock JSON GeneratorPaste one sample record and generate up to 1,000 mock records with the same structure JSON to CSVPaste a JSON array of objects on the left and get a spreadsheet-ready CSV with headers on the right JSON to SQLPaste a JSON array and get a CREATE TABLE statement with inferred column types plus one INSERT per row JSON ViewerExplore documents as tree, table, or graph.JSON FormatterFormat and validate with code, tree, table, and graph views.JSON ComparePaste two JSON documents and see only real differences JWT DecoderPaste a JWT and instantly see its decoded header and payload with expiry status JSON to TypeScriptPaste an API response and get TypeScript interfaces JSON MinifyPaste formatted JSON and get the smallest valid version