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": "9",
"boost": 1
}
}
}
]
}
},
"suggest": {
"text": ""
},
"_source": [
"search-result-data"
],
"sort": [
{
"integer-sort.category:9": {
"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": 9
}
}
|
{
"facets": {
"category": {},
"rating": {},
"label": {},
"farbe": {},
"material": {},
"brand": {},
"merchant_name": {}
},
"sort": {},
"pagination": {},
"products": [
{
"images": [
{
"fk_product_image_set": 232,
"id_product_image": 884,
"alt_text_small": "",
"product_image_key": "product_image_884",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S104010Z?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S104010Z",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 884,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 884
}
],
"id_product_labels": [],
"price": 620,
"abstract_name": "HP copy paper printing CHP210 DIN A4 80 g, white, 500 sheets\/pack.",
"id_product_abstract": 115,
"type": "product_abstract",
"add_to_cart_sku": "421322",
"prices": {
"DEFAULT": 620
},
"abstract_sku": "M21679",
"url": "\/en\/hp-kopierpapier-printing-chp210-din-a4-80g-weiss-500-bl-pack-M21679"
},
{
"images": [
{
"fk_product_image_set": 234,
"id_product_image": 886,
"alt_text_small": "",
"product_image_key": "product_image_886",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/H009197G?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/H009197G",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 886,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 886
}
],
"id_product_labels": [],
"price": 530,
"abstract_name": "HP copy paper Office CHP110 DIN A4 80 g, white, 500 sheets\/pack.",
"id_product_abstract": 116,
"type": "product_abstract",
"add_to_cart_sku": "421323",
"prices": {
"DEFAULT": 530
},
"abstract_sku": "M21680",
"url": "\/en\/hp-kopierpapier-office-chp110-din-a4-80g-weiss-500-bl-pack-M21680"
},
{
"images": [
{
"fk_product_image_set": 236,
"id_product_image": 888,
"alt_text_small": "",
"product_image_key": "product_image_888",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007741K?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007741K",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 888,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 888
},
{
"fk_product_image_set": 236,
"id_product_image": 890,
"alt_text_small": "",
"product_image_key": "product_image_890",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S104010Y?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S104010Y",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 890,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 890
}
],
"id_product_labels": [],
"price": 620,
"abstract_name": "HP copy paper Copy Paper CHP910 DIN A4 80 g, white, 500 sheets\/pack.",
"id_product_abstract": 117,
"type": "product_abstract",
"add_to_cart_sku": "421324",
"prices": {
"DEFAULT": 620
},
"abstract_sku": "M21681",
"url": "\/en\/hp-kopierpapier-copy-paper-chp910-din-a4-80g-weiss-500-bl-pack-M21681"
},
{
"images": [
{
"fk_product_image_set": 242,
"id_product_image": 900,
"alt_text_small": "",
"product_image_key": "product_image_900",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007754Y?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007754Y",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 900,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 900
}
],
"id_product_labels": [],
"price": 491,
"abstract_name": "Smart Print copy paper DIN 60 g, white, 500 sheets\/pack.",
"id_product_abstract": 124,
"type": "product_abstract",
"add_to_cart_sku": "421378",
"prices": {
"DEFAULT": 491
},
"abstract_sku": "M21703",
"url": "\/en\/smart-print-kopierpapier-din-60g-weiss-500-bl-pack-M21703"
},
{
"images": [
{
"fk_product_image_set": 246,
"id_product_image": 912,
"alt_text_small": "",
"product_image_key": "product_image_912",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007760Z?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007760Z",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 912,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 912
},
{
"fk_product_image_set": 246,
"id_product_image": 914,
"alt_text_small": "",
"product_image_key": "product_image_914",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007761B?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007761B",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 914,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 914
}
],
"id_product_labels": [],
"price": 1920,
"abstract_name": "Clairefontaine color laser paper DCP DIN 160 g, ivory, 250 sheets\/pack.",
"id_product_abstract": 126,
"type": "product_abstract",
"add_to_cart_sku": "655941",
"prices": {
"DEFAULT": 1920
},
"abstract_sku": "M21705",
"url": "\/en\/clairefontaine-farblaserpapier-dcp-din-160g-el-250-bl-pack-M21705"
},
{
"images": [
{
"fk_product_image_set": 306,
"id_product_image": 1062,
"alt_text_small": "",
"product_image_key": "product_image_1062",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S104009I?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S104009I",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 1062,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1062
}
],
"id_product_labels": [],
"price": 734,
"abstract_name": "Soennecken copy paper Star DIN 80 g, white, 500 sheets\/pack.",
"id_product_abstract": 156,
"type": "product_abstract",
"add_to_cart_sku": "422741",
"prices": {
"DEFAULT": 734
},
"abstract_sku": "M22410",
"url": "\/en\/soennecken-kopierpapier-star-din-80g-weiss-500-bl-pack-M22410"
},
{
"images": [
{
"fk_product_image_set": 308,
"id_product_image": 1064,
"alt_text_small": "",
"product_image_key": "product_image_1064",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003705B?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003705B",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 1064,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1064
}
],
"id_product_labels": [],
"price": 734,
"abstract_name": "Soennecken copy paper Brilliant 5800 DIN A4 80 g, white, 500 sheets\/pack.",
"id_product_abstract": 157,
"type": "product_abstract",
"add_to_cart_sku": "422743",
"prices": {
"DEFAULT": 734
},
"abstract_sku": "M22411",
"url": "\/en\/soennecken-kopierpapier-brillant-5800-din-a4-80g-weiss-500-bl-pack-M22411"
},
{
"images": [
{
"fk_product_image_set": 310,
"id_product_image": 1066,
"alt_text_small": "",
"product_image_key": "product_image_1066",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003002A?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003002A",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 1066,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1066
}
],
"id_product_labels": [],
"price": 1259,
"abstract_name": "Soennecken copy paper Special DIN 80 g, white, 500 sheets\/pack.",
"id_product_abstract": 158,
"type": "product_abstract",
"add_to_cart_sku": "422745",
"prices": {
"DEFAULT": 1259
},
"abstract_sku": "M22412",
"url": "\/en\/soennecken-kopierpapier-spezial-din-80g-weiss-500-bl-pack-M22412"
},
{
"images": [
{
"fk_product_image_set": 312,
"id_product_image": 1068,
"alt_text_small": "",
"product_image_key": "product_image_1068",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003003A?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003003A",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 1068,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1068
},
{
"fk_product_image_set": 312,
"id_product_image": 1070,
"alt_text_small": "",
"product_image_key": "product_image_1070",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007409E?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007409E",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 1070,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 1070
}
],
"id_product_labels": [],
"price": 576,
"abstract_name": "Soennecken copy paper Standard DIN 80 g, white, 500 sheets\/pack.",
"id_product_abstract": 159,
"type": "product_abstract",
"prices": {
"DEFAULT": 576
},
"abstract_sku": "M22432",
"url": "\/en\/soennecken-kopierpapier-standard-din-80g-weiss-500-bl-pack-M22432"
},
{
"images": [
{
"fk_product_image_set": 446,
"id_product_image": 1526,
"alt_text_small": "",
"product_image_key": "product_image_1526",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006300S?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006300S",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1526,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1526
}
],
"id_product_labels": [],
"price": 642,
"abstract_name": "Inapa Tecno copy paper pro laser 19608010001 DIN A4 500 sheets\/pack.",
"id_product_abstract": 234,
"type": "product_abstract",
"add_to_cart_sku": "425751",
"prices": {
"DEFAULT": 642
},
"abstract_sku": "M24143",
"url": "\/en\/inapa-tecno-kopierpapier-pro-laser-19608010001-din-a4-500-bl-pack-M24143"
}
],
"spellingSuggestion": null,
"categoryTreeFilter": {
"0": {},
"1": {},
"2": {},
"3": {},
"4": {},
"5": {}
}
}
|