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": "23",
"boost": 1
}
}
}
]
}
},
"suggest": {
"text": ""
},
"_source": [
"search-result-data"
],
"sort": [
{
"integer-sort.category:23": {
"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": 23
}
}
|
{
"facets": {
"category": {},
"rating": {},
"label": {},
"farbe": {},
"material": {},
"brand": {},
"merchant_name": {}
},
"sort": {},
"pagination": {},
"products": [
{
"images": [
{
"fk_product_image_set": 180,
"id_product_image": 728,
"alt_text_small": "",
"product_image_key": "product_image_728",
"updated_at": "2025-12-02 09:55:13.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007625S?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007625S",
"created_at": "2025-12-02 09:55:13.000000",
"id_product_image_set_to_product_image": 728,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 728
},
{
"fk_product_image_set": 180,
"id_product_image": 730,
"alt_text_small": "",
"product_image_key": "product_image_730",
"updated_at": "2025-12-02 09:55:13.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007625V?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007625V",
"created_at": "2025-12-02 09:55:13.000000",
"id_product_image_set_to_product_image": 730,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 730
}
],
"id_product_labels": [],
"price": 2596,
"abstract_name": "Verbatim USB stick OTG",
"id_product_abstract": 89,
"type": "product_abstract",
"add_to_cart_sku": "420573",
"prices": {
"DEFAULT": 2596
},
"abstract_sku": "M21103",
"url": "\/en\/verbatim-usb-stick-otg-M21103"
},
{
"images": [
{
"fk_product_image_set": 290,
"id_product_image": 992,
"alt_text_small": "",
"product_image_key": "product_image_992",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/V005518O?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/V005518O",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 992,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 992
}
],
"id_product_labels": [
2
],
"price": 3086,
"abstract_name": "Veloflex table flipchart 4132280 DIN A3 crosswise, 4 rings, 10 covers, black",
"id_product_abstract": 148,
"type": "product_abstract",
"add_to_cart_sku": "421540",
"prices": {
"DEFAULT": 3086
},
"abstract_sku": "M21779",
"url": "\/en\/veloflex-tischflipchart-4132280-din-a3-quer-4ringe-10huellen-schwarz-M21779"
},
{
"images": [
{
"fk_product_image_set": 454,
"id_product_image": 1534,
"alt_text_small": "",
"product_image_key": "product_image_1534",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007158W?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007158W",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1534,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1534
},
{
"fk_product_image_set": 454,
"id_product_image": 1536,
"alt_text_small": "",
"product_image_key": "product_image_1536",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007751L?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007751L",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1536,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 1536
}
],
"id_product_labels": [],
"price": 1836,
"abstract_name": "IDEAL Oil paper 9000631 for document shredder, 18 sheets\/pack.",
"id_product_abstract": 238,
"type": "product_abstract",
"add_to_cart_sku": "426531",
"prices": {
"DEFAULT": 1836
},
"abstract_sku": "M24563",
"url": "\/en\/ideal-oelpapier-9000631-fuer-aktenvernichter-18-bl-pack-M24563"
},
{
"images": [
{
"fk_product_image_set": 410,
"id_product_image": 1462,
"alt_text_small": "",
"product_image_key": "product_image_1462",
"updated_at": "2025-12-02 09:55:17.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006133I?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006133I",
"created_at": "2025-12-02 09:55:17.000000",
"id_product_image_set_to_product_image": 1462,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1462
}
],
"id_product_labels": [],
"price": 2123,
"abstract_name": "Brennenstuhl Kabelbox Vario-Line 1092200, 4-fold, 5-m cable, black",
"id_product_abstract": 216,
"type": "product_abstract",
"add_to_cart_sku": "425074",
"prices": {
"DEFAULT": 2123
},
"abstract_sku": "M23721",
"url": "\/en\/brennenstuhl-kabelbox-vario-line-1092200-4fach-5m-kabel-schwarz-M23721"
},
{
"images": [
{
"fk_product_image_set": 486,
"id_product_image": 1582,
"alt_text_small": "",
"product_image_key": "product_image_1582",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007780R?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007780R",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1582,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1582
}
],
"id_product_labels": [],
"price": 1998,
"abstract_name": "Brennenstuhl socket strip Premium-Line 1951160100, 6-fold, black",
"id_product_abstract": 254,
"type": "product_abstract",
"add_to_cart_sku": "425098",
"prices": {
"DEFAULT": 1998
},
"abstract_sku": "M26418",
"url": "\/en\/brennenstuhl-steckdosenleiste-premium-line-1951160100-6fach-sw-M26418"
},
{
"images": [
{
"fk_product_image_set": 416,
"id_product_image": 1470,
"alt_text_small": "",
"product_image_key": "product_image_1470",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041461Q?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041461Q",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1470,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1470
},
{
"fk_product_image_set": 416,
"id_product_image": 1472,
"alt_text_small": "",
"product_image_key": "product_image_1472",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041461R?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041461R",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1472,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 1472
}
],
"id_product_labels": [],
"price": 959,
"abstract_name": "Brennenstuhl extension cable 5 m",
"id_product_abstract": 219,
"type": "product_abstract",
"prices": {
"DEFAULT": 959
},
"abstract_sku": "M23724",
"url": "\/en\/brennenstuhl-verlaengerungskabel-5m-M23724"
},
{
"images": [
{
"fk_product_image_set": 428,
"id_product_image": 1492,
"alt_text_small": "",
"product_image_key": "product_image_1492",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041463U?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041463U",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1492,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1492
},
{
"fk_product_image_set": 428,
"id_product_image": 1494,
"alt_text_small": "",
"product_image_key": "product_image_1494",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041463T?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041463T",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1494,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 1494
}
],
"id_product_labels": [],
"price": 540,
"abstract_name": "Brennenstuhl socket strip, 3-fold",
"id_product_abstract": 225,
"type": "product_abstract",
"add_to_cart_sku": "425090",
"prices": {
"DEFAULT": 540
},
"abstract_sku": "M23731",
"url": "\/en\/brennenstuhl-steckdosenleiste-3fach-M23731"
},
{
"images": [
{
"fk_product_image_set": 164,
"id_product_image": 696,
"alt_text_small": "",
"product_image_key": "product_image_696",
"updated_at": "2025-12-02 09:55:13.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007369X?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007369X",
"created_at": "2025-12-02 09:55:13.000000",
"id_product_image_set_to_product_image": 696,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 696
}
],
"id_product_labels": [],
"price": 3340,
"abstract_name": "Verbatim storage card SDXC card 44024 64GB Class10",
"id_product_abstract": 81,
"type": "product_abstract",
"add_to_cart_sku": "420550",
"prices": {
"DEFAULT": 3340
},
"abstract_sku": "M21091",
"url": "\/en\/verbatim-speicherkarte-sdxc-card-44024-64gb-class10-M21091"
},
{
"images": [
{
"fk_product_image_set": 166,
"id_product_image": 698,
"alt_text_small": "",
"product_image_key": "product_image_698",
"updated_at": "2025-12-02 09:55:13.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007771M?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007771M",
"created_at": "2025-12-02 09:55:13.000000",
"id_product_image_set_to_product_image": 698,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 698
},
{
"fk_product_image_set": 166,
"id_product_image": 700,
"alt_text_small": "",
"product_image_key": "product_image_700",
"updated_at": "2025-12-02 09:55:13.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007771I?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007771I",
"created_at": "2025-12-02 09:55:13.000000",
"id_product_image_set_to_product_image": 700,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 700
},
{
"fk_product_image_set": 166,
"id_product_image": 702,
"alt_text_small": "",
"product_image_key": "product_image_702",
"updated_at": "2025-12-02 09:55:13.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007771O?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007771O",
"created_at": "2025-12-02 09:55:13.000000",
"id_product_image_set_to_product_image": 702,
"sort_order": 5,
"alt_text_large": "",
"fk_product_image": 702
}
],
"id_product_labels": [],
"price": 1128,
"abstract_name": "Verbatim storage microSDHC Card Class 10",
"id_product_abstract": 82,
"type": "product_abstract",
"add_to_cart_sku": "420551",
"prices": {
"DEFAULT": 1128
},
"abstract_sku": "M21092",
"url": "\/en\/verbatim-speicherkarte-micosdhc-class-10-M21092"
},
{
"images": [
{
"fk_product_image_set": 168,
"id_product_image": 704,
"alt_text_small": "",
"product_image_key": "product_image_704",
"updated_at": "2025-12-02 09:55:13.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007771K?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007771K",
"created_at": "2025-12-02 09:55:13.000000",
"id_product_image_set_to_product_image": 704,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 704
}
],
"id_product_labels": [],
"price": 3261,
"abstract_name": "Verbatim microSDXC storage card 44084 Class 10 64GB + adapter",
"id_product_abstract": 83,
"type": "product_abstract",
"add_to_cart_sku": "420554",
"prices": {
"DEFAULT": 3261
},
"abstract_sku": "M21093",
"url": "\/en\/verbatim-speicherkarte-micosdxc-44084-class-10-64gb-adapter-M21093"
},
{
"images": [
{
"fk_product_image_set": 170,
"id_product_image": 706,
"alt_text_small": "",
"product_image_key": "product_image_706",
"updated_at": "2025-12-02 09:55:13.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007771C?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007771C",
"created_at": "2025-12-02 09:55:13.000000",
"id_product_image_set_to_product_image": 706,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 706
},
{
"fk_product_image_set": 170,
"id_product_image": 708,
"alt_text_small": "",
"product_image_key": "product_image_708",
"updated_at": "2025-12-02 09:55:13.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007771B?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007771B",
"created_at": "2025-12-02 09:55:13.000000",
"id_product_image_set_to_product_image": 708,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 708
}
],
"id_product_labels": [],
"price": 12413,
"abstract_name": "Verbatim SSD hard disk 1.8 duty USB 3.0 black",
"id_product_abstract": 84,
"type": "product_abstract",
"add_to_cart_sku": "420555",
"prices": {
"DEFAULT": 12413
},
"abstract_sku": "M21094",
"url": "\/en\/verbatim-ssd-festplatte-1-8zoll-usb-3-0-schwarz-M21094"
},
{
"images": [
{
"fk_product_image_set": 184,
"id_product_image": 738,
"alt_text_small": "",
"product_image_key": "product_image_738",
"updated_at": "2025-12-02 09:55:13.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007771R?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007771R",
"created_at": "2025-12-02 09:55:13.000000",
"id_product_image_set_to_product_image": 738,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 738
}
],
"id_product_labels": [],
"price": 2370,
"abstract_name": "Verbatim card reader 97706 Card Reader Universal USB 3.0",
"id_product_abstract": 91,
"type": "product_abstract",
"add_to_cart_sku": "420575",
"prices": {
"DEFAULT": 2370
},
"abstract_sku": "M21105",
"url": "\/en\/verbatim-kartenleser-97706-card-reader-universal-usb-3-0-M21105"
}
],
"spellingSuggestion": null,
"categoryTreeFilter": {
"0": {},
"1": {},
"2": {},
"3": {},
"4": {},
"5": {}
}
}
|