| 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": "6",
"boost": 1
}
}
}
]
}
},
"suggest": {
"text": ""
},
"_source": [
"search-result-data"
],
"sort": [
{
"integer-sort.category:6": {
"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": 6
}
}
|
{
"facets": {
"category": {},
"rating": {},
"label": {},
"farbe": {},
"material": {},
"brand": {},
"merchant_name": {}
},
"sort": {},
"pagination": {},
"products": [
{
"images": [
{
"fk_product_image_set": 262,
"id_product_image": 942,
"alt_text_small": "",
"product_image_key": "product_image_942",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S109005E?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S109005E",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 942,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 942
}
],
"id_product_labels": [],
"price": 393,
"abstract_name": "rotring mechanical pencil Tikky RD 1904694, 0.35 mm, black",
"id_product_abstract": 134,
"type": "product_abstract",
"add_to_cart_sku": "421475",
"prices": {
"DEFAULT": 393
},
"abstract_sku": "M21740",
"url": "\/en\/rotring-druckbleistift-tikky-rd-1904694-0-35mm-schwarz-M21740"
},
{
"images": [
{
"fk_product_image_set": 264,
"id_product_image": 944,
"alt_text_small": "",
"product_image_key": "product_image_944",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S109005F?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S109005F",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 944,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 944
}
],
"id_product_labels": [],
"price": 393,
"abstract_name": "rotring mechanical pencil Tikky RD 1904695 0.5 mm, black",
"id_product_abstract": 135,
"type": "product_abstract",
"add_to_cart_sku": "421476",
"prices": {
"DEFAULT": 393
},
"abstract_sku": "M21741",
"url": "\/en\/rotring-druckbleistift-tikky-rd-1904695-0-5mm-schwarz-M21741"
},
{
"images": [
{
"fk_product_image_set": 266,
"id_product_image": 946,
"alt_text_small": "",
"product_image_key": "product_image_946",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S109005G?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S109005G",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 946,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 946
}
],
"id_product_labels": [],
"price": 393,
"abstract_name": "rotring mechanical pencil Tikky RD 1904696 0.7 mm, black",
"id_product_abstract": 136,
"type": "product_abstract",
"add_to_cart_sku": "421477",
"prices": {
"DEFAULT": 393
},
"abstract_sku": "M21742",
"url": "\/en\/rotring-druckbleistift-tikky-rd-1904696-0-7mm-schwarz-M21742"
},
{
"images": [
{
"fk_product_image_set": 268,
"id_product_image": 948,
"alt_text_small": "",
"product_image_key": "product_image_948",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S109005H?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S109005H",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 948,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 948
}
],
"id_product_labels": [],
"price": 393,
"abstract_name": "rotring mechanical pencil Tikky RD 1904697, 1 mm, black",
"id_product_abstract": 137,
"type": "product_abstract",
"add_to_cart_sku": "421478",
"prices": {
"DEFAULT": 393
},
"abstract_sku": "M21743",
"url": "\/en\/rotring-druckbleistift-tikky-rd-1904697-1mm-schwarz-M21743"
},
{
"images": [
{
"fk_product_image_set": 272,
"id_product_image": 954,
"alt_text_small": "",
"product_image_key": "product_image_954",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S109002W?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S109002W",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 954,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 954
}
],
"id_product_labels": [],
"price": 1182,
"abstract_name": "rotring mechanical pencil Tikky S0801310, 3 pieces\/pack",
"id_product_abstract": 139,
"type": "product_abstract",
"add_to_cart_sku": "421481",
"prices": {
"DEFAULT": 1182
},
"abstract_sku": "M21745",
"url": "\/en\/rotring-druckbleistift-tikky-s0801310-3-st-pack-M21745"
},
{
"images": [
{
"fk_product_image_set": 280,
"id_product_image": 976,
"alt_text_small": "",
"product_image_key": "product_image_976",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/R005702B?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/R005702B",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 976,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 976
}
],
"id_product_labels": [],
"price": 3642,
"abstract_name": "rotring fountain pen rapidograph S0194270, 0.25 mm, black",
"id_product_abstract": 143,
"type": "product_abstract",
"add_to_cart_sku": "421531",
"prices": {
"DEFAULT": 3642
},
"abstract_sku": "M21772",
"url": "\/en\/rotring-tuschefueller-rapidograph-s0194270-0-25mm-schwarz-M21772"
},
{
"images": [
{
"fk_product_image_set": 282,
"id_product_image": 978,
"alt_text_small": "",
"product_image_key": "product_image_978",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/R005702D?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/R005702D",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 978,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 978
},
{
"fk_product_image_set": 282,
"id_product_image": 980,
"alt_text_small": "",
"product_image_key": "product_image_980",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/R005702A?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/R005702A",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 980,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 980
}
],
"id_product_labels": [],
"price": 4168,
"abstract_name": "rotring fountain pen rapidograph red",
"id_product_abstract": 144,
"type": "product_abstract",
"add_to_cart_sku": "421533",
"prices": {
"DEFAULT": 4168
},
"abstract_sku": "M21773",
"url": "\/en\/rotring-tuschefueller-rapidograph-rot-M21773"
},
{
"images": [
{
"fk_product_image_set": 314,
"id_product_image": 1072,
"alt_text_small": "",
"product_image_key": "product_image_1072",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003006H?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003006H",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 1072,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1072
},
{
"fk_product_image_set": 314,
"id_product_image": 1074,
"alt_text_small": "",
"product_image_key": "product_image_1074",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007120F?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007120F",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 1074,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 1074
}
],
"id_product_labels": [],
"price": 90,
"abstract_name": "Soennecken fine refill HB 12 pieces\/pack.",
"id_product_abstract": 160,
"type": "product_abstract",
"add_to_cart_sku": "422855",
"prices": {
"DEFAULT": 90
},
"abstract_sku": "M22484",
"url": "\/en\/soennecken-feinmine-hb-12-st-pack-M22484"
},
{
"images": [
{
"fk_product_image_set": 336,
"id_product_image": 1150,
"alt_text_small": "",
"product_image_key": "product_image_1150",
"updated_at": "2025-12-02 09:55:16.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006240J?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006240J",
"created_at": "2025-12-02 09:55:16.000000",
"id_product_image_set_to_product_image": 1150,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1150
},
{
"fk_product_image_set": 336,
"id_product_image": 1152,
"alt_text_small": "",
"product_image_key": "product_image_1152",
"updated_at": "2025-12-02 09:55:16.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007197S?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007197S",
"created_at": "2025-12-02 09:55:16.000000",
"id_product_image_set_to_product_image": 1152,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 1152
},
{
"fk_product_image_set": 336,
"id_product_image": 1154,
"alt_text_small": "",
"product_image_key": "product_image_1154",
"updated_at": "2025-12-02 09:55:16.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006240L?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006240L",
"created_at": "2025-12-02 09:55:16.000000",
"id_product_image_set_to_product_image": 1154,
"sort_order": 5,
"alt_text_large": "",
"fk_product_image": 1154
}
],
"id_product_labels": [],
"price": 586,
"abstract_name": "Sigel chalk marker 50, 1-5 mm chisel tip",
"id_product_abstract": 175,
"type": "product_abstract",
"add_to_cart_sku": "424273",
"prices": {
"DEFAULT": 586
},
"abstract_sku": "M23345",
"url": "\/en\/sigel-kreidemarker-50-1-5mm-keilspitze-M23345"
},
{
"images": [
{
"fk_product_image_set": 398,
"id_product_image": 1438,
"alt_text_small": "",
"product_image_key": "product_image_1438",
"updated_at": "2025-12-02 09:55:17.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/F004952T?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/F004952T",
"created_at": "2025-12-02 09:55:17.000000",
"id_product_image_set_to_product_image": 1438,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1438
}
],
"id_product_labels": [],
"price": 812,
"abstract_name": "Faber-Castell coloring pen color GRIP 112412, colored, 12 pieces\/pack.",
"id_product_abstract": 210,
"type": "product_abstract",
"add_to_cart_sku": "424599",
"prices": {
"DEFAULT": 812
},
"abstract_sku": "M23510",
"url": "\/en\/faber-castell-farbstift-colour-grip-112412-farbig-12-st-pack-M23510"
},
{
"images": [
{
"fk_product_image_set": 400,
"id_product_image": 1440,
"alt_text_small": "",
"product_image_key": "product_image_1440",
"updated_at": "2025-12-02 09:55:17.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/F004123F?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/F004123F",
"created_at": "2025-12-02 09:55:17.000000",
"id_product_image_set_to_product_image": 1440,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1440
},
{
"fk_product_image_set": 400,
"id_product_image": 1442,
"alt_text_small": "",
"product_image_key": "product_image_1442",
"updated_at": "2025-12-02 09:55:17.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/F004700D?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/F004700D",
"created_at": "2025-12-02 09:55:17.000000",
"id_product_image_set_to_product_image": 1442,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 1442
},
{
"fk_product_image_set": 400,
"id_product_image": 1444,
"alt_text_small": "",
"product_image_key": "product_image_1444",
"updated_at": "2025-12-02 09:55:17.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/F004858R?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/F004858R",
"created_at": "2025-12-02 09:55:17.000000",
"id_product_image_set_to_product_image": 1444,
"sort_order": 5,
"alt_text_large": "",
"fk_product_image": 1444
},
{
"fk_product_image_set": 400,
"id_product_image": 1446,
"alt_text_small": "",
"product_image_key": "product_image_1446",
"updated_at": "2025-12-02 09:55:17.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/F004858S?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/F004858S",
"created_at": "2025-12-02 09:55:17.000000",
"id_product_image_set_to_product_image": 1446,
"sort_order": 7,
"alt_text_large": "",
"fk_product_image": 1446
},
{
"fk_product_image_set": 400,
"id_product_image": 1448,
"alt_text_small": "",
"product_image_key": "product_image_1448",
"updated_at": "2025-12-02 09:55:17.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/F004858T?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/F004858T",
"created_at": "2025-12-02 09:55:17.000000",
"id_product_image_set_to_product_image": 1448,
"sort_order": 9,
"alt_text_large": "",
"fk_product_image": 1448
}
],
"id_product_labels": [],
"price": 100,
"abstract_name": "Faber-Castell pencil GRIP 2001 triangular, silver-gray",
"id_product_abstract": 211,
"type": "product_abstract",
"add_to_cart_sku": "424605",
"prices": {
"DEFAULT": 100
},
"abstract_sku": "M23512",
"url": "\/en\/faber-castell-bleistift-grip-2001-dreieckform-silbergrau-M23512"
},
{
"images": [
{
"fk_product_image_set": 402,
"id_product_image": 1450,
"alt_text_small": "",
"product_image_key": "product_image_1450",
"updated_at": "2025-12-02 09:55:17.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/F004700D?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/F004700D",
"created_at": "2025-12-02 09:55:17.000000",
"id_product_image_set_to_product_image": 1450,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1450
},
{
"fk_product_image_set": 402,
"id_product_image": 1452,
"alt_text_small": "",
"product_image_key": "product_image_1452",
"updated_at": "2025-12-02 09:55:17.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/F004750N?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/F004750N",
"created_at": "2025-12-02 09:55:17.000000",
"id_product_image_set_to_product_image": 1452,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 1452
}
],
"id_product_labels": [],
"price": 107,
"abstract_name": "Faber-Castell pen GRIP 2001 117200 with eraser, HB, silver gray",
"id_product_abstract": 212,
"type": "product_abstract",
"add_to_cart_sku": "424606",
"prices": {
"DEFAULT": 107
},
"abstract_sku": "M23513",
"url": "\/en\/faber-castell-bleistift-grip-2001-117200-mit-radierer-hb-silbergrau-M23513"
}
],
"spellingSuggestion": null,
"categoryTreeFilter": {
"0": {},
"1": {},
"2": {},
"3": {},
"4": {},
"5": {}
}
}
|