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": "11",
"boost": 1
}
}
}
]
}
},
"suggest": {
"text": ""
},
"_source": [
"search-result-data"
],
"sort": [
{
"integer-sort.category:11": {
"order": "ASC",
"mode": "min",
"unmapped_type": "integer"
}
}
],
"from": 168,
"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": "15",
"category": 11
}
}
|
{
"facets": {
"category": {},
"rating": {},
"label": {},
"farbe": {},
"material": {},
"brand": {},
"merchant_name": {}
},
"sort": {},
"pagination": {},
"products": [
{
"images": [
{
"fk_product_image_set": 682,
"id_product_image": 2452,
"alt_text_small": "",
"product_image_key": "product_image_2452",
"updated_at": "2025-12-02 09:55:23.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610384FF-02?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610384FF-02",
"created_at": "2025-12-02 09:55:23.000000",
"id_product_image_set_to_product_image": 2452,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 2452
},
{
"fk_product_image_set": 682,
"id_product_image": 2454,
"alt_text_small": "",
"product_image_key": "product_image_2454",
"updated_at": "2025-12-02 09:55:23.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610385FF-02?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610385FF-02",
"created_at": "2025-12-02 09:55:23.000000",
"id_product_image_set_to_product_image": 2454,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 2454
},
{
"fk_product_image_set": 682,
"id_product_image": 2456,
"alt_text_small": "",
"product_image_key": "product_image_2456",
"updated_at": "2025-12-02 09:55:23.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610387II-02?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610387II-02",
"created_at": "2025-12-02 09:55:23.000000",
"id_product_image_set_to_product_image": 2456,
"sort_order": 5,
"alt_text_large": "",
"fk_product_image": 2456
},
{
"fk_product_image_set": 682,
"id_product_image": 2458,
"alt_text_small": "",
"product_image_key": "product_image_2458",
"updated_at": "2025-12-02 09:55:23.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610387II-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610387II-01",
"created_at": "2025-12-02 09:55:23.000000",
"id_product_image_set_to_product_image": 2458,
"sort_order": 7,
"alt_text_large": "",
"fk_product_image": 2458
},
{
"fk_product_image_set": 682,
"id_product_image": 2460,
"alt_text_small": "",
"product_image_key": "product_image_2460",
"updated_at": "2025-12-02 09:55:23.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00034271-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00034271-01",
"created_at": "2025-12-02 09:55:23.000000",
"id_product_image_set_to_product_image": 2460,
"sort_order": 9,
"alt_text_large": "",
"fk_product_image": 2460
},
{
"fk_product_image_set": 682,
"id_product_image": 2462,
"alt_text_small": "",
"product_image_key": "product_image_2462",
"updated_at": "2025-12-02 09:55:23.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK94886-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK94886-01",
"created_at": "2025-12-02 09:55:23.000000",
"id_product_image_set_to_product_image": 2462,
"sort_order": 11,
"alt_text_large": "",
"fk_product_image": 2462
}
],
"id_product_labels": [],
"price": 59252,
"abstract_name": "Hammerbacher UPLINER standing desk, electrically height-adjustable - 725 - 1185 mm, WxD 1200 x 800 mm",
"id_product_abstract": 354,
"type": "product_abstract",
"add_to_cart_sku": "103889",
"prices": {
"DEFAULT": 59252
},
"abstract_sku": "M72937",
"url": "\/en\/upliner-stehschreibtisch-elektrisch-hoehenverstellbar-725-1185-mm-bxt-1200-x-800-mm-M72937"
},
{
"images": [
{
"fk_product_image_set": 686,
"id_product_image": 2476,
"alt_text_small": "",
"product_image_key": "product_image_2476",
"updated_at": "2025-12-02 09:55:24.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610388FF-02?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610388FF-02",
"created_at": "2025-12-02 09:55:24.000000",
"id_product_image_set_to_product_image": 2476,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 2476
},
{
"fk_product_image_set": 686,
"id_product_image": 2478,
"alt_text_small": "",
"product_image_key": "product_image_2478",
"updated_at": "2025-12-02 09:55:24.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610389FF-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610389FF-01",
"created_at": "2025-12-02 09:55:24.000000",
"id_product_image_set_to_product_image": 2478,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 2478
},
{
"fk_product_image_set": 686,
"id_product_image": 2480,
"alt_text_small": "",
"product_image_key": "product_image_2480",
"updated_at": "2025-12-02 09:55:24.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610387II-02?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610387II-02",
"created_at": "2025-12-02 09:55:24.000000",
"id_product_image_set_to_product_image": 2480,
"sort_order": 5,
"alt_text_large": "",
"fk_product_image": 2480
},
{
"fk_product_image_set": 686,
"id_product_image": 2482,
"alt_text_small": "",
"product_image_key": "product_image_2482",
"updated_at": "2025-12-02 09:55:24.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610387II-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610387II-01",
"created_at": "2025-12-02 09:55:24.000000",
"id_product_image_set_to_product_image": 2482,
"sort_order": 7,
"alt_text_large": "",
"fk_product_image": 2482
},
{
"fk_product_image_set": 686,
"id_product_image": 2484,
"alt_text_small": "",
"product_image_key": "product_image_2484",
"updated_at": "2025-12-02 09:55:24.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00034271-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00034271-01",
"created_at": "2025-12-02 09:55:24.000000",
"id_product_image_set_to_product_image": 2484,
"sort_order": 9,
"alt_text_large": "",
"fk_product_image": 2484
},
{
"fk_product_image_set": 686,
"id_product_image": 2486,
"alt_text_small": "",
"product_image_key": "product_image_2486",
"updated_at": "2025-12-02 09:55:24.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK94886-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK94886-01",
"created_at": "2025-12-02 09:55:24.000000",
"id_product_image_set_to_product_image": 2486,
"sort_order": 11,
"alt_text_large": "",
"fk_product_image": 2486
}
],
"id_product_labels": [],
"price": 63939,
"abstract_name": "Hammerbacher UPLINER standing desk, electrically height-adjustable - 725 - 1185 mm, WxD 1800 x 800 mm",
"id_product_abstract": 356,
"type": "product_abstract",
"add_to_cart_sku": "575056",
"prices": {
"DEFAULT": 63939
},
"abstract_sku": "M72939",
"url": "\/en\/upliner-stehschreibtisch-elektrisch-hoehenverstellbar-725-1185-mm-bxt-1800-x-800-mm-M72939"
},
{
"images": [
{
"fk_product_image_set": 692,
"id_product_image": 2508,
"alt_text_small": "",
"product_image_key": "product_image_2508",
"updated_at": "2025-12-02 09:55:24.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610394FF-02?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610394FF-02",
"created_at": "2025-12-02 09:55:24.000000",
"id_product_image_set_to_product_image": 2508,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 2508
},
{
"fk_product_image_set": 692,
"id_product_image": 2510,
"alt_text_small": "",
"product_image_key": "product_image_2510",
"updated_at": "2025-12-02 09:55:24.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610395FF-03?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610395FF-03",
"created_at": "2025-12-02 09:55:24.000000",
"id_product_image_set_to_product_image": 2510,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 2510
},
{
"fk_product_image_set": 692,
"id_product_image": 2512,
"alt_text_small": "",
"product_image_key": "product_image_2512",
"updated_at": "2025-12-02 09:55:24.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610395II-02?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610395II-02",
"created_at": "2025-12-02 09:55:24.000000",
"id_product_image_set_to_product_image": 2512,
"sort_order": 5,
"alt_text_large": "",
"fk_product_image": 2512
},
{
"fk_product_image_set": 692,
"id_product_image": 2514,
"alt_text_small": "",
"product_image_key": "product_image_2514",
"updated_at": "2025-12-02 09:55:24.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00034271-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00034271-01",
"created_at": "2025-12-02 09:55:24.000000",
"id_product_image_set_to_product_image": 2514,
"sort_order": 7,
"alt_text_large": "",
"fk_product_image": 2514
},
{
"fk_product_image_set": 692,
"id_product_image": 2516,
"alt_text_small": "",
"product_image_key": "product_image_2516",
"updated_at": "2025-12-02 09:55:24.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610395II-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610395II-01",
"created_at": "2025-12-02 09:55:24.000000",
"id_product_image_set_to_product_image": 2516,
"sort_order": 9,
"alt_text_large": "",
"fk_product_image": 2516
},
{
"fk_product_image_set": 692,
"id_product_image": 2518,
"alt_text_small": "",
"product_image_key": "product_image_2518",
"updated_at": "2025-12-02 09:55:24.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK94886-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK94886-01",
"created_at": "2025-12-02 09:55:24.000000",
"id_product_image_set_to_product_image": 2518,
"sort_order": 11,
"alt_text_large": "",
"fk_product_image": 2518
}
],
"id_product_labels": [],
"price": 78884,
"abstract_name": "Hammerbacher UPLINER standing desk, electrically height-adjustable - 655 - 1300 mm, WxD 1600 x 800 mm",
"id_product_abstract": 359,
"type": "product_abstract",
"add_to_cart_sku": "575059",
"prices": {
"DEFAULT": 78884
},
"abstract_sku": "M72943",
"url": "\/en\/upliner-stehschreibtisch-elektrisch-hoehenverstellbar-655-1300-mm-bxt-1600-x-800-mm-M72943"
},
{
"images": [
{
"fk_product_image_set": 2,
"id_product_image": 2,
"alt_text_small": "",
"product_image_key": "product_image_2",
"updated_at": "2025-12-02 09:55:08.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/22115z Stehpult lichtgrau?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/22115z Stehpult lichtgrau",
"created_at": "2025-12-02 09:55:08.000000",
"id_product_image_set_to_product_image": 2,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 2
}
],
"id_product_labels": [
5
],
"price": 2438,
"abstract_name": "Schomburg standing desk - HxWxD 1094 x 600 x 500 mm ",
"id_product_abstract": 1,
"type": "product_abstract",
"add_to_cart_sku": "1001454",
"prices": {
"DEFAULT": 2438,
"ORIGINAL": 10541
},
"abstract_sku": "C2235",
"url": "\/en\/schomburg-stehpult-hxbxt-1094-x-600-x-500-mm-C2235"
}
],
"spellingSuggestion": null,
"categoryTreeFilter": {
"0": {},
"1": {},
"2": {},
"3": {},
"4": {},
"5": {}
}
}
|