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"
}
}
]
}
},
"suggest": {
"text": ""
},
"_source": [
"search-result-data"
],
"from": 372,
"size": 12,
"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": "32"
}
}
|
{
"facets": {
"category": {},
"rating": {},
"label": {},
"farbe": {},
"material": {},
"brand": {},
"merchant_name": {}
},
"sort": {},
"pagination": {},
"products": [
{
"images": [
{
"fk_product_image_set": 134,
"id_product_image": 512,
"alt_text_small": "",
"product_image_key": "product_image_512",
"updated_at": "2025-12-02 09:55:11.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00926275II-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00926275II-01",
"created_at": "2025-12-02 09:55:11.000000",
"id_product_image_set_to_product_image": 512,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 512
},
{
"fk_product_image_set": 134,
"id_product_image": 514,
"alt_text_small": "",
"product_image_key": "product_image_514",
"updated_at": "2025-12-02 09:55:11.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052674-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052674-01",
"created_at": "2025-12-02 09:55:11.000000",
"id_product_image_set_to_product_image": 514,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 514
},
{
"fk_product_image_set": 134,
"id_product_image": 516,
"alt_text_small": "",
"product_image_key": "product_image_516",
"updated_at": "2025-12-02 09:55:11.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052674-03?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052674-03",
"created_at": "2025-12-02 09:55:11.000000",
"id_product_image_set_to_product_image": 516,
"sort_order": 5,
"alt_text_large": "",
"fk_product_image": 516
}
],
"id_product_labels": [
5
],
"price": 13682,
"abstract_name": "Smit visual flip chart - floor model with side arms",
"id_product_abstract": 65,
"type": "product_abstract",
"add_to_cart_sku": "100430",
"prices": {
"DEFAULT": 13682,
"ORIGINAL": 15202
},
"abstract_sku": "M11222",
"url": "\/en\/flip-chart-standmodell-mit-seitenarmen-M11222"
},
{
"images": [
{
"fk_product_image_set": 142,
"id_product_image": 554,
"alt_text_small": "",
"product_image_key": "product_image_554",
"updated_at": "2025-12-02 09:55:12.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00016325F-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00016325F-01",
"created_at": "2025-12-02 09:55:12.000000",
"id_product_image_set_to_product_image": 554,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 554
},
{
"fk_product_image_set": 144,
"id_product_image": 556,
"alt_text_small": "",
"product_image_key": "product_image_556",
"updated_at": "2025-12-02 09:55:12.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/P_GS0126?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/P_GS0126",
"created_at": "2025-12-02 09:55:12.000000",
"id_product_image_set_to_product_image": 556,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 556
}
],
"id_product_labels": [
4,
5
],
"price": 11482,
"abstract_name": "Wood stackable chair - 4-foot substructure, upholstered seat",
"rating": 4,
"id_product_abstract": 69,
"review_count": 6,
"type": "product_abstract",
"add_to_cart_sku": "104517",
"prices": {
"DEFAULT": 11482,
"ORIGINAL": 12757
},
"abstract_sku": "M11542",
"url": "\/en\/holz-schalenstuhl-4-fuss-gestell-sitz-gepolstert-M11542"
},
{
"images": [
{
"fk_product_image_set": 176,
"id_product_image": 722,
"alt_text_small": "",
"product_image_key": "product_image_722",
"updated_at": "2025-12-02 09:55:13.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007049U?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007049U",
"created_at": "2025-12-02 09:55:13.000000",
"id_product_image_set_to_product_image": 722,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 722
},
{
"fk_product_image_set": 176,
"id_product_image": 724,
"alt_text_small": "",
"product_image_key": "product_image_724",
"updated_at": "2025-12-02 09:55:13.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007050D?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007050D",
"created_at": "2025-12-02 09:55:13.000000",
"id_product_image_set_to_product_image": 724,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 724
}
],
"id_product_labels": [
1,
2
],
"price": 1579,
"abstract_name": "Verbatim USB stick Store n Go V3 49173 32GB USB3.0 gray",
"id_product_abstract": 87,
"type": "product_abstract",
"add_to_cart_sku": "420566",
"prices": {
"DEFAULT": 1579
},
"abstract_sku": "M21100",
"url": "\/en\/verbatim-usb-stick-store-n-go-v3-49173-32gb-usb3-0-grau-M21100"
},
{
"images": [
{
"fk_product_image_set": 188,
"id_product_image": 744,
"alt_text_small": "",
"product_image_key": "product_image_744",
"updated_at": "2025-12-02 09:55:13.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/D041945R?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/D041945R",
"created_at": "2025-12-02 09:55:13.000000",
"id_product_image_set_to_product_image": 744,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 744
}
],
"id_product_labels": [
4,
5
],
"price": 484,
"abstract_name": "Post-it Index Strong adhesive stripes, 686-F1EU 4 sheets sorted, 4 pieces\/pack",
"rating": 4.6699999999999999,
"id_product_abstract": 93,
"review_count": 3,
"type": "product_abstract",
"add_to_cart_sku": "420687",
"prices": {
"DEFAULT": 484,
"ORIGINAL": 537
},
"abstract_sku": "M21190",
"url": "\/en\/post-it-haftstreifen-index-strong-686-f1eu-4blatt-sortiert-4-st-pack-M21190"
},
{
"images": [
{
"fk_product_image_set": 798,
"id_product_image": 3172,
"alt_text_small": "",
"product_image_key": "product_image_3172",
"updated_at": "2025-12-02 09:55:28.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007778B?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007778B",
"created_at": "2025-12-02 09:55:28.000000",
"id_product_image_set_to_product_image": 3172,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 3172
}
],
"id_product_labels": [
4
],
"price": 620,
"abstract_name": "Clairefontaine Collegeblock 8272C DIN A5, 90 sheets",
"id_product_abstract": 119,
"type": "product_abstract",
"prices": {
"DEFAULT": 620
},
"abstract_sku": "M21690",
"url": "\/en\/clairefontaine-collegeblock-8272c-din-a5-90blatt-M21690"
},
{
"images": [
{
"fk_product_image_set": 800,
"id_product_image": 3174,
"alt_text_small": "",
"product_image_key": "product_image_3174",
"updated_at": "2025-12-02 09:55:28.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007778C?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007778C",
"created_at": "2025-12-02 09:55:28.000000",
"id_product_image_set_to_product_image": 3174,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 3174
}
],
"id_product_labels": [
4
],
"price": 620,
"abstract_name": "Clairefontaine Collegeblock 8272C DIN A5, 90 sheets",
"id_product_abstract": 120,
"type": "product_abstract",
"prices": {
"DEFAULT": 620
},
"abstract_sku": "M21691",
"url": "\/en\/clairefontaine-collegeblock-8275c-din-a5-90blatt-M21691"
},
{
"images": [
{
"fk_product_image_set": 802,
"id_product_image": 3176,
"alt_text_small": "",
"product_image_key": "product_image_3176",
"updated_at": "2025-12-02 09:55:28.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007778D?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007778D",
"created_at": "2025-12-02 09:55:28.000000",
"id_product_image_set_to_product_image": 3176,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 3176
}
],
"id_product_labels": [
4
],
"price": 620,
"abstract_name": "Clairefontaine Collegeblock 8272C DIN A5, 90 sheets",
"rating": 4,
"id_product_abstract": 121,
"review_count": 6,
"type": "product_abstract",
"prices": {
"DEFAULT": 620
},
"abstract_sku": "M21692",
"url": "\/en\/clairefontaine-collegeblock-8272c-din-a5-90blatt-kariert-M21692"
},
{
"images": [
{
"fk_product_image_set": 804,
"id_product_image": 3178,
"alt_text_small": "",
"product_image_key": "product_image_3178",
"updated_at": "2025-12-02 09:55:28.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007778E?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007778E",
"created_at": "2025-12-02 09:55:28.000000",
"id_product_image_set_to_product_image": 3178,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 3178
}
],
"id_product_labels": [
4
],
"price": 620,
"abstract_name": "Clairefontaine Collegeblock 8272C DIN A5, 90 sheets",
"id_product_abstract": 122,
"type": "product_abstract",
"prices": {
"DEFAULT": 620
},
"abstract_sku": "M21693",
"url": "\/en\/clairefontaine-collegeblock-8275c-din-a5-90blatt-liniert-M21693"
},
{
"images": [
{
"fk_product_image_set": 274,
"id_product_image": 956,
"alt_text_small": "",
"product_image_key": "product_image_956",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007100O?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007100O",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 956,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 956
},
{
"fk_product_image_set": 274,
"id_product_image": 958,
"alt_text_small": "",
"product_image_key": "product_image_958",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007100P?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007100P",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 958,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 958
}
],
"id_product_labels": [
4,
5
],
"price": 2956,
"abstract_name": "Parker ballpoint pen URBAN Premium M refill blue",
"rating": 4.25,
"id_product_abstract": 140,
"review_count": 4,
"type": "product_abstract",
"add_to_cart_sku": "421511",
"prices": {
"DEFAULT": 2956,
"ORIGINAL": 3284
},
"abstract_sku": "M21759",
"url": "\/en\/parker-kugelschreiber-urban-premium-m-mine-blau-M21759"
},
{
"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"
}
],
"spellingSuggestion": null,
"categoryTreeFilter": {
"0": {},
"1": {},
"2": {},
"3": {},
"4": {},
"5": {}
}
}
|
| Http://search:9200 |
{
"query": {
"query": {
"bool": {
"must": [
{
"match_all": {}
},
{
"match": {
"type": "cms_page"
}
},
{
"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"
}
}
]
}
}
]
}
}
]
}
},
"_source": [
"search-result-data"
]
},
"parameters": []
}
|
{}
|