Database Variants API

Enhance product offerings with detailed product variant information.
Public access
Private access
February 6, 2024
1359
ms
957
k requests
45
votes
▶ Try for freeGet it customized
50 free credits, no credit card required
Request accessView pricing
Access to this API endpoint is limited, submit a request to gain access

Header

x-api-key required

string

This parameter defines the Retailed private key to use for authentification.

Parameters

where[or][0][and][0][category][equals]

string

An example of a query parameter for the category field : sneakers, collectibles, etc.

Sign up now and enjoy 50 free API requests + full access to our premium features and in-house proxy pool.
Request access to this private endpoint and unlock 50 free API requests, along with unrestricted use of our public API endpoints and in-house proxy pool.

Unlock detailed product variant insights

Explore the potential of our database variants endpoint in diversifying your e-commerce offerings. From size and color variations to unique attributes, cater to a broad customer base in fashion, technology, and beyond.

Advantages for expanding product lines

  • Customized offerings: Tailor your product listings to meet diverse customer preferences with detailed variant information.
  • Seamless integration: Works hand-in-hand with our product and prices endpoints for a holistic view.

Example applications

  • Personalized shopping experiences: Use variants to offer customers exactly what they're looking for.
  • Market analysis: Analyze variant popularity to inform stock and marketing decisions.

Getting started

Visit Retailed Docs for detailed information on the API endpoint, usage examples, and response formats.

Enhance your product listings by signing up on our API dashboard and accessing comprehensive variant data.

GET
POST
/api/v1/db/variants
Example Request
curl --location --request GET 'https://app.retailed.io/api/v1/db/variants?where[or][0][and][0][id][equals]=5702016914306' \
--header 'Content-Type: application/json' \
--header 'x-api-key: <token>' \
Response
{ "docs": [ { "id": "5702016914306", "products": [ { "id": "65495f135493f73e4ea4585d", "productId": "stockx-us-lego-friends-the-apartments-set-10292", "name": "stockx-us", "country": "us", "currency": "usd", "currencySymbol": "$", "url": "https://stockx.com/lego-friends-the-apartments-set-10292", "domain": "stockx.com", "urlSlug": "lego-friends-the-apartments-set-10292", "errorCrawling": false, "isNotFound": false, "createdAt": "2023-11-06T21:48:03.949Z", "updatedAt": "2024-01-18T09:42:46.025Z", "lastCrawledAt": "2024-01-18T09:42:44.442Z", "price": 150, "tax": [], "urlId": "3c0dd05e-999b-4cc3-a2ec-91c71ed5f7dc", "variants": [ "673419340311", "5702016914306" ], "description": "LEGO paid homage to one of the most popular sitcoms of all time with the LEGO Friends The Apartments Set. The set comes with 7 minifigures of the full Friends gang, and includes a build of Joey and Chandler’s, and Monica and Rachel’s apartments. The set also includes a joining hallway for the two apartments. \n<br>\n<br>\nThe full gang is outfitted with iconic and recognizable outfits from the show, adding a hint of nostalgia for fans of the show. \n<br>\n<br>\nThe LEGO Friends The Apartments Set was released in June 2021 for a retail price of $150. ", "images": [ "65a8f29547cea783f4fd2339" ], "sku": null, "title": "LEGO Friends The Apartments Set 10292" } ], "barcodeFormats": "EAN-13 5702016914306", "model": "Set 10292", "sku": null, "title": "LEGO Friends The Apartments Set 10292", "category": "collectibles", "brand": "LEGO", "size": null, "releaseDate": "2021-06-01T00:00:00.000Z", "description": "LEGO paid homage to one of the most popular sitcoms of all time with the LEGO Friends The Apartments Set. The set comes with 7 minifigures of the full Friends gang, and includes a build of Joey and Chandler’s, and Monica and Rachel’s apartments. The set also includes a joining hallway for the two apartments. \n<br>\n<br>\nThe full gang is outfitted with iconic and recognizable outfits from the show, adding a hint of nostalgia for fans of the show. \n<br>\n<br>\nThe LEGO Friends The Apartments Set was released in June 2021 for a retail price of $150. ", "features": [], "lastCrawledAt": "2024-01-18T09:42:44.813Z", "errorCrawling": false, "createdAt": "2024-01-18T09:42:45.131Z", "updatedAt": "2024-01-18T09:42:45.131Z", "reviews": [] } ], "totalDocs": 1, "limit": 10, "totalPages": 1, "page": 1, "pagingCounter": 1, "hasPrevPage": false, "hasNextPage": false, "prevPage": null, "nextPage": null
}
Trusted by top industry leaders
Retailed G2 reviews
5.0
Free trial
$0
No credit card required
50 credits once
1 credit = standard API request
2 credits
= JS rendering API request
5 requests per second
Clean & parsed data
Email support
Premium
$49/mo
$2.72 = 1,000 credits
18,000 credits
1 credit = standard API request
2 credits
= JS rendering API request
7 requests per second
Clean & parsed data
Email & chat support
Startup
$249/mo
$2.26 = 1,000 credits
110,000 credits
1 credit = standard API request
2 credits
= JS rendering API request
15 requests per second
Clean & parsed data
Email & chat support
Startup+
$499/mo
$2.17 = 1,000 credits
230,000 credits
1 credit = standard API request
2 credits
= JS rendering API request
20 requests per second
Clean & parsed data
Chat & Email support
Enterprise+
$999/mo
$1.88 = 1,000 credits
530,000 credits
1 credit = standard API request
2 credits
= JS rendering API request
30 requests per second
Clean & parsed data
Account manager
Custom
+$2,000/mo
Custom CPM price
Custom credits count
Custom requests rate
Clean & parsed data
Account manager
Free trial
0€
No credit card required
50 credits once
1 credit = standard API request
2 credits
= JS rendering API request
5 requests per second
Clean & parsed data
Email support
Premium
49€/mo
2,50€ = 1,000 credits
18,000 credits
1 credit = standard API request
2 credits
= JS rendering API request
7 requests per second
Clean & parsed data
Email & chat support
Startup
229€/mo
2,08€ = 1,000 credits
110,000 credits
1 credit = standard API request
2 credits
= JS rendering API request
15 requests per second
Clean & parsed data
Email & chat support
Startup+
459€/mo
2,00€ = 1,000 credits
230,000 credits
1 credit = standard API request
2 credits
= JS rendering API request
20 requests per second
Clean & parsed data
Chat & Email support
Enterprise+
919€/mo
1,73€ = 1,000 credits
530,000 credits
1 credit = standard API request
2 credits
= JS rendering API request
30 requests per second
Clean & parsed data
Account manager
Custom
+2,000€/mo
Custom CPM price
Custom credits count
Custom requests rate
Clean & parsed data
Account manager

Only pay for successful requests

Use Retailed private proxy pool

Get 10% off when buying annual subscriptions
Retailed G2 reviews
5.0
Accepted payment methods:

In need of something custom?

Benefit from the expertise of our seasoned team, skilled in sourcing the exact data you need and creating custom-tailored endpoints to meet your specific business requirements.