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"
}
},
{
"bool": {
"should": [
{
"nested": {
"path": "string-facet",
"query": {
"bool": {
"filter": [
{
"term": {
"string-facet.facet-name": {
"value": "merchant_name",
"boost": 1
}
}
},
{
"term": {
"string-facet.facet-value": {
"value": "Spryker",
"boost": 1
}
}
}
]
}
}
}
}
]
}
}
]
}
},
"suggest": {
"text": ""
},
"_source": [
"search-result-data"
],
"from": 228,
"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
}
}
}
}
}
},
"global-merchant_name": {
"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": {
"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": {
"merchant_name": [
"Spryker"
],
"page": "20"
}
}
|
{
"facets": {
"category": {},
"rating": {},
"label": {},
"farbe": {},
"material": {},
"brand": {},
"merchant_name": {}
},
"sort": {},
"pagination": {},
"products": [
{
"images": [
{
"fk_product_image_set": 242,
"id_product_image": 900,
"alt_text_small": "",
"product_image_key": "product_image_900",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007754Y?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007754Y",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 900,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 900
}
],
"id_product_labels": [],
"price": 491,
"abstract_name": "Smart Print copy paper DIN 60 g, white, 500 sheets\/pack.",
"id_product_abstract": 124,
"type": "product_abstract",
"add_to_cart_sku": "421378",
"prices": {
"DEFAULT": 491
},
"abstract_sku": "M21703",
"url": "\/en\/smart-print-kopierpapier-din-60g-weiss-500-bl-pack-M21703"
},
{
"images": [
{
"fk_product_image_set": 244,
"id_product_image": 902,
"alt_text_small": "",
"product_image_key": "product_image_902",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006867Q?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006867Q",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 902,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 902
},
{
"fk_product_image_set": 244,
"id_product_image": 904,
"alt_text_small": "",
"product_image_key": "product_image_904",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006867R?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006867R",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 904,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 904
},
{
"fk_product_image_set": 244,
"id_product_image": 906,
"alt_text_small": "",
"product_image_key": "product_image_906",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006867S?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006867S",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 906,
"sort_order": 5,
"alt_text_large": "",
"fk_product_image": 906
},
{
"fk_product_image_set": 244,
"id_product_image": 908,
"alt_text_small": "",
"product_image_key": "product_image_908",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010770O?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010770O",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 908,
"sort_order": 7,
"alt_text_large": "",
"fk_product_image": 908
},
{
"fk_product_image_set": 244,
"id_product_image": 910,
"alt_text_small": "",
"product_image_key": "product_image_910",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006867T?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006867T",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 910,
"sort_order": 9,
"alt_text_large": "",
"fk_product_image": 910
}
],
"id_product_labels": [],
"price": 363,
"abstract_name": "Clairefontaine Collegeblock DIN A4, 80 sheets, white",
"id_product_abstract": 125,
"type": "product_abstract",
"add_to_cart_sku": "421425",
"prices": {
"DEFAULT": 363
},
"abstract_sku": "M21704",
"url": "\/en\/clairefontaine-collegeblock-din-a4-80blatt-weiss-M21704"
},
{
"images": [
{
"fk_product_image_set": 246,
"id_product_image": 912,
"alt_text_small": "",
"product_image_key": "product_image_912",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007760Z?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007760Z",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 912,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 912
},
{
"fk_product_image_set": 246,
"id_product_image": 914,
"alt_text_small": "",
"product_image_key": "product_image_914",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007761B?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007761B",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 914,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 914
}
],
"id_product_labels": [],
"price": 1920,
"abstract_name": "Clairefontaine color laser paper DCP DIN 160 g, ivory, 250 sheets\/pack.",
"id_product_abstract": 126,
"type": "product_abstract",
"add_to_cart_sku": "655941",
"prices": {
"DEFAULT": 1920
},
"abstract_sku": "M21705",
"url": "\/en\/clairefontaine-farblaserpapier-dcp-din-160g-el-250-bl-pack-M21705"
},
{
"images": [
{
"fk_product_image_set": 248,
"id_product_image": 916,
"alt_text_small": "",
"product_image_key": "product_image_916",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010706E?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010706E",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 916,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 916
},
{
"fk_product_image_set": 248,
"id_product_image": 918,
"alt_text_small": "",
"product_image_key": "product_image_918",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010706C?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010706C",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 918,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 918
}
],
"id_product_labels": [],
"price": 541,
"abstract_name": "Clairefontaine notebook DIN A6 90 g, 96 sheets, sorted",
"id_product_abstract": 127,
"type": "product_abstract",
"add_to_cart_sku": "421418",
"prices": {
"DEFAULT": 541
},
"abstract_sku": "M21708",
"url": "\/en\/clairefontaine-kladde-din-a6-90g-96blatt-sortiert-M21708"
},
{
"images": [
{
"fk_product_image_set": 252,
"id_product_image": 922,
"alt_text_small": "",
"product_image_key": "product_image_922",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007109P?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007109P",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 922,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 922
},
{
"fk_product_image_set": 252,
"id_product_image": 924,
"alt_text_small": "",
"product_image_key": "product_image_924",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007109Q?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007109Q",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 924,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 924
},
{
"fk_product_image_set": 252,
"id_product_image": 926,
"alt_text_small": "",
"product_image_key": "product_image_926",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007109R?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007109R",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 926,
"sort_order": 5,
"alt_text_large": "",
"fk_product_image": 926
},
{
"fk_product_image_set": 252,
"id_product_image": 928,
"alt_text_small": "",
"product_image_key": "product_image_928",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010706B?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010706B",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 928,
"sort_order": 7,
"alt_text_large": "",
"fk_product_image": 928
},
{
"fk_product_image_set": 252,
"id_product_image": 930,
"alt_text_small": "",
"product_image_key": "product_image_930",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010706E?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010706E",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 930,
"sort_order": 9,
"alt_text_large": "",
"fk_product_image": 930
}
],
"id_product_labels": [],
"price": 1024,
"abstract_name": "Clairefontaine notebook DIN A4, 96 sheets, sorted",
"id_product_abstract": 129,
"type": "product_abstract",
"add_to_cart_sku": "421428",
"prices": {
"DEFAULT": 1024
},
"abstract_sku": "M21713",
"url": "\/en\/clairefontaine-kladde-din-a4-90g-96blatt-sortiert-M21713"
},
{
"images": [
{
"fk_product_image_set": 254,
"id_product_image": 932,
"alt_text_small": "",
"product_image_key": "product_image_932",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007761W?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007761W",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 932,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 932
}
],
"id_product_labels": [],
"price": 1004,
"abstract_name": "Clairefontaine Meetingblock 328000C DIN A4, 80 sheets, color sorted",
"id_product_abstract": 130,
"type": "product_abstract",
"add_to_cart_sku": "421432",
"prices": {
"DEFAULT": 1004
},
"abstract_sku": "M21714",
"url": "\/en\/clairefontaine-meetingblock-328000c-din-a4-80blatt-farbig-sortiert-M21714"
},
{
"images": [
{
"fk_product_image_set": 256,
"id_product_image": 934,
"alt_text_small": "",
"product_image_key": "product_image_934",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007762B?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007762B",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 934,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 934
},
{
"fk_product_image_set": 256,
"id_product_image": 936,
"alt_text_small": "",
"product_image_key": "product_image_936",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007762A?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007762A",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 936,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 936
}
],
"id_product_labels": [],
"price": 580,
"abstract_name": "Clairefontaine Spiralblock DIN A4, 90 sheets",
"id_product_abstract": 131,
"type": "product_abstract",
"add_to_cart_sku": "421433",
"prices": {
"DEFAULT": 580
},
"abstract_sku": "M21715",
"url": "\/en\/clairefontaine-spiralblock-din-a4-90blatt-M21715"
},
{
"images": [
{
"fk_product_image_set": 258,
"id_product_image": 938,
"alt_text_small": "",
"product_image_key": "product_image_938",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007772E?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007772E",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 938,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 938
}
],
"id_product_labels": [],
"price": 649,
"abstract_name": "Clairefontaine Collegeblock 328626C DIN A4, 80 sheets, checkered",
"id_product_abstract": 132,
"type": "product_abstract",
"add_to_cart_sku": "421435",
"prices": {
"DEFAULT": 649
},
"abstract_sku": "M21716",
"url": "\/en\/clairefontaine-collegeblock-328626c-din-a4-80blatt-kariert-M21716"
},
{
"images": [
{
"fk_product_image_set": 260,
"id_product_image": 940,
"alt_text_small": "",
"product_image_key": "product_image_940",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007762C?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007762C",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 940,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 940
}
],
"id_product_labels": [],
"price": 245,
"abstract_name": "Clairefontaine Spiralblock 328725C DIN 17x22 mm, 50 sheets, checkered",
"id_product_abstract": 133,
"type": "product_abstract",
"add_to_cart_sku": "421436",
"prices": {
"DEFAULT": 245
},
"abstract_sku": "M21717",
"url": "\/en\/clairefontaine-spiralblock-328725c-17x22mm-50blatt-kariert-M21717"
},
{
"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"
}
],
"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": []
}
|
{}
|