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": "5",
"boost": 1
}
}
}
]
}
},
"suggest": {
"text": ""
},
"_source": [
"search-result-data"
],
"sort": [
{
"integer-sort.category:5": {
"order": "ASC",
"mode": "min",
"unmapped_type": "integer"
}
}
],
"from": 24,
"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": "3",
"category": 5
}
}
|
{
"facets": {
"category": {},
"rating": {},
"label": {},
"farbe": {},
"material": {},
"brand": {},
"merchant_name": {}
},
"sort": {},
"pagination": {},
"products": [
{
"images": [
{
"fk_product_image_set": 396,
"id_product_image": 1434,
"alt_text_small": "",
"product_image_key": "product_image_1434",
"updated_at": "2025-12-02 09:55:17.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007709R?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007709R",
"created_at": "2025-12-02 09:55:17.000000",
"id_product_image_set_to_product_image": 1434,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1434
},
{
"fk_product_image_set": 396,
"id_product_image": 1436,
"alt_text_small": "",
"product_image_key": "product_image_1436",
"updated_at": "2025-12-02 09:55:17.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/E005991R?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/E005991R",
"created_at": "2025-12-02 09:55:17.000000",
"id_product_image_set_to_product_image": 1436,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 1436
}
],
"id_product_labels": [],
"price": 337,
"abstract_name": "edding paint marker 750 4-750053 2-4 mm round tip, permanent, gold",
"id_product_abstract": 209,
"type": "product_abstract",
"add_to_cart_sku": "424551",
"prices": {
"DEFAULT": 337
},
"abstract_sku": "M23488",
"url": "\/en\/edding-lackmarker-750-4-750053-2-4mm-rundspitze-permanent-gold-M23488"
},
{
"images": [
{
"fk_product_image_set": 824,
"id_product_image": 3198,
"alt_text_small": "",
"product_image_key": "product_image_3198",
"updated_at": "2025-12-02 09:55:28.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007410V?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007410V",
"created_at": "2025-12-02 09:55:28.000000",
"id_product_image_set_to_product_image": 3198,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 3198
}
],
"id_product_labels": [
4,
5
],
"price": 103,
"abstract_name": "Soennecken permanent marker 4 mm round tip",
"id_product_abstract": 163,
"type": "product_abstract",
"add_to_cart_sku": "423172",
"prices": {
"DEFAULT": 103,
"ORIGINAL": 114
},
"abstract_sku": "M22660",
"url": "\/en\/soennecken-permanentmarker-4mm-rundspitze-M22660"
},
{
"images": [
{
"fk_product_image_set": 826,
"id_product_image": 3200,
"alt_text_small": "",
"product_image_key": "product_image_3200",
"updated_at": "2025-12-02 09:55:28.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007410S?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007410S",
"created_at": "2025-12-02 09:55:28.000000",
"id_product_image_set_to_product_image": 3200,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 3200
}
],
"id_product_labels": [
4
],
"price": 103,
"abstract_name": "Soennecken permanent marker 4 mm round tip",
"id_product_abstract": 164,
"type": "product_abstract",
"add_to_cart_sku": "423173",
"prices": {
"DEFAULT": 103
},
"abstract_sku": "M22661",
"url": "\/en\/soennecken-permanentmarker-4mm-rundspitze-M22661"
},
{
"images": [
{
"fk_product_image_set": 828,
"id_product_image": 3202,
"alt_text_small": "",
"product_image_key": "product_image_3202",
"updated_at": "2025-12-02 09:55:28.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007410W?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007410W",
"created_at": "2025-12-02 09:55:28.000000",
"id_product_image_set_to_product_image": 3202,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 3202
}
],
"id_product_labels": [
4
],
"price": 103,
"abstract_name": "Soennecken permanent marker 4 mm round tip",
"id_product_abstract": 165,
"type": "product_abstract",
"add_to_cart_sku": "423174",
"prices": {
"DEFAULT": 103
},
"abstract_sku": "M22662",
"url": "\/en\/soennecken-permanentmarker-4mm-rundspitze-M22662"
},
{
"images": [
{
"fk_product_image_set": 830,
"id_product_image": 3204,
"alt_text_small": "",
"product_image_key": "product_image_3204",
"updated_at": "2025-12-02 09:55:28.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007410Q?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007410Q",
"created_at": "2025-12-02 09:55:28.000000",
"id_product_image_set_to_product_image": 3204,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 3204
}
],
"id_product_labels": [
4,
5
],
"price": 103,
"abstract_name": "Soennecken permanent marker 4 mm round tip",
"rating": 3.5,
"id_product_abstract": 166,
"review_count": 4,
"type": "product_abstract",
"add_to_cart_sku": "423175",
"prices": {
"DEFAULT": 103,
"ORIGINAL": 114
},
"abstract_sku": "M22663",
"url": "\/en\/soennecken-permanentmarker-4mm-rundspitze-M22663"
}
],
"spellingSuggestion": null,
"categoryTreeFilter": {
"0": {},
"1": {},
"2": {},
"3": {},
"4": {},
"5": {}
}
}
|