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": "28",
"boost": 1
}
}
}
]
}
},
"suggest": {
"text": ""
},
"_source": [
"search-result-data"
],
"sort": [
{
"integer-sort.category:28": {
"order": "ASC",
"mode": "min",
"unmapped_type": "integer"
}
}
],
"from": 0,
"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": {
"category": 28
}
}
|
{
"facets": {
"category": {},
"rating": {},
"label": {},
"farbe": {},
"material": {},
"brand": {},
"merchant_name": {}
},
"sort": {},
"pagination": {},
"products": [
{
"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": 436,
"id_product_image": 1506,
"alt_text_small": "",
"product_image_key": "product_image_1506",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006781V?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006781V",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1506,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1506
},
{
"fk_product_image_set": 436,
"id_product_image": 1508,
"alt_text_small": "",
"product_image_key": "product_image_1508",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006781W?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006781W",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1508,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 1508
},
{
"fk_product_image_set": 436,
"id_product_image": 1510,
"alt_text_small": "",
"product_image_key": "product_image_1510",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007298L?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007298L",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1510,
"sort_order": 5,
"alt_text_large": "",
"fk_product_image": 1510
}
],
"id_product_labels": [],
"price": 1129,
"abstract_name": "Hama Optical Mouse USB 800dpi",
"id_product_abstract": 229,
"type": "product_abstract",
"add_to_cart_sku": "425140",
"prices": {
"DEFAULT": 1129
},
"abstract_sku": "M23766",
"url": "\/en\/hama-optical-mouse-usb-800dpi-M23766"
},
{
"images": [
{
"fk_product_image_set": 438,
"id_product_image": 1512,
"alt_text_small": "",
"product_image_key": "product_image_1512",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006781M?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006781M",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1512,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1512
},
{
"fk_product_image_set": 438,
"id_product_image": 1514,
"alt_text_small": "",
"product_image_key": "product_image_1514",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006781R?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006781R",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1514,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 1514
},
{
"fk_product_image_set": 438,
"id_product_image": 1516,
"alt_text_small": "",
"product_image_key": "product_image_1516",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006781P?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006781P",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1516,
"sort_order": 5,
"alt_text_large": "",
"fk_product_image": 1516
}
],
"id_product_labels": [],
"price": 2033,
"abstract_name": "Hama Optical Mouse M2150 USB 800\/1,600dpi",
"id_product_abstract": 230,
"type": "product_abstract",
"add_to_cart_sku": "425149",
"prices": {
"DEFAULT": 2033
},
"abstract_sku": "M23770",
"url": "\/en\/hama-optical-mouse-m2150-usb-800-1-600dpi-M23770"
},
{
"images": [
{
"fk_product_image_set": 462,
"id_product_image": 1544,
"alt_text_small": "",
"product_image_key": "product_image_1544",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007631W?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007631W",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1544,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1544
}
],
"id_product_labels": [],
"price": 2930,
"abstract_name": "Cherry keyboard mouse set DW 3000 JD-0700DE-2, black",
"id_product_abstract": 242,
"type": "product_abstract",
"add_to_cart_sku": "426588",
"prices": {
"DEFAULT": 2930
},
"abstract_sku": "M24610",
"url": "\/en\/cherry-tastatur-maus-set-dw-3000-jd-0700de-2-schwarz-M24610"
},
{
"images": [
{
"fk_product_image_set": 464,
"id_product_image": 1546,
"alt_text_small": "",
"product_image_key": "product_image_1546",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007659S?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007659S",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1546,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1546
}
],
"id_product_labels": [],
"price": 1615,
"abstract_name": "Cherry Optical Mouse MW2400 JW-0700-2, cordless USB 3 buttons, black",
"id_product_abstract": 243,
"type": "product_abstract",
"add_to_cart_sku": "426590",
"prices": {
"DEFAULT": 1615
},
"abstract_sku": "M24612",
"url": "\/en\/cherry-optical-mouse-mw2400-jw-0700-2-cordless-usb-3tasten-sw-M24612"
},
{
"images": [
{
"fk_product_image_set": 474,
"id_product_image": 1566,
"alt_text_small": "",
"product_image_key": "product_image_1566",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006205A?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006205A",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1566,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1566
},
{
"fk_product_image_set": 474,
"id_product_image": 1568,
"alt_text_small": "",
"product_image_key": "product_image_1568",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006241C?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006241C",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1568,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 1568
}
],
"id_product_labels": [],
"price": 1324,
"abstract_name": "Logitech Optical Mouse M100 USB 1,000dpi",
"id_product_abstract": 248,
"type": "product_abstract",
"add_to_cart_sku": "427913",
"prices": {
"DEFAULT": 1324
},
"abstract_sku": "M25598",
"url": "\/en\/logitech-optical-mouse-m100-usb-1-000dpi-M25598"
},
{
"images": [
{
"fk_product_image_set": 476,
"id_product_image": 1570,
"alt_text_small": "",
"product_image_key": "product_image_1570",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007372D?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007372D",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1570,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1570
}
],
"id_product_labels": [],
"price": 2447,
"abstract_name": "Logitech keyboard-mouse set MK120 920-002540, corded, black",
"id_product_abstract": 249,
"type": "product_abstract",
"add_to_cart_sku": "427914",
"prices": {
"DEFAULT": 2447
},
"abstract_sku": "M25599",
"url": "\/en\/logitech-tastatur-maus-set-mk120-920-002540-corded-schwarz-M25599"
},
{
"images": [
{
"fk_product_image_set": 456,
"id_product_image": 1538,
"alt_text_small": "",
"product_image_key": "product_image_1538",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007387M?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007387M",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1538,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1538
}
],
"id_product_labels": [
4,
5
],
"price": 4196,
"abstract_name": "Cherry keyboard Strait JK-0300DE metal-look, corded, USB, silver",
"rating": 4,
"id_product_abstract": 239,
"review_count": 3,
"type": "product_abstract",
"add_to_cart_sku": "426581",
"prices": {
"DEFAULT": 4196,
"ORIGINAL": 4662
},
"abstract_sku": "M24605",
"url": "\/en\/cherry-tastatur-strait-jk-0300de-metall-look-schnurgebunden-usb-si-M24605"
}
],
"spellingSuggestion": null,
"categoryTreeFilter": {
"0": {},
"1": {},
"2": {},
"3": {},
"4": {},
"5": {}
}
}
|