| Http://search:9200 |
{
"query": {
"query": {
"bool": {
"filter": [
{
"nested": {
"query": {
"bool": {
"filter": [
{
"term": {
"string-facet.facet-name": {
"value": "label",
"boost": 1
}
}
},
{
"term": {
"string-facet.facet-value": {
"value": 4,
"boost": 1
}
}
}
]
}
},
"path": "string-facet"
}
},
{
"nested": {
"query": {
"term": {
"integer-facet.facet-name": {
"value": "price-DEFAULT-EUR-GROSS_MODE",
"boost": 1
}
}
},
"path": "integer-facet"
}
}
],
"must": [
{
"match": {
"store": "DE"
}
},
{
"match": {
"locale": "en_US"
}
}
]
}
},
"_source": [
"search-result-data"
],
"from": 12,
"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": "2"
}
}
|
{
"facets": {
"category": {},
"rating": {},
"label": {},
"farbe": {},
"material": {},
"brand": {},
"merchant_name": {}
},
"sort": {},
"pagination": {},
"products": [
{
"images": [
{
"fk_product_image_set": 70,
"id_product_image": 200,
"alt_text_small": "",
"product_image_key": "product_image_200",
"updated_at": "2025-12-02 09:55:10.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970648FF-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970648FF-01",
"created_at": "2025-12-02 09:55:10.000000",
"id_product_image_set_to_product_image": 200,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 200
},
{
"fk_product_image_set": 70,
"id_product_image": 202,
"alt_text_small": "",
"product_image_key": "product_image_202",
"updated_at": "2025-12-02 09:55:10.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050296F-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050296F-01",
"created_at": "2025-12-02 09:55:10.000000",
"id_product_image_set_to_product_image": 202,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 202
},
{
"fk_product_image_set": 70,
"id_product_image": 204,
"alt_text_small": "",
"product_image_key": "product_image_204",
"updated_at": "2025-12-02 09:55:10.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:10.000000",
"id_product_image_set_to_product_image": 204,
"sort_order": 5,
"alt_text_large": "",
"fk_product_image": 204
}
],
"id_product_labels": [
4,
5
],
"price": 86943,
"abstract_name": "UPLINER standing desk, electric - without traverse, WxD 1800 x 800 mm",
"rating": 4,
"id_product_abstract": 33,
"review_count": 5,
"type": "product_abstract",
"add_to_cart_sku": "574995",
"prices": {
"DEFAULT": 86943,
"ORIGINAL": 96603
},
"abstract_sku": "M1017905",
"url": "\/en\/upliner-stehschreibtisch-elektrisch-ohne-traverse-bxt-1800-x-800-mm-M1017905"
},
{
"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": 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"
},
{
"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"
}
]
}
|