Elasticsearch Search Requests
| Destination | Payload | Result |
|---|---|---|
| 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": "27",
"boost": 1
}
}
}
]
}
},
"suggest": {
"text": ""
},
"_source": [
"search-result-data"
],
"sort": [
{
"integer-sort.category:27": {
"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": 27
}
}
|
{
"facets": {
"category": {},
"rating": {},
"label": {},
"farbe": {},
"material": {},
"brand": {},
"merchant_name": {}
},
"sort": {},
"pagination": {},
"products": [
{
"images": [
{
"fk_product_image_set": 422,
"id_product_image": 1482,
"alt_text_small": "",
"product_image_key": "product_image_1482",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845F?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845F",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1482,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1482
},
{
"fk_product_image_set": 422,
"id_product_image": 1484,
"alt_text_small": "",
"product_image_key": "product_image_1484",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041614D?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041614D",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1484,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 1484
}
],
"id_product_labels": [],
"price": 2677,
"abstract_name": "Brennenstuhl socket strip Alu-Line 1391000016, 6-fold, black",
"id_product_abstract": 222,
"type": "product_abstract",
"add_to_cart_sku": "425084",
"prices": {
"DEFAULT": 2677
},
"abstract_sku": "M23727",
"url": "\/en\/brennenstuhl-steckdosenleiste-alu-line-1391000016-6fach-sw-M23727"
},
{
"images": [
{
"fk_product_image_set": 424,
"id_product_image": 1486,
"alt_text_small": "",
"product_image_key": "product_image_1486",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006668J?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006668J",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1486,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1486
}
],
"id_product_labels": [],
"price": 2575,
"abstract_name": "Brennenstuhl socket strip Eco-Line 1159750015, 6-fold, gray",
"id_product_abstract": 223,
"type": "product_abstract",
"add_to_cart_sku": "425087",
"prices": {
"DEFAULT": 2575
},
"abstract_sku": "M23729",
"url": "\/en\/brennenstuhl-steckdosenleiste-eco-line-1159750015-6fach-grau-M23729"
},
{
"images": [
{
"fk_product_image_set": 426,
"id_product_image": 1488,
"alt_text_small": "",
"product_image_key": "product_image_1488",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041463V?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041463V",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1488,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1488
},
{
"fk_product_image_set": 426,
"id_product_image": 1490,
"alt_text_small": "",
"product_image_key": "product_image_1490",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041463W?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041463W",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1490,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 1490
}
],
"id_product_labels": [],
"price": 473,
"abstract_name": "Brennenstuhl socket strip, 3-fold",
"id_product_abstract": 224,
"type": "product_abstract",
"add_to_cart_sku": "425088",
"prices": {
"DEFAULT": 473
},
"abstract_sku": "M23730",
"url": "\/en\/brennenstuhl-steckdosenleiste-3fach-M23730"
},
{
"images": [
{
"fk_product_image_set": 430,
"id_product_image": 1496,
"alt_text_small": "",
"product_image_key": "product_image_1496",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041463Y?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041463Y",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1496,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1496
},
{
"fk_product_image_set": 430,
"id_product_image": 1498,
"alt_text_small": "",
"product_image_key": "product_image_1498",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041463X?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041463X",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1498,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 1498
}
],
"id_product_labels": [],
"price": 812,
"abstract_name": "Brennenstuhl socket strip, 6-fold",
"id_product_abstract": 226,
"type": "product_abstract",
"add_to_cart_sku": "425093",
"prices": {
"DEFAULT": 812
},
"abstract_sku": "M23732",
"url": "\/en\/brennenstuhl-steckdosenleiste-6fach-M23732"
},
{
"images": [
{
"fk_product_image_set": 432,
"id_product_image": 1500,
"alt_text_small": "",
"product_image_key": "product_image_1500",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007314W?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007314W",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1500,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1500
}
],
"id_product_labels": [],
"price": 3299,
"abstract_name": "Hama card reader SuperSpeed 00039878 USB3.0, black",
"id_product_abstract": 227,
"type": "product_abstract",
"add_to_cart_sku": "425123",
"prices": {
"DEFAULT": 3299
},
"abstract_sku": "M23751",
"url": "\/en\/hama-kartenleser-superspeed-00039878-usb3-0-schwarz-M23751"
},
{
"images": [
{
"fk_product_image_set": 434,
"id_product_image": 1502,
"alt_text_small": "",
"product_image_key": "product_image_1502",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007021T?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007021T",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1502,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1502
},
{
"fk_product_image_set": 434,
"id_product_image": 1504,
"alt_text_small": "",
"product_image_key": "product_image_1504",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007058P?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007058P",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1504,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 1504
}
],
"id_product_labels": [],
"price": 2146,
"abstract_name": "Hama Optical Mouse Milano USB nano-receiver",
"id_product_abstract": 228,
"type": "product_abstract",
"add_to_cart_sku": "425150",
"prices": {
"DEFAULT": 2146
},
"abstract_sku": "M23764",
"url": "\/en\/hama-optical-mouse-milano-usb-nano-empfaenger-M23764"
},
{
"images": [
{
"fk_product_image_set": 440,
"id_product_image": 1518,
"alt_text_small": "",
"product_image_key": "product_image_1518",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006935C?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006935C",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1518,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1518
},
{
"fk_product_image_set": 440,
"id_product_image": 1520,
"alt_text_small": "",
"product_image_key": "product_image_1520",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007093M?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007093M",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1520,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 1520
}
],
"id_product_labels": [],
"price": 3050,
"abstract_name": "Hama laser mouse Mirano Wireless",
"id_product_abstract": 231,
"type": "product_abstract",
"add_to_cart_sku": "425152",
"prices": {
"DEFAULT": 3050
},
"abstract_sku": "M23771",
"url": "\/en\/hama-lasermaus-mirano-wireless-M23771"
},
{
"images": [
{
"fk_product_image_set": 458,
"id_product_image": 1540,
"alt_text_small": "",
"product_image_key": "product_image_1540",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007369L?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007369L",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1540,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1540
}
],
"id_product_labels": [],
"price": 819,
"abstract_name": "Cherry Optical Mouse GENTIX JM-0300-2 corded USB, black",
"id_product_abstract": 240,
"type": "product_abstract",
"add_to_cart_sku": "426582",
"prices": {
"DEFAULT": 819
},
"abstract_sku": "M24606",
"url": "\/en\/cherry-optical-mouse-gentix-jm-0300-2-corded-usb-schwarz-M24606"
},
{
"images": [
{
"fk_product_image_set": 460,
"id_product_image": 1542,
"alt_text_small": "",
"product_image_key": "product_image_1542",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007369J?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007369J",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1542,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1542
}
],
"id_product_labels": [],
"price": 8299,
"abstract_name": "Cherry keyboard mouse set B.UNLIMITED AES JD-0400DE-2, black",
"id_product_abstract": 241,
"type": "product_abstract",
"add_to_cart_sku": "426587",
"prices": {
"DEFAULT": 8299
},
"abstract_sku": "M24609",
"url": "\/en\/cherry-tastatur-maus-set-b-unlimited-aes-jd-0400de-2-schwarz-M24609"
},
{
"images": [
{
"fk_product_image_set": 466,
"id_product_image": 1548,
"alt_text_small": "",
"product_image_key": "product_image_1548",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007787B?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007787B",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1548,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1548
}
],
"id_product_labels": [],
"price": 925,
"abstract_name": "Cherry Optical Mouse GENTIX JM-0300-2 corded USB, white\/gray",
"id_product_abstract": 244,
"type": "product_abstract",
"add_to_cart_sku": "426591",
"prices": {
"DEFAULT": 925
},
"abstract_sku": "M24613",
"url": "\/en\/cherry-optical-mouse-gentix-jm-0300-2-corded-usb-weiss-grau-M24613"
},
{
"images": [
{
"fk_product_image_set": 480,
"id_product_image": 1574,
"alt_text_small": "",
"product_image_key": "product_image_1574",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845E?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845E",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1574,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1574
},
{
"fk_product_image_set": 480,
"id_product_image": 1576,
"alt_text_small": "",
"product_image_key": "product_image_1576",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041168L?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041168L",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1576,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 1576
}
],
"id_product_labels": [],
"price": 3456,
"abstract_name": "Brennenstuhl socket strip Secure-Tec 1159540376, 6-fold, anthracite",
"id_product_abstract": 251,
"type": "product_abstract",
"add_to_cart_sku": "425086",
"prices": {
"DEFAULT": 3456
},
"abstract_sku": "M26415",
"url": "\/en\/brennenstuhl-steckdosenleiste-secure-tec-1159540376-6fach-an-M26415"
},
{
"images": [
{
"fk_product_image_set": 482,
"id_product_image": 1578,
"alt_text_small": "",
"product_image_key": "product_image_1578",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007458Q?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007458Q",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1578,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1578
}
],
"id_product_labels": [],
"price": 4304,
"abstract_name": "Brennenstuhl socket strip SecureTec 1159490936, 8-fold, anthracite",
"id_product_abstract": 252,
"type": "product_abstract",
"add_to_cart_sku": "425096",
"prices": {
"DEFAULT": 4304
},
"abstract_sku": "M26416",
"url": "\/en\/brennenstuhl-steckdosenleiste-securetec-1159490936-8-fach-an-M26416"
}
],
"spellingSuggestion": null,
"categoryTreeFilter": {
"0": {},
"1": {},
"2": {},
"3": {},
"4": {},
"5": {}
}
}
|