| Http://search:9200 |
{
"query": {
"query": {
"bool": {
"must": [
{
"match_all": {}
},
{
"match": {
"type": "product_abstract"
}
},
{
"match": {
"store": "DE"
}
},
{
"match": {
"locale": "en_US"
}
},
{
"match": {
"is-active": true
}
},
{
"bool": {
"should": [
{
"range": {
"active-from": {
"lte": "now"
}
}
},
{
"bool": {
"must_not": [
{
"exists": {
"field": "active-from"
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"range": {
"active-to": {
"gte": "now"
}
}
},
{
"bool": {
"must_not": [
{
"exists": {
"field": "active-to"
}
}
]
}
}
]
}
}
],
"filter": [
{
"nested": {
"query": {
"term": {
"integer-facet.facet-name": {
"value": "price-DEFAULT-EUR-GROSS_MODE",
"boost": 1
}
}
},
"path": "integer-facet"
}
},
{
"term": {
"category.all-parents": {
"value": "29",
"boost": 1
}
}
}
]
}
},
"suggest": {
"text": ""
},
"_source": [
"search-result-data"
],
"sort": [
{
"integer-sort.category:29": {
"order": "ASC",
"mode": "min",
"unmapped_type": "integer"
}
}
],
"from": 12,
"size": 12,
"aggs": {
"category.all-parents.category": {
"terms": {
"field": "category.all-parents",
"size": 1000
}
},
"global-category": {
"global": {},
"aggs": {
"filter": {
"filter": {
"bool": {
"must": [
{
"match_all": {}
},
{
"match": {
"type": "product_abstract"
}
},
{
"match": {
"store": "DE"
}
},
{
"match": {
"locale": "en_US"
}
},
{
"match": {
"is-active": true
}
},
{
"bool": {
"should": [
{
"range": {
"active-from": {
"lte": "now"
}
}
},
{
"bool": {
"must_not": [
{
"exists": {
"field": "active-from"
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"range": {
"active-to": {
"gte": "now"
}
}
},
{
"bool": {
"must_not": [
{
"exists": {
"field": "active-to"
}
}
]
}
}
]
}
}
],
"filter": [
{
"nested": {
"query": {
"term": {
"integer-facet.facet-name": {
"value": "price-DEFAULT-EUR-GROSS_MODE",
"boost": 1
}
}
},
"path": "integer-facet"
}
}
]
}
},
"aggs": {
"category.all-parents.category": {
"terms": {
"field": "category.all-parents",
"size": 1000
}
}
}
}
}
},
"integer-facet": {
"nested": {
"path": "integer-facet"
},
"aggs": {
"integer-facet-name": {
"terms": {
"field": "integer-facet.facet-name",
"size": 10
},
"aggs": {
"integer-facet-stats": {
"stats": {
"field": "integer-facet.facet-value"
}
}
}
}
}
},
"string-facet": {
"nested": {
"path": "string-facet"
},
"aggs": {
"string-facet-name": {
"terms": {
"field": "string-facet.facet-name",
"size": 10
},
"aggs": {
"string-facet-value": {
"terms": {
"field": "string-facet.facet-value",
"size": 10
}
}
}
}
}
}
}
},
"parameters": {
"page": "2",
"category": 29
}
}
|
{
"facets": {
"category": {},
"rating": {},
"label": {},
"farbe": {},
"material": {},
"brand": {},
"merchant_name": {}
},
"sort": {},
"pagination": {},
"products": [
{
"images": [
{
"fk_product_image_set": 294,
"id_product_image": 1004,
"alt_text_small": "",
"product_image_key": "product_image_1004",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606R?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606R",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 1004,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1004
},
{
"fk_product_image_set": 294,
"id_product_image": 1006,
"alt_text_small": "",
"product_image_key": "product_image_1006",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007607A?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007607A",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 1006,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 1006
},
{
"fk_product_image_set": 294,
"id_product_image": 1008,
"alt_text_small": "",
"product_image_key": "product_image_1008",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606J?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606J",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 1008,
"sort_order": 5,
"alt_text_large": "",
"fk_product_image": 1008
},
{
"fk_product_image_set": 294,
"id_product_image": 1010,
"alt_text_small": "",
"product_image_key": "product_image_1010",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606Q?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606Q",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 1010,
"sort_order": 7,
"alt_text_large": "",
"fk_product_image": 1010
},
{
"fk_product_image_set": 294,
"id_product_image": 1012,
"alt_text_small": "",
"product_image_key": "product_image_1012",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606K?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606K",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 1012,
"sort_order": 9,
"alt_text_large": "",
"fk_product_image": 1012
},
{
"fk_product_image_set": 294,
"id_product_image": 1014,
"alt_text_small": "",
"product_image_key": "product_image_1014",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606M?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606M",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 1014,
"sort_order": 11,
"alt_text_large": "",
"fk_product_image": 1014
},
{
"fk_product_image_set": 294,
"id_product_image": 1016,
"alt_text_small": "",
"product_image_key": "product_image_1016",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606L?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606L",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 1016,
"sort_order": 13,
"alt_text_large": "",
"fk_product_image": 1016
},
{
"fk_product_image_set": 294,
"id_product_image": 1018,
"alt_text_small": "",
"product_image_key": "product_image_1018",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606O?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606O",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 1018,
"sort_order": 15,
"alt_text_large": "",
"fk_product_image": 1018
},
{
"fk_product_image_set": 294,
"id_product_image": 1020,
"alt_text_small": "",
"product_image_key": "product_image_1020",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606S?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606S",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 1020,
"sort_order": 17,
"alt_text_large": "",
"fk_product_image": 1020
},
{
"fk_product_image_set": 294,
"id_product_image": 1022,
"alt_text_small": "",
"product_image_key": "product_image_1022",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606X?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606X",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 1022,
"sort_order": 19,
"alt_text_large": "",
"fk_product_image": 1022
},
{
"fk_product_image_set": 294,
"id_product_image": 1024,
"alt_text_small": "",
"product_image_key": "product_image_1024",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606N?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606N",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 1024,
"sort_order": 21,
"alt_text_large": "",
"fk_product_image": 1024
},
{
"fk_product_image_set": 294,
"id_product_image": 1026,
"alt_text_small": "",
"product_image_key": "product_image_1026",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606P?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606P",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 1026,
"sort_order": 23,
"alt_text_large": "",
"fk_product_image": 1026
},
{
"fk_product_image_set": 294,
"id_product_image": 1028,
"alt_text_small": "",
"product_image_key": "product_image_1028",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606T?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606T",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 1028,
"sort_order": 25,
"alt_text_large": "",
"fk_product_image": 1028
},
{
"fk_product_image_set": 294,
"id_product_image": 1030,
"alt_text_small": "",
"product_image_key": "product_image_1030",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606U?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606U",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 1030,
"sort_order": 27,
"alt_text_large": "",
"fk_product_image": 1030
}
],
"id_product_labels": [],
"price": 1049,
"abstract_name": "USB stick clip\/me 4GB 2.0",
"id_product_abstract": 150,
"type": "product_abstract",
"add_to_cart_sku": "422524",
"prices": {
"DEFAULT": 1049
},
"abstract_sku": "M22230",
"url": "\/en\/usb-stick-clip-me-4gb-2-0-M22230"
},
{
"images": [
{
"fk_product_image_set": 296,
"id_product_image": 1032,
"alt_text_small": "",
"product_image_key": "product_image_1032",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007665P?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007665P",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 1032,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1032
},
{
"fk_product_image_set": 296,
"id_product_image": 1034,
"alt_text_small": "",
"product_image_key": "product_image_1034",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007665Q?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007665Q",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 1034,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 1034
}
],
"id_product_labels": [],
"price": 775,
"abstract_name": "Xlyne USB stick OTG silver",
"id_product_abstract": 151,
"type": "product_abstract",
"add_to_cart_sku": "422528",
"prices": {
"DEFAULT": 775
},
"abstract_sku": "M22232",
"url": "\/en\/xlyne-usb-stick-otg-silber-M22232"
},
{
"images": [
{
"fk_product_image_set": 176,
"id_product_image": 722,
"alt_text_small": "",
"product_image_key": "product_image_722",
"updated_at": "2025-12-02 09:55:13.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007049U?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007049U",
"created_at": "2025-12-02 09:55:13.000000",
"id_product_image_set_to_product_image": 722,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 722
},
{
"fk_product_image_set": 176,
"id_product_image": 724,
"alt_text_small": "",
"product_image_key": "product_image_724",
"updated_at": "2025-12-02 09:55:13.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007050D?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007050D",
"created_at": "2025-12-02 09:55:13.000000",
"id_product_image_set_to_product_image": 724,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 724
}
],
"id_product_labels": [
1,
2
],
"price": 1579,
"abstract_name": "Verbatim USB stick Store n Go V3 49173 32GB USB3.0 gray",
"id_product_abstract": 87,
"type": "product_abstract",
"add_to_cart_sku": "420566",
"prices": {
"DEFAULT": 1579
},
"abstract_sku": "M21100",
"url": "\/en\/verbatim-usb-stick-store-n-go-v3-49173-32gb-usb3-0-grau-M21100"
},
{
"images": [
{
"fk_product_image_set": 162,
"id_product_image": 686,
"alt_text_small": "",
"product_image_key": "product_image_686",
"updated_at": "2025-12-02 09:55:13.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006852Z?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006852Z",
"created_at": "2025-12-02 09:55:13.000000",
"id_product_image_set_to_product_image": 686,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 686
},
{
"fk_product_image_set": 162,
"id_product_image": 688,
"alt_text_small": "",
"product_image_key": "product_image_688",
"updated_at": "2025-12-02 09:55:13.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007836K?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007836K",
"created_at": "2025-12-02 09:55:13.000000",
"id_product_image_set_to_product_image": 688,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 688
},
{
"fk_product_image_set": 162,
"id_product_image": 690,
"alt_text_small": "",
"product_image_key": "product_image_690",
"updated_at": "2025-12-02 09:55:13.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006852Y?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006852Y",
"created_at": "2025-12-02 09:55:13.000000",
"id_product_image_set_to_product_image": 690,
"sort_order": 5,
"alt_text_large": "",
"fk_product_image": 690
},
{
"fk_product_image_set": 162,
"id_product_image": 692,
"alt_text_small": "",
"product_image_key": "product_image_692",
"updated_at": "2025-12-02 09:55:13.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006811L?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006811L",
"created_at": "2025-12-02 09:55:13.000000",
"id_product_image_set_to_product_image": 692,
"sort_order": 7,
"alt_text_large": "",
"fk_product_image": 692
},
{
"fk_product_image_set": 162,
"id_product_image": 694,
"alt_text_small": "",
"product_image_key": "product_image_694",
"updated_at": "2025-12-02 09:55:13.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007836J?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007836J",
"created_at": "2025-12-02 09:55:13.000000",
"id_product_image_set_to_product_image": 694,
"sort_order": 9,
"alt_text_large": "",
"fk_product_image": 694
}
],
"id_product_labels": [],
"price": 2170,
"abstract_name": "Verbatim storage card SDHC Card Class 10",
"id_product_abstract": 80,
"type": "product_abstract",
"add_to_cart_sku": "420549",
"prices": {
"DEFAULT": 2170
},
"abstract_sku": "M21090",
"url": "\/en\/verbatim-speicherkarte-sdhc-card-class-10-M21090"
},
{
"images": [
{
"fk_product_image_set": 178,
"id_product_image": 726,
"alt_text_small": "",
"product_image_key": "product_image_726",
"updated_at": "2025-12-02 09:55:13.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007050E?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007050E",
"created_at": "2025-12-02 09:55:13.000000",
"id_product_image_set_to_product_image": 726,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 726
}
],
"id_product_labels": [],
"price": 2413,
"abstract_name": "Verbatim USB stick Store n Go V3 49174 64GB USB3.0 black\/gray",
"id_product_abstract": 88,
"type": "product_abstract",
"add_to_cart_sku": "420567",
"prices": {
"DEFAULT": 2413
},
"abstract_sku": "M21101",
"url": "\/en\/verbatim-usb-stick-storen-go-v3-49174-64gb-usb3-0-schwarz-grau-M21101"
},
{
"images": [
{
"fk_product_image_set": 298,
"id_product_image": 1036,
"alt_text_small": "",
"product_image_key": "product_image_1036",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007118K?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007118K",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 1036,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1036
}
],
"id_product_labels": [],
"price": 891,
"abstract_name": "Soennecken USB stick 2.0 black\/silver",
"id_product_abstract": 152,
"type": "product_abstract",
"add_to_cart_sku": "422573",
"prices": {
"DEFAULT": 891
},
"abstract_sku": "M22269",
"url": "\/en\/soennecken-usb-stick-2-0-schwarz-silber-M22269"
}
],
"spellingSuggestion": null,
"categoryTreeFilter": {
"0": {},
"1": {},
"2": {},
"3": {},
"4": {},
"5": {}
}
}
|