Columbia APIcolumbia.com ↗
Access Columbia Sportswear product data via API: search listings, specs, pricing, availability, reviews, fit details, and images across 8 endpoints.
What is the Columbia API?
The Columbia Sportswear API provides 8 endpoints covering product search, category browsing, technical specifications, availability, and customer reviews from columbia.com. The search_products endpoint returns paginated results with faceted filters across gender, size, color, and activity, while get_product_details exposes pricing ranges, variation data, promotions, and feature descriptions for any style number.
curl -X GET 'https://api.parse.bot/scraper/48a800e6-d106-49d9-a0d4-e0c737705b86/search_products?limit=5&query=jacket&start=0' \ -H 'X-API-Key: $PARSE_API_KEY'
Typed, relational, agent-ready
A generated client with real types, enums, and the links between objects — the structure a flat JSON response can't carry. Autocompletes in your editor and reads cleanly to coding agents.
- Fully typed · autocompletes
- Objects link to objects
- Typed errors & pagination
Typed Python client. Set up the SDK in your uv project, then pull this API’s typed client:
uv add parse-sdk uv run parse init uv run parse add --marketplace columbia-com-api
uv run parse add --marketplace pulls a pinned snapshot of this canonical API — it won’t change underneath you. To customize it, subscribe and swap to your own copy.
from parse_apis.columbia_sportswear_api import Columbia, ProductSummary, Product, Review
columbia = Columbia()
# Search for jackets in the catalog
for item in columbia.catalogs.search(query="fleece", limit=3):
print(item.variation_name, item.sale_price, item.product_class)
# Navigate from summary to full product detail
product = item.details()
print(product.name, product.overall_rating, product.review_count)
# Get fit and fabric info
fit_fabric = product.fit_and_fabric()
print(fit_fabric.fabric, fit_fabric.care_instructions)
# Get features and technologies
feats = product.features()
if feats.technologies:
for tech in feats.technologies:
print(tech.value, tech.display_value)
# Check availability
avail = product.availability()
for variant in avail.availability:
print(variant.orderable, variant.attributes.color, variant.attributes.size)
# Get reviews
for review in product.reviews(limit=2):
print(review.rating, review.title, review.user_nickname, review.submission_time)
break
Full-text search over Columbia Sportswear's product catalog via the Unbxd search engine. Returns paginated product listings with variant information (colors, sizes, images), pricing, and faceted filters (gender, product type, size, color). Each product includes up to 100 variant expansions. Pagination is offset-based via the start parameter.
| Param | Type | Description |
|---|---|---|
| limit | integer | Number of products to return per page. |
| queryrequired | string | Search keyword (e.g., 'jacket', 'fleece', 'hiking boots'). |
| start | integer | Offset for pagination (0-based). |
{
"type": "object",
"fields": {
"start": "integer current offset",
"facets": "object containing available filter facets (gender, product type, size, color, etc.)",
"products": "array of product listing objects with variant details, pricing, and metadata",
"searchMetaData": "object containing query metadata including status and queryTime",
"number_of_products": "integer total number of matching products"
},
"sample": {
"data": {
"start": 0,
"facets": {
"text": {
"list": [
{
"values": [
"Men's",
242,
"Women's"
],
"facetName": "gender_uFilter",
"displayName": "Gender"
}
]
}
},
"products": [
{
"gender": [
"Women's"
],
"masterUrl": "https://www.columbia.com/p/womens-switchback-iv-jacket-2086711.html",
"productId": "2086711",
"salePrice": 49,
"productClass": "Rain Shell",
"productPitch": "Coverage for unpredictable drizzles.",
"variationName": "Women's Switchback IV Jacket"
}
],
"searchMetaData": {
"status": 0,
"queryTime": 63
},
"number_of_products": 479
},
"status": "success"
}
}About the Columbia API
Search and Browse
The search_products endpoint accepts a query string (e.g., 'fleece', 'hiking boots') and returns a response object with numberOfProducts, a start offset, and a products array containing variant-level details. The facets object exposes filterable dimensions including gender, product type, size, and color. For category-level browsing, get_category_products accepts a category_path like 'men>men-jackets' and returns the same structure, with facets scoped to that category such as activity and product type. Both endpoints support limit and start parameters for pagination.
Product Detail and Variations
get_product_details returns a full data object for a given product_id: the pricing field includes minsale, maxsale, minlist, and maxlist values; variations lists color and size attributes across all SKUs; promotions carries calloutMsg, name, and promotionClass; and images is an array of image groups keyed by viewType. get_product_availability returns an availability array with per-variant orderable status and the associated color and size attributes, making it straightforward to identify which combinations are currently in stock.
Specifications and Media
Three focused endpoints cover the granular product attributes that appear on a product detail page. get_product_fit_and_fabric returns a fit object with value and displayValue (e.g., 'Active Fit'), a fabric string with composition details, and a care_instructions string. get_product_features returns a features array of description strings alongside a technologies array with value and displayValue for Columbia-branded technologies. get_product_images returns all image groups for a product organized by viewType and optional variationAttributes, with each image carrying link, alt, and title fields.
Customer Reviews
get_product_reviews retrieves Bazaarvoice review data for a product. The response follows Bazaarvoice's batched format: BatchedResults contains a q0 key with a Results array (individual reviews with ratings, text, and author info), a TotalResults count, and an Includes object with supplementary metadata. The offset and limit parameters control pagination through the review set.
The Columbia API is a managed, monitored endpoint for columbia.com — not a raw scraper you maintain. Every endpoint is automatically health-checked on a schedule, and when columbia.com changes and a check fails, the API is automatically queued for repair and re-verified. It is built to keep working as the site underneath it changes.
This isn't an official columbia.com API — it's an independent, maintained REST wrapper over public data. Where the source has no official API (or only a limited one), Parse gives you a stable contract over a source that never promised one, and keeps it current. Need a new endpoint or field? You can revise it yourself in plain English and the agent rebuilds it against the live site in minutes — contributing the change back to the shared API is free.
Will this API break when the source site changes?+
Is this an official API from the source site?+
Can I fix or extend this API myself if I need a new endpoint or field?+
What happens if I call an endpoint that has an issue?+
- Sync Columbia product catalog with pricing ranges from
get_product_detailsinto a comparison shopping engine. - Monitor per-SKU
orderablestatus viaget_product_availabilityto trigger restock alerts for specific color/size combinations. - Aggregate customer ratings and review text from
get_product_reviewsfor sentiment analysis across outerwear categories. - Build a gear recommendation tool using
get_product_fit_and_fabricto filter by fit type and fabric composition. - Index Columbia's proprietary technologies from
get_product_featuresto let users filter by performance feature (e.g., Omni-Heat, Omni-Tech). - Pull category-level facets from
get_category_productsto populate dynamic filter UIs for a product discovery interface. - Extract structured image sets via
get_product_imagesto populate a lookbook or product feed requiring multiple view angles per color variant.
| Tier | Price | Credits/month | Rate limit |
|---|---|---|---|
| Free | $0/mo | 100 | 5 req/min |
| Hobby | $30/mo | 1,000 | 20 req/min |
| Developer | $100/mo | 5,000 | 100 req/min |
One credit = one API call regardless of which marketplace API you call. Exceeding the rate limit returns a 429 response. Authenticate with the X-API-Key header.
Does Columbia Sportswear have an official developer API?+
What does `get_product_availability` return, and does it distinguish between in-store and online availability?+
availability array where each entry has a productId, an orderable boolean, and attributes specifying the color and size. It reflects online availability status only — it does not distinguish in-store stock levels at specific retail locations. You can fork this API on Parse and revise it to add a store-level availability endpoint if that data becomes accessible.Can I retrieve wish list or user account data through this API?+
How does pagination work across search and category endpoints?+
search_products and get_category_products accept start (0-based offset) and limit (results per page) parameters. The response.numberOfProducts field in the result tells you the total matching count, which you can use to calculate how many pages exist and when to stop paginating.Does the reviews endpoint return aggregated rating statistics or just individual reviews?+
BatchedResults.q0 object includes both a Results array of individual reviews and an Includes object that carries supplementary product-level statistics from Bazaarvoice, such as overall rating distributions. The TotalResults field gives the total review count for the product.