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": "15",
"boost": 1
}
}
}
]
}
},
"suggest": {
"text": ""
},
"_source": [
"search-result-data"
],
"sort": [
{
"integer-sort.category:15": {
"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": 15
}
}
|
{
"facets": {
"category": {},
"rating": {},
"label": {},
"farbe": {},
"material": {},
"brand": {},
"merchant_name": {}
},
"sort": {},
"pagination": {},
"products": [
{
"images": [
{
"fk_product_image_set": 576,
"id_product_image": 1844,
"alt_text_small": "",
"product_image_key": "product_image_1844",
"updated_at": "2025-12-02 09:55:20.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/Clubsessel_100907?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/Clubsessel_100907",
"created_at": "2025-12-02 09:55:20.000000",
"id_product_image_set_to_product_image": 1844,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1844
},
{
"fk_product_image_set": 576,
"id_product_image": 1846,
"alt_text_small": "",
"product_image_key": "product_image_1846",
"updated_at": "2025-12-02 09:55:20.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00034527-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00034527-01",
"created_at": "2025-12-02 09:55:20.000000",
"id_product_image_set_to_product_image": 1846,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 1846
}
],
"id_product_labels": [
5
],
"price": 22750,
"abstract_name": "Club chair - Leather covering",
"id_product_abstract": 301,
"type": "product_abstract",
"add_to_cart_sku": "100907",
"prices": {
"DEFAULT": 22750,
"ORIGINAL": 25277
},
"abstract_sku": "M53238",
"url": "\/en\/clubsessel-bezug-aus-leder-M53238"
},
{
"images": [
{
"fk_product_image_set": 90,
"id_product_image": 300,
"alt_text_small": "",
"product_image_key": "product_image_300",
"updated_at": "2025-12-02 09:55:10.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00034527-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00034527-01",
"created_at": "2025-12-02 09:55:10.000000",
"id_product_image_set_to_product_image": 300,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 300
},
{
"fk_product_image_set": 90,
"id_product_image": 302,
"alt_text_small": "",
"product_image_key": "product_image_302",
"updated_at": "2025-12-02 09:55:10.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/G00034527F-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/G00034527F-01",
"created_at": "2025-12-02 09:55:10.000000",
"id_product_image_set_to_product_image": 302,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 302
}
],
"id_product_labels": [
5
],
"price": 20057,
"abstract_name": "Club chair - Softex covering",
"id_product_abstract": 43,
"type": "product_abstract",
"add_to_cart_sku": "101172",
"prices": {
"DEFAULT": 20057,
"ORIGINAL": 22285
},
"abstract_sku": "M1028038",
"url": "\/en\/clubsessel-bezug-aus-softex-M1028038"
},
{
"images": [
{
"fk_product_image_set": 700,
"id_product_image": 2562,
"alt_text_small": "",
"product_image_key": "product_image_2562",
"updated_at": "2025-12-02 09:55:24.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00034075F-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00034075F-01",
"created_at": "2025-12-02 09:55:24.000000",
"id_product_image_set_to_product_image": 2562,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 2562
},
{
"fk_product_image_set": 700,
"id_product_image": 2564,
"alt_text_small": "",
"product_image_key": "product_image_2564",
"updated_at": "2025-12-02 09:55:24.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00032824-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00032824-01",
"created_at": "2025-12-02 09:55:24.000000",
"id_product_image_set_to_product_image": 2564,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 2564
}
],
"id_product_labels": [],
"price": 21089,
"abstract_name": "Club chair - HxWxD 850 x 575 x 530 mm",
"id_product_abstract": 363,
"type": "product_abstract",
"add_to_cart_sku": "103296",
"prices": {
"DEFAULT": 21089
},
"abstract_sku": "M74815",
"url": "\/en\/clubsessel-eckig-hxbxt-850-x-575-x-530-mm-M74815"
},
{
"images": [
{
"fk_product_image_set": 132,
"id_product_image": 510,
"alt_text_small": "",
"product_image_key": "product_image_510",
"updated_at": "2025-12-02 09:55:11.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/673327_2_EstucadoPolsterstuhl?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/673327_2_EstucadoPolsterstuhl",
"created_at": "2025-12-02 09:55:11.000000",
"id_product_image_set_to_product_image": 510,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 510
}
],
"id_product_labels": [],
"price": 19102,
"abstract_name": "Estucado upholstered chair with armrests, leader, white",
"id_product_abstract": 64,
"type": "product_abstract",
"add_to_cart_sku": "673327",
"prices": {
"DEFAULT": 19102
},
"abstract_sku": "M111",
"url": "\/en\/estucado-polsterstuhl-mit-armlehnen-leder-weiss-M111"
}
],
"spellingSuggestion": null,
"categoryTreeFilter": {
"0": {},
"1": {},
"2": {},
"3": {},
"4": {},
"5": {}
}
}
|