columbia.com APIcolumbia.com ↗
Access Columbia Sportswear product data via API: search listings, specs, pricing, availability, reviews, fit details, and images across 8 endpoints.
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'
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.com 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.
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.
- 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 | 250 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.