curl --location --request GET 'https://app.retailed.io/api/v1/db/products?where[or][0][and][0][productId][equals]=stockx-us-air-jordan-alpha-1-university-blue' \
--header 'Content-Type: application/json' \
--header 'x-api-key: <token>' \
{
"docs": [
{
"id": "65495f475493f73e4ea472ea",
"productId": "stockx-us-air-jordan-alpha-1-university-blue",
"name": "stockx-us",
"country": "us",
"currency": "usd",
"currencySymbol": "$",
"url": "https://stockx.com/air-jordan-alpha-1-university-blue",
"domain": "stockx.com",
"urlSlug": "air-jordan-alpha-1-university-blue",
"errorCrawling": false,
"isNotFound": false,
"createdAt": "2023-11-06T21:48:55.897Z",
"updatedAt": "2024-01-18T09:40:13.428Z",
"lastCrawledAt": "2024-01-18T09:40:11.403Z",
"price": 125,
"urlId": "69b1ca16-a37f-4643-99b4-55d037e56ec9",
"variants": [
{
"id": "884500475069",
"products": [
"65495f475493f73e4ea472ea"
],
"barcodeFormats": "UPC-A 884500475069",
"model": "Jordan Alpha 1",
"sku": "392813-103",
"title": "Jordan Alpha 1 University Blue",
"category": "sneakers",
"brand": "Jordan",
"color": "White/Black-University Blue",
"size": "9",
"releaseDate": "2010-03-13T00:00:00.000Z",
"lastCrawledAt": "2024-01-18T09:40:11.555Z",
"errorCrawling": false,
"createdAt": "2023-11-17T00:46:04.652Z",
"updatedAt": "2024-01-18T09:40:11.660Z",
"description": null,
"reviews": []
},
{
"id": "884500475106",
"products": [
"65495f475493f73e4ea472ea"
],
"barcodeFormats": "UPC-A 884500475106",
"model": "Jordan Alpha 1",
"sku": "392813-103",
"title": "Jordan Alpha 1 University Blue",
"category": "sneakers",
"brand": "Jordan",
"color": "White/Black-University Blue",
"size": "11",
"releaseDate": "2010-03-13T00:00:00.000Z",
"lastCrawledAt": "2024-01-18T09:40:12.077Z",
"errorCrawling": false,
"createdAt": "2023-11-17T00:46:04.986Z",
"updatedAt": "2024-01-18T09:40:12.168Z",
"description": null,
"reviews": []
}
],
"description": null,
"images": [
{
"id": "65a8f1fd47cea783f4fd15cb",
"productIdAlpha": "stockx-us-air-jordan-alpha-1-university-blue",
"prefix": "media",
"filename": "65495f475493f73e4ea472ea.jpg",
"mimeType": "image/jpeg",
"filesize": 93448,
"width": 1400,
"height": 1000,
"sizes": {
"thumbnail": {
"width": 480,
"height": 320,
"mimeType": "image/webp",
"filesize": 14840,
"filename": "65495f475493f73e4ea472ea-480x320.webp",
"url": "https://cdn.retailed.app/media/65495f475493f73e4ea472ea-480x320.webp"
}
},
"createdAt": "2024-01-18T09:40:13.281Z",
"updatedAt": "2024-01-18T09:40:13.281Z",
"url": "https://cdn.retailed.app/media/65495f475493f73e4ea472ea.jpg"
}
],
"sizes": [
"7",
"7.5",
"8",
"8.5",
"9",
"9.5",
"10",
"10.5",
"11",
"11.5",
"12",
"12.5",
"13",
"14",
"15",
"16",
"17",
"18"
],
"sku": "392813-103",
"title": "Jordan Alpha 1 University Blue"
}
],
"totalDocs": 1,
"limit": 10,
"totalPages": 1,
"page": 1,
"pagingCounter": 1,
"hasPrevPage": false,
"hasNextPage": false,
"prevPage": null,
"nextPage": null
}
Get products from our database
curl --location --request GET 'https://app.retailed.io/api/v1/db/products?where[or][0][and][0][productId][equals]=stockx-us-air-jordan-alpha-1-university-blue' \
--header 'Content-Type: application/json' \
--header 'x-api-key: <token>' \
{
"docs": [
{
"id": "65495f475493f73e4ea472ea",
"productId": "stockx-us-air-jordan-alpha-1-university-blue",
"name": "stockx-us",
"country": "us",
"currency": "usd",
"currencySymbol": "$",
"url": "https://stockx.com/air-jordan-alpha-1-university-blue",
"domain": "stockx.com",
"urlSlug": "air-jordan-alpha-1-university-blue",
"errorCrawling": false,
"isNotFound": false,
"createdAt": "2023-11-06T21:48:55.897Z",
"updatedAt": "2024-01-18T09:40:13.428Z",
"lastCrawledAt": "2024-01-18T09:40:11.403Z",
"price": 125,
"urlId": "69b1ca16-a37f-4643-99b4-55d037e56ec9",
"variants": [
{
"id": "884500475069",
"products": [
"65495f475493f73e4ea472ea"
],
"barcodeFormats": "UPC-A 884500475069",
"model": "Jordan Alpha 1",
"sku": "392813-103",
"title": "Jordan Alpha 1 University Blue",
"category": "sneakers",
"brand": "Jordan",
"color": "White/Black-University Blue",
"size": "9",
"releaseDate": "2010-03-13T00:00:00.000Z",
"lastCrawledAt": "2024-01-18T09:40:11.555Z",
"errorCrawling": false,
"createdAt": "2023-11-17T00:46:04.652Z",
"updatedAt": "2024-01-18T09:40:11.660Z",
"description": null,
"reviews": []
},
{
"id": "884500475106",
"products": [
"65495f475493f73e4ea472ea"
],
"barcodeFormats": "UPC-A 884500475106",
"model": "Jordan Alpha 1",
"sku": "392813-103",
"title": "Jordan Alpha 1 University Blue",
"category": "sneakers",
"brand": "Jordan",
"color": "White/Black-University Blue",
"size": "11",
"releaseDate": "2010-03-13T00:00:00.000Z",
"lastCrawledAt": "2024-01-18T09:40:12.077Z",
"errorCrawling": false,
"createdAt": "2023-11-17T00:46:04.986Z",
"updatedAt": "2024-01-18T09:40:12.168Z",
"description": null,
"reviews": []
}
],
"description": null,
"images": [
{
"id": "65a8f1fd47cea783f4fd15cb",
"productIdAlpha": "stockx-us-air-jordan-alpha-1-university-blue",
"prefix": "media",
"filename": "65495f475493f73e4ea472ea.jpg",
"mimeType": "image/jpeg",
"filesize": 93448,
"width": 1400,
"height": 1000,
"sizes": {
"thumbnail": {
"width": 480,
"height": 320,
"mimeType": "image/webp",
"filesize": 14840,
"filename": "65495f475493f73e4ea472ea-480x320.webp",
"url": "https://cdn.retailed.app/media/65495f475493f73e4ea472ea-480x320.webp"
}
},
"createdAt": "2024-01-18T09:40:13.281Z",
"updatedAt": "2024-01-18T09:40:13.281Z",
"url": "https://cdn.retailed.app/media/65495f475493f73e4ea472ea.jpg"
}
],
"sizes": [
"7",
"7.5",
"8",
"8.5",
"9",
"9.5",
"10",
"10.5",
"11",
"11.5",
"12",
"12.5",
"13",
"14",
"15",
"16",
"17",
"18"
],
"sku": "392813-103",
"title": "Jordan Alpha 1 University Blue"
}
],
"totalDocs": 1,
"limit": 10,
"totalPages": 1,
"page": 1,
"pagingCounter": 1,
"hasPrevPage": false,
"hasNextPage": false,
"prevPage": null,
"nextPage": null
}
Operator | Description |
---|---|
equals | The value must be exactly equal. |
not_equals | The query will return all documents where the value is not equal. |
greater_than | For numeric or date-based fields. |
greater_than_equal | For numeric or date-based fields. |
less_than | For numeric or date-based fields. |
less_than_equal | For numeric or date-based fields. |
like | Case-insensitive string must be present. If string of words, all words must be present, in any order. |
contains | Must contain the value entered, case-insensitive. |
in | The value must be found within the provided comma-delimited list of values. |
not_in | The value must NOT be within the provided comma-delimited list of values. |
all | The value must contain all values provided in the comma-delimited list. |
exists | Only return documents where the value either exists (true) or does not exist (false). |
totalPages
in the response.GET https://app.retailed.io/api/v1/db/products?where[or][0][and][0][price][in]=85&where[or][1][and][0][price][in]=90&where[or][2][and][0][description][exists]=true&sort=-description
https://app.retailed.io/api/v1/db/products?sort=-createdAt
Show docs
websitesource-countrycode-productid
(e.g stockx-us-air-jordan-alpha-1-university-blue
).stockx-us
, zalando-fr
, etc.us
, fr
, etc.usd
, eur
, etc.$
, €
, etc.stockx.com
, zalando.fr
, etc.curl --location --request GET 'https://app.retailed.io/api/v1/db/products?where[or][0][and][0][productId][equals]=stockx-us-air-jordan-alpha-1-university-blue' \
--header 'Content-Type: application/json' \
--header 'x-api-key: <token>' \
{
"docs": [
{
"id": "65495f475493f73e4ea472ea",
"productId": "stockx-us-air-jordan-alpha-1-university-blue",
"name": "stockx-us",
"country": "us",
"currency": "usd",
"currencySymbol": "$",
"url": "https://stockx.com/air-jordan-alpha-1-university-blue",
"domain": "stockx.com",
"urlSlug": "air-jordan-alpha-1-university-blue",
"errorCrawling": false,
"isNotFound": false,
"createdAt": "2023-11-06T21:48:55.897Z",
"updatedAt": "2024-01-18T09:40:13.428Z",
"lastCrawledAt": "2024-01-18T09:40:11.403Z",
"price": 125,
"urlId": "69b1ca16-a37f-4643-99b4-55d037e56ec9",
"variants": [
{
"id": "884500475069",
"products": [
"65495f475493f73e4ea472ea"
],
"barcodeFormats": "UPC-A 884500475069",
"model": "Jordan Alpha 1",
"sku": "392813-103",
"title": "Jordan Alpha 1 University Blue",
"category": "sneakers",
"brand": "Jordan",
"color": "White/Black-University Blue",
"size": "9",
"releaseDate": "2010-03-13T00:00:00.000Z",
"lastCrawledAt": "2024-01-18T09:40:11.555Z",
"errorCrawling": false,
"createdAt": "2023-11-17T00:46:04.652Z",
"updatedAt": "2024-01-18T09:40:11.660Z",
"description": null,
"reviews": []
},
{
"id": "884500475106",
"products": [
"65495f475493f73e4ea472ea"
],
"barcodeFormats": "UPC-A 884500475106",
"model": "Jordan Alpha 1",
"sku": "392813-103",
"title": "Jordan Alpha 1 University Blue",
"category": "sneakers",
"brand": "Jordan",
"color": "White/Black-University Blue",
"size": "11",
"releaseDate": "2010-03-13T00:00:00.000Z",
"lastCrawledAt": "2024-01-18T09:40:12.077Z",
"errorCrawling": false,
"createdAt": "2023-11-17T00:46:04.986Z",
"updatedAt": "2024-01-18T09:40:12.168Z",
"description": null,
"reviews": []
}
],
"description": null,
"images": [
{
"id": "65a8f1fd47cea783f4fd15cb",
"productIdAlpha": "stockx-us-air-jordan-alpha-1-university-blue",
"prefix": "media",
"filename": "65495f475493f73e4ea472ea.jpg",
"mimeType": "image/jpeg",
"filesize": 93448,
"width": 1400,
"height": 1000,
"sizes": {
"thumbnail": {
"width": 480,
"height": 320,
"mimeType": "image/webp",
"filesize": 14840,
"filename": "65495f475493f73e4ea472ea-480x320.webp",
"url": "https://cdn.retailed.app/media/65495f475493f73e4ea472ea-480x320.webp"
}
},
"createdAt": "2024-01-18T09:40:13.281Z",
"updatedAt": "2024-01-18T09:40:13.281Z",
"url": "https://cdn.retailed.app/media/65495f475493f73e4ea472ea.jpg"
}
],
"sizes": [
"7",
"7.5",
"8",
"8.5",
"9",
"9.5",
"10",
"10.5",
"11",
"11.5",
"12",
"12.5",
"13",
"14",
"15",
"16",
"17",
"18"
],
"sku": "392813-103",
"title": "Jordan Alpha 1 University Blue"
}
],
"totalDocs": 1,
"limit": 10,
"totalPages": 1,
"page": 1,
"pagingCounter": 1,
"hasPrevPage": false,
"hasNextPage": false,
"prevPage": null,
"nextPage": null
}
Was this page helpful?