Stop bouncing between multiple tabs to check regional retail prices, BrickLink transaction history, and minifigure valuations. Calpamos delivers unified, high-density pricing signals into your existing Google Sheets, Excel sheets, and custom hobby projects.
4-quadrant pricing signals for both New Sealed and Used sets: last 6 months completed transaction averages, minimum/maximum sold prices, and current active stock asking depth from global secondary markets.
Compare live purchasing prices across major regional stores throughout North America and the Middle East (Amazon US, LEGO US, Target US, Walmart US, Barnes & Noble US, Books-A-Million US, Amazon UAE, LEGO Certified Stores, FirstCry, Borders, Alab Toys, Noon, Carrefour, and more). Includes automated discount percentages against official retail MSRP and direct purchase links.
Decomposes any set into its complete constituent minifigure roster with individual market values, total minifigure portfolio worth, and automated Part-Out Value Ratios (calculating if a set is worth more sealed or parted out).
Seamlessly handles bare set numbers (e.g. 75188), standard releases (75188-1), and rare production collector variants (like the Finch Dallow version), mapping barcodes and sequence suffixes automatically.
Fast, normalized REST JSON endpoints returning dense metrics in under 50 milliseconds, plus direct RFC 4180 CSV feeds optimized for high-speed spreadsheet cell updates.
Instant access to piece counts, release years, themes, barcodes (EAN/UPC), and official launch MSRP across major currencies (USD, EUR, GBP, and regional AED).
Paste this formula directly into cell A1 of any Google Sheet. It immediately pulls live pricing, discounts, and BrickLink market depth for your sets into structured columns:
=IMPORTDATA("https://api.calpamos.app/v1/pro/export/sheets?api_key=YOUR_TRIAL_KEY&set_ids=75192,75333,10316,21337,71043")
| Set No | Set Name | Theme | Retail MSRP | Lowest Store | Lowest Price | Discount | BL New Sold | BL New Ask | Minifigs Total | Part-Out % |
|---|---|---|---|---|---|---|---|---|---|---|
| 75192-1 | UCS Millennium Falcon | Star Wars | $849.99 | FirstCry UAE | 2,542.43 AED | -10.5% | $715.85 | $1,038.00 | $89.93 | 12.6% |
| 75333-1 | Obi-Wan's Jedi Starfighter | Star Wars | $29.99 | Amazon UAE | 97.98 AED | -12.0% | $26.68 | $39.37 | $14.20 | 53.2% |
| 10316-1 | LOTR: Rivendell | Icons | $499.99 | LEGO UAE | 2,259.00 AED | MSRP | $520.00 | $615.00 | $195.40 | 37.5% |
| 21337-1 | Table Football | Ideas | $249.99 | Secondary Only | 926.46 AED | - | $186.82 | $252.27 | $48.50 | 26.0% |
A simple Python script to look up live market overview, BrickLink secondary depth, and minifigure values:
import requests
API_KEY = "YOUR_TRIAL_KEY"
SET_ID = "75192-1" # Millennium Falcon
# Query unified market overview
url = f"https://api.calpamos.app/v1/sets/{SET_ID}/market-overview"
headers = {"X-API-Key": API_KEY}
data = requests.get(url, headers=headers).json()
print(f"Set: {data['name']} ({data['theme']})")
print(f"Official MSRP: {data['retail_rrp']} {data['retail_rrp_currency']}")
print(f"Lowest Store: {data['market_overview']['lowest_store']} @ {data['market_overview']['lowest_price']} AED")
# Secondary market depth from BrickLink
bl = data.get("bricklink_depth", {})
if "new_stock" in bl:
print(f"BrickLink New Stock Ask: ${bl['new_stock']['avg_price']:.2f} USD")
if "new_sold" in bl:
print(f"BrickLink 6-Month Sold Avg: ${bl['new_sold']['avg_price']:.2f} USD")
# Minifigure portfolio valuation
mf = data.get("minifigures", {})
print(f"Minifigures: {mf.get('count', 0)} total, Worth: ${mf.get('total_value_usd', 0):.2f} USD")
Query any set from terminal or HTTP client. Explore full schema definitions in Swagger UI:
# 1. Fetch live market overview & secondary depth
curl -s -H "X-API-Key: YOUR_TRIAL_KEY" "https://api.calpamos.app/v1/sets/75192-1/market-overview"
# 2. Fetch constituent minifigures decomposition
curl -s -H "X-API-Key: YOUR_TRIAL_KEY" "https://api.calpamos.app/v1/sets/75192-1/minifigs"
# 3. High-density batch matrix (up to 100 sets in one call)
curl -s -X POST -H "X-API-Key: YOUR_TRIAL_KEY" -H "Content-Type: application/json" -d '{"set_ids": ["75192", "75333", "10316"]}' "https://api.calpamos.app/v1/pro/sets/batch-matrix"
Paste this prompt directly into your AI chat window to generate custom python scripts, web widgets, or spreadsheet tools with zero coding experience:
I want to build a Python script (or Google Apps Script) that tracks my LEGO collection. Here is the live OpenAPI specification for the Calpamos LEGO Market API: https://api.calpamos.app/openapi.json My API key is: YOUR_TRIAL_KEY Please inspect the schema and write a clean script that: 1. Queries the market overview for sets: 75192, 75333, and 10316 2. Extracts the lowest buyable store price, discount %, and BrickLink new sold average 3. Alerts me if any set is currently discounted by more than 15%
Working in an agentic coding environment or IDE? Give your assistant the schema directly so it writes typed models and complete API integrations without hallucinating fields:
# 1. Fetch the specification to your local workspace: curl -s https://api.calpamos.app/openapi.json -o calpamos_spec.json # 2. Prompt your coding assistant: "Inspect @calpamos_spec.json and generate a typed client library with Pydantic/TypeScript models to fetch market overviews, retail pricing, and minifigure valuations. Authenticate using X-API-Key."
Build a personalized LEGO Market Advisor inside ChatGPT:
https://api.calpamos.app/openapi.jsonX-API-Key).Whether you are managing a personal collection spreadsheet, building an arbitrage tracker, coding a personal Discord bot, or analyzing market trends for your next build, I want to hear about it!
I built this engine to solve my own market tracking frustrations, and I am excited to see how fellow collectors put this data to work. Reach out directly to share what you are working on, suggest fields or stores you need, and test the engine with real collection data.
Short-Term Evaluation Access: Access is provided on an informal, short-term trial basis to help you assess whether live automated data benefits your workflow, and to help me stress-test the backend against real-world collection use cases. Access may be modified, limited, or concluded at any time.
No Warranties ("As-Is"): This service is provided strictly as-is for personal evaluation purposes without warranty or guarantee of uptime, completeness, or continuous availability. Pricing and inventory signals reflect periodic market snapshots and should always be independently verified prior to significant financial purchases.
Trademark Notice: LEGO® is a trademark of the LEGO Group of companies which does not sponsor, authorize, or endorse this independent project.
Send me a direct message on WhatsApp or reach out to request a complimentary trial API key. Just let me know what sets or themes you're interested in tracking!