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": "19",
"boost": 1
}
}
}
]
}
},
"suggest": {
"text": ""
},
"_source": [
"search-result-data"
],
"sort": [
{
"integer-sort.category:19": {
"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": 19
}
}
|
{
"facets": {
"category": {},
"rating": {},
"label": {},
"farbe": {},
"material": {},
"brand": {},
"merchant_name": {}
},
"sort": {},
"pagination": {},
"products": [
{
"images": [
{
"fk_product_image_set": 534,
"id_product_image": 1680,
"alt_text_small": "",
"product_image_key": "product_image_1680",
"updated_at": "2025-12-02 09:55:19.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00029472F-02?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00029472F-02",
"created_at": "2025-12-02 09:55:19.000000",
"id_product_image_set_to_product_image": 1680,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1680
}
],
"id_product_labels": [
5
],
"price": 22834,
"abstract_name": "Standing desk, height-adjustable - mobile, light gray",
"id_product_abstract": 278,
"type": "product_abstract",
"add_to_cart_sku": "101560",
"prices": {
"DEFAULT": 22834,
"ORIGINAL": 25371
},
"abstract_sku": "M39658",
"url": "\/en\/stehpult-hoehenverstellbar-mobil-lichtgrau-M39658"
},
{
"images": [
{
"fk_product_image_set": 150,
"id_product_image": 608,
"alt_text_small": "",
"product_image_key": "product_image_608",
"updated_at": "2025-12-02 09:55:12.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052676-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052676-01",
"created_at": "2025-12-02 09:55:12.000000",
"id_product_image_set_to_product_image": 608,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 608
},
{
"fk_product_image_set": 150,
"id_product_image": 610,
"alt_text_small": "",
"product_image_key": "product_image_610",
"updated_at": "2025-12-02 09:55:12.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00757395FF-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00757395FF-01",
"created_at": "2025-12-02 09:55:12.000000",
"id_product_image_set_to_product_image": 610,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 610
},
{
"fk_product_image_set": 150,
"id_product_image": 612,
"alt_text_small": "",
"product_image_key": "product_image_612",
"updated_at": "2025-12-02 09:55:12.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00757396FF-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00757396FF-01",
"created_at": "2025-12-02 09:55:12.000000",
"id_product_image_set_to_product_image": 612,
"sort_order": 5,
"alt_text_large": "",
"fk_product_image": 612
},
{
"fk_product_image_set": 150,
"id_product_image": 614,
"alt_text_small": "",
"product_image_key": "product_image_614",
"updated_at": "2025-12-02 09:55:12.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00053208-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00053208-01",
"created_at": "2025-12-02 09:55:12.000000",
"id_product_image_set_to_product_image": 614,
"sort_order": 7,
"alt_text_large": "",
"fk_product_image": 614
},
{
"fk_product_image_set": 150,
"id_product_image": 616,
"alt_text_small": "",
"product_image_key": "product_image_616",
"updated_at": "2025-12-02 09:55:12.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052676-03?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052676-03",
"created_at": "2025-12-02 09:55:12.000000",
"id_product_image_set_to_product_image": 616,
"sort_order": 9,
"alt_text_large": "",
"fk_product_image": 616
},
{
"fk_product_image_set": 150,
"id_product_image": 618,
"alt_text_small": "",
"product_image_key": "product_image_618",
"updated_at": "2025-12-02 09:55:12.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00757396II-02?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00757396II-02",
"created_at": "2025-12-02 09:55:12.000000",
"id_product_image_set_to_product_image": 618,
"sort_order": 11,
"alt_text_large": "",
"fk_product_image": 618
},
{
"fk_product_image_set": 150,
"id_product_image": 620,
"alt_text_small": "",
"product_image_key": "product_image_620",
"updated_at": "2025-12-02 09:55:12.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00757396II-03?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00757396II-03",
"created_at": "2025-12-02 09:55:12.000000",
"id_product_image_set_to_product_image": 620,
"sort_order": 13,
"alt_text_large": "",
"fk_product_image": 620
}
],
"id_product_labels": [
5
],
"price": 25523,
"abstract_name": "Carto lectern, 2 shelves - Front made of fabric",
"id_product_abstract": 74,
"type": "product_abstract",
"add_to_cart_sku": "101759",
"prices": {
"DEFAULT": 25523,
"ORIGINAL": 28358
},
"abstract_sku": "M15226",
"url": "\/en\/rednerpult-2-ablagen-front-aus-stoff-M15226"
},
{
"images": [
{
"fk_product_image_set": 26,
"id_product_image": 80,
"alt_text_small": "",
"product_image_key": "product_image_80",
"updated_at": "2025-12-02 09:55:08.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00759524II-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00759524II-01",
"created_at": "2025-12-02 09:55:08.000000",
"id_product_image_set_to_product_image": 80,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 80
},
{
"fk_product_image_set": 26,
"id_product_image": 82,
"alt_text_small": "",
"product_image_key": "product_image_82",
"updated_at": "2025-12-02 09:55:08.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00759524II-02?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00759524II-02",
"created_at": "2025-12-02 09:55:08.000000",
"id_product_image_set_to_product_image": 82,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 82
}
],
"id_product_labels": [],
"price": 1717,
"abstract_name": "Universal lectern - with upper shelf",
"id_product_abstract": 13,
"type": "product_abstract",
"add_to_cart_sku": "519762",
"prices": {
"DEFAULT": 1717
},
"abstract_sku": "M1013541",
"url": "\/en\/rednerpult-universell-mit-ablageboden-M1013541"
},
{
"images": [
{
"fk_product_image_set": 24,
"id_product_image": 70,
"alt_text_small": "",
"product_image_key": "product_image_70",
"updated_at": "2025-12-02 09:55:08.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756546II-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756546II-01",
"created_at": "2025-12-02 09:55:08.000000",
"id_product_image_set_to_product_image": 70,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 70
},
{
"fk_product_image_set": 24,
"id_product_image": 72,
"alt_text_small": "",
"product_image_key": "product_image_72",
"updated_at": "2025-12-02 09:55:08.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756548II-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756548II-01",
"created_at": "2025-12-02 09:55:08.000000",
"id_product_image_set_to_product_image": 72,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 72
},
{
"fk_product_image_set": 24,
"id_product_image": 74,
"alt_text_small": "",
"product_image_key": "product_image_74",
"updated_at": "2025-12-02 09:55:08.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756546II-G1?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756546II-G1",
"created_at": "2025-12-02 09:55:08.000000",
"id_product_image_set_to_product_image": 74,
"sort_order": 5,
"alt_text_large": "",
"fk_product_image": 74
},
{
"fk_product_image_set": 24,
"id_product_image": 76,
"alt_text_small": "",
"product_image_key": "product_image_76",
"updated_at": "2025-12-02 09:55:08.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756546II-G2?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756546II-G2",
"created_at": "2025-12-02 09:55:08.000000",
"id_product_image_set_to_product_image": 76,
"sort_order": 7,
"alt_text_large": "",
"fk_product_image": 76
},
{
"fk_product_image_set": 24,
"id_product_image": 78,
"alt_text_small": "",
"product_image_key": "product_image_78",
"updated_at": "2025-12-02 09:55:08.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756546II-G3?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756546II-G3",
"created_at": "2025-12-02 09:55:08.000000",
"id_product_image_set_to_product_image": 78,
"sort_order": 9,
"alt_text_large": "",
"fk_product_image": 78
}
],
"id_product_labels": [],
"price": 2137,
"abstract_name": "Smit Visual lectern, height-adjustable - mobile, with 4 rollers",
"id_product_abstract": 12,
"type": "product_abstract",
"add_to_cart_sku": "517630",
"prices": {
"DEFAULT": 2137
},
"abstract_sku": "M1013287",
"url": "\/en\/rednerpult-hoehenverstellbar-mobil-mit-4-rollen-M1013287"
},
{
"images": [
{
"fk_product_image_set": 124,
"id_product_image": 480,
"alt_text_small": "",
"product_image_key": "product_image_480",
"updated_at": "2025-12-02 09:55:11.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052676-02?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052676-02",
"created_at": "2025-12-02 09:55:11.000000",
"id_product_image_set_to_product_image": 480,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 480
},
{
"fk_product_image_set": 124,
"id_product_image": 482,
"alt_text_small": "",
"product_image_key": "product_image_482",
"updated_at": "2025-12-02 09:55:11.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052676-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052676-01",
"created_at": "2025-12-02 09:55:11.000000",
"id_product_image_set_to_product_image": 482,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 482
}
],
"id_product_labels": [],
"price": 21393,
"abstract_name": "Lectern, 2 shelves - Front made of steel sheet",
"id_product_abstract": 60,
"type": "product_abstract",
"add_to_cart_sku": "413849",
"prices": {
"DEFAULT": 21393
},
"abstract_sku": "M1079243",
"url": "\/en\/rednerpult-2-ablagen-front-aus-stahlblech-M1079243"
},
{
"images": [
{
"fk_product_image_set": 66,
"id_product_image": 192,
"alt_text_small": "",
"product_image_key": "product_image_192",
"updated_at": "2025-12-02 09:55:10.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00761038II-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00761038II-01",
"created_at": "2025-12-02 09:55:10.000000",
"id_product_image_set_to_product_image": 192,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 192
}
],
"id_product_labels": [
4
],
"price": 37728,
"abstract_name": "Rocada speaker stand FORUM - 2 glass plates",
"rating": 5,
"id_product_abstract": 31,
"review_count": 3,
"type": "product_abstract",
"add_to_cart_sku": "520561",
"prices": {
"DEFAULT": 37728
},
"abstract_sku": "M1016129",
"url": "\/en\/rednerstativ-forum-2-glasplatten-M1016129"
},
{
"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": {}
}
}
|