https://oalp.xiphias-digital.com/DE/en/newsletter/subscribe

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": 192,
        "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": "17"
    }
}
{
    "facets": {
        "category": {},
        "rating": {},
        "label": {},
        "farbe": {},
        "material": {},
        "brand": {},
        "merchant_name": {}
    },
    "sort": {},
    "pagination": {},
    "products": [
        {
            "images": [
                {
                    "fk_product_image_set": 122,
                    "id_product_image": 474,
                    "alt_text_small": "",
                    "product_image_key": "product_image_474",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052643-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052643-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 474,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 474
                },
                {
                    "fk_product_image_set": 122,
                    "id_product_image": 476,
                    "alt_text_small": "",
                    "product_image_key": "product_image_476",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052645-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052645-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 476,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 476
                },
                {
                    "fk_product_image_set": 122,
                    "id_product_image": 478,
                    "alt_text_small": "",
                    "product_image_key": "product_image_478",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052644-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052644-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 478,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 478
                }
            ],
            "id_product_labels": [],
            "price": 34293,
            "abstract_name": "IDEAL desk document shredder, EASY-TOUCH comfortable equipping, height 516 mm",
            "id_product_abstract": 59,
            "type": "product_abstract",
            "add_to_cart_sku": "413854",
            "prices": {
                "DEFAULT": 34293
            },
            "abstract_sku": "M1079222",
            "url": "\/en\/ideal-schreibtisch-aktenvernichter-easy-touch-komfortable-ausstattung-hoehe-516-mm-M1079222"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 152,
                    "id_product_image": 622,
                    "alt_text_small": "",
                    "product_image_key": "product_image_622",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00032045F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00032045F-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 622,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 622
                },
                {
                    "fk_product_image_set": 152,
                    "id_product_image": 624,
                    "alt_text_small": "",
                    "product_image_key": "product_image_624",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00890189FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00890189FF-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 624,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 624
                },
                {
                    "fk_product_image_set": 152,
                    "id_product_image": 626,
                    "alt_text_small": "",
                    "product_image_key": "product_image_626",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00890340FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00890340FF-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 626,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 626
                },
                {
                    "fk_product_image_set": 152,
                    "id_product_image": 628,
                    "alt_text_small": "",
                    "product_image_key": "product_image_628",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00890391FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00890391FF-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 628,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 628
                },
                {
                    "fk_product_image_set": 152,
                    "id_product_image": 630,
                    "alt_text_small": "",
                    "product_image_key": "product_image_630",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95241-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95241-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 630,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 630
                },
                {
                    "fk_product_image_set": 152,
                    "id_product_image": 632,
                    "alt_text_small": "",
                    "product_image_key": "product_image_632",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95242-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95242-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 632,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 632
                },
                {
                    "fk_product_image_set": 152,
                    "id_product_image": 634,
                    "alt_text_small": "",
                    "product_image_key": "product_image_634",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95243-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95243-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 634,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 634
                }
            ],
            "id_product_labels": [
                3
            ],
            "price": 67531,
            "abstract_name": "Wolf wardrobe - light gray RAL 7035",
            "id_product_abstract": 75,
            "type": "product_abstract",
            "add_to_cart_sku": "506670",
            "prices": {
                "DEFAULT": 67531
            },
            "abstract_sku": "M1896",
            "url": "\/en\/wolf-garderobe-lichtgrau-ral-7035-M1896"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 154,
                    "id_product_image": 636,
                    "alt_text_small": "",
                    "product_image_key": "product_image_636",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006124T?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006124T",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 636,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 636
                },
                {
                    "fk_product_image_set": 154,
                    "id_product_image": 638,
                    "alt_text_small": "",
                    "product_image_key": "product_image_638",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007592L?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007592L",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 638,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 638
                },
                {
                    "fk_product_image_set": 154,
                    "id_product_image": 640,
                    "alt_text_small": "",
                    "product_image_key": "product_image_640",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006683O?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006683O",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 640,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 640
                },
                {
                    "fk_product_image_set": 154,
                    "id_product_image": 642,
                    "alt_text_small": "",
                    "product_image_key": "product_image_642",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007603X?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007603X",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 642,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 642
                }
            ],
            "id_product_labels": [],
            "price": 517,
            "abstract_name": "Post-it Index Mini adhesive stripes, 35 sheets sorted 4",
            "id_product_abstract": 76,
            "type": "product_abstract",
            "add_to_cart_sku": "420506",
            "prices": {
                "DEFAULT": 517
            },
            "abstract_sku": "M21062",
            "url": "\/en\/post-it-haftstreifen-index-mini-35blatt-sortiert-4-M21062"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 156,
                    "id_product_image": 644,
                    "alt_text_small": "",
                    "product_image_key": "product_image_644",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006315A?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006315A",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 644,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 644
                },
                {
                    "fk_product_image_set": 156,
                    "id_product_image": 646,
                    "alt_text_small": "",
                    "product_image_key": "product_image_646",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007602R?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007602R",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 646,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 646
                },
                {
                    "fk_product_image_set": 156,
                    "id_product_image": 648,
                    "alt_text_small": "",
                    "product_image_key": "product_image_648",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/D041450J?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/D041450J",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 648,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 648
                },
                {
                    "fk_product_image_set": 156,
                    "id_product_image": 650,
                    "alt_text_small": "",
                    "product_image_key": "product_image_650",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007602Q?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007602Q",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 650,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 650
                },
                {
                    "fk_product_image_set": 156,
                    "id_product_image": 652,
                    "alt_text_small": "",
                    "product_image_key": "product_image_652",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/D041450K?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/D041450K",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 652,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 652
                },
                {
                    "fk_product_image_set": 156,
                    "id_product_image": 654,
                    "alt_text_small": "",
                    "product_image_key": "product_image_654",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007602P?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007602P",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 654,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 654
                },
                {
                    "fk_product_image_set": 156,
                    "id_product_image": 656,
                    "alt_text_small": "",
                    "product_image_key": "product_image_656",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/D041450L?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/D041450L",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 656,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 656
                },
                {
                    "fk_product_image_set": 156,
                    "id_product_image": 658,
                    "alt_text_small": "",
                    "product_image_key": "product_image_658",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007602T?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007602T",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 658,
                    "sort_order": 15,
                    "alt_text_large": "",
                    "fk_product_image": 658
                },
                {
                    "fk_product_image_set": 156,
                    "id_product_image": 660,
                    "alt_text_small": "",
                    "product_image_key": "product_image_660",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/D041584X?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/D041584X",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 660,
                    "sort_order": 17,
                    "alt_text_large": "",
                    "fk_product_image": 660
                },
                {
                    "fk_product_image_set": 156,
                    "id_product_image": 662,
                    "alt_text_small": "",
                    "product_image_key": "product_image_662",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007602U?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007602U",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 662,
                    "sort_order": 19,
                    "alt_text_large": "",
                    "fk_product_image": 662
                },
                {
                    "fk_product_image_set": 156,
                    "id_product_image": 664,
                    "alt_text_small": "",
                    "product_image_key": "product_image_664",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/D041450M?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/D041450M",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 664,
                    "sort_order": 21,
                    "alt_text_large": "",
                    "fk_product_image": 664
                },
                {
                    "fk_product_image_set": 156,
                    "id_product_image": 666,
                    "alt_text_small": "",
                    "product_image_key": "product_image_666",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007602W?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007602W",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 666,
                    "sort_order": 23,
                    "alt_text_large": "",
                    "fk_product_image": 666
                },
                {
                    "fk_product_image_set": 156,
                    "id_product_image": 668,
                    "alt_text_small": "",
                    "product_image_key": "product_image_668",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/D041584Z?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/D041584Z",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 668,
                    "sort_order": 25,
                    "alt_text_large": "",
                    "fk_product_image": 668
                },
                {
                    "fk_product_image_set": 156,
                    "id_product_image": 670,
                    "alt_text_small": "",
                    "product_image_key": "product_image_670",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007602S?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007602S",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 670,
                    "sort_order": 27,
                    "alt_text_large": "",
                    "fk_product_image": 670
                },
                {
                    "fk_product_image_set": 156,
                    "id_product_image": 672,
                    "alt_text_small": "",
                    "product_image_key": "product_image_672",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/D041584Y?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/D041584Y",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 672,
                    "sort_order": 29,
                    "alt_text_large": "",
                    "fk_product_image": 672
                },
                {
                    "fk_product_image_set": 156,
                    "id_product_image": 674,
                    "alt_text_small": "",
                    "product_image_key": "product_image_674",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007602V?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007602V",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 674,
                    "sort_order": 31,
                    "alt_text_large": "",
                    "fk_product_image": 674
                },
                {
                    "fk_product_image_set": 156,
                    "id_product_image": 676,
                    "alt_text_small": "",
                    "product_image_key": "product_image_676",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/D041945W?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/D041945W",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 676,
                    "sort_order": 33,
                    "alt_text_large": "",
                    "fk_product_image": 676
                }
            ],
            "id_product_labels": [],
            "price": 292,
            "abstract_name": "Post-it adhesive stripes index, standard 25.4x43.2 mm 50 sheets PES",
            "id_product_abstract": 77,
            "type": "product_abstract",
            "add_to_cart_sku": "420514",
            "prices": {
                "DEFAULT": 292
            },
            "abstract_sku": "M21066",
            "url": "\/en\/post-it-haftstreifen-index-standard-25-4x43-2mm-50blatt-pes-M21066"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 158,
                    "id_product_image": 678,
                    "alt_text_small": "",
                    "product_image_key": "product_image_678",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006124M?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006124M",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 678,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 678
                },
                {
                    "fk_product_image_set": 158,
                    "id_product_image": 680,
                    "alt_text_small": "",
                    "product_image_key": "product_image_680",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/D041586P?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/D041586P",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 680,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 680
                }
            ],
            "id_product_labels": [],
            "price": 337,
            "abstract_name": "Post-it adhesive stripes Index Symbol 680-31 25.4x43.2 mm 50 sheets, yellow",
            "id_product_abstract": 78,
            "type": "product_abstract",
            "add_to_cart_sku": "420520",
            "prices": {
                "DEFAULT": 337
            },
            "abstract_sku": "M21067",
            "url": "\/en\/post-it-haftstreifen-index-symbol-680-31-25-4x43-2mm-50blatt-gelb-M21067"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 160,
                    "id_product_image": 682,
                    "alt_text_small": "",
                    "product_image_key": "product_image_682",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006839T?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006839T",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 682,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 682
                },
                {
                    "fk_product_image_set": 160,
                    "id_product_image": 684,
                    "alt_text_small": "",
                    "product_image_key": "product_image_684",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006839S?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006839S",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 684,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 684
                }
            ],
            "id_product_labels": [],
            "price": 665,
            "abstract_name": "Post-it Index Strong adhesive stripes, 22 sheets, sorted, 3 pieces\/pack",
            "id_product_abstract": 79,
            "type": "product_abstract",
            "add_to_cart_sku": "420527",
            "prices": {
                "DEFAULT": 665
            },
            "abstract_sku": "M21073",
            "url": "\/en\/post-it-haftstreifen-index-strong-22blatt-sortiert-3-st-pack-M21073"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 172,
                    "id_product_image": 710,
                    "alt_text_small": "",
                    "product_image_key": "product_image_710",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006823S?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006823S",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 710,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 710
                },
                {
                    "fk_product_image_set": 172,
                    "id_product_image": 712,
                    "alt_text_small": "",
                    "product_image_key": "product_image_712",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007836G?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007836G",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 712,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 712
                },
                {
                    "fk_product_image_set": 172,
                    "id_product_image": 714,
                    "alt_text_small": "",
                    "product_image_key": "product_image_714",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007836H?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007836H",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 714,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 714
                }
            ],
            "id_product_labels": [],
            "price": 2319,
            "abstract_name": "Verbatim USB stick pin stripe, black",
            "id_product_abstract": 85,
            "type": "product_abstract",
            "add_to_cart_sku": "420562",
            "prices": {
                "DEFAULT": 2319
            },
            "abstract_sku": "M21097",
            "url": "\/en\/verbatim-usb-stick-pin-stripe-schwarz-M21097"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 174,
                    "id_product_image": 716,
                    "alt_text_small": "",
                    "product_image_key": "product_image_716",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007049T?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007049T",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 716,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 716
                },
                {
                    "fk_product_image_set": 174,
                    "id_product_image": 718,
                    "alt_text_small": "",
                    "product_image_key": "product_image_718",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007049Y?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007049Y",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 718,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 718
                },
                {
                    "fk_product_image_set": 174,
                    "id_product_image": 720,
                    "alt_text_small": "",
                    "product_image_key": "product_image_720",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007050E?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007050E",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 720,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 720
                }
            ],
            "id_product_labels": [],
            "price": 992,
            "abstract_name": "Verbatim USB stick Store n Go V3 49172 16GB USB3.0, gray",
            "id_product_abstract": 86,
            "type": "product_abstract",
            "add_to_cart_sku": "420565",
            "prices": {
                "DEFAULT": 992
            },
            "abstract_sku": "M21099",
            "url": "\/en\/verbatim-usb-stick-store-n-go-v3-49172-16gb-usb3-0-grau-M21099"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 182,
                    "id_product_image": 732,
                    "alt_text_small": "",
                    "product_image_key": "product_image_732",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006669O?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006669O",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 732,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 732
                },
                {
                    "fk_product_image_set": 182,
                    "id_product_image": 734,
                    "alt_text_small": "",
                    "product_image_key": "product_image_734",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006809U?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006809U",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 734,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 734
                },
                {
                    "fk_product_image_set": 182,
                    "id_product_image": 736,
                    "alt_text_small": "",
                    "product_image_key": "product_image_736",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007836I?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007836I",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 736,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 736
                }
            ],
            "id_product_labels": [],
            "price": 9091,
            "abstract_name": "Verbatim USB hard disk Store n Go 53071 1TB USB3.0 silver",
            "id_product_abstract": 90,
            "type": "product_abstract",
            "add_to_cart_sku": "420574",
            "prices": {
                "DEFAULT": 9091
            },
            "abstract_sku": "M21104",
            "url": "\/en\/verbatim-festplatte-store-n-go-53071-1tb-usb3-0-silber-M21104"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 186,
                    "id_product_image": 740,
                    "alt_text_small": "",
                    "product_image_key": "product_image_740",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006858X?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006858X",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 740,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 740
                },
                {
                    "fk_product_image_set": 186,
                    "id_product_image": 742,
                    "alt_text_small": "",
                    "product_image_key": "product_image_742",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006858W?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006858W",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 742,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 742
                }
            ],
            "id_product_labels": [],
            "price": 789,
            "abstract_name": "Post-it sticky note Super Sticky Meeting Notes 4 pieces\/pack",
            "id_product_abstract": 92,
            "type": "product_abstract",
            "prices": {
                "DEFAULT": 789
            },
            "abstract_sku": "M21189",
            "url": "\/en\/post-it-haftnotiz-super-sticky-meeting-notes-4-st-pack-M21189"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 190,
                    "id_product_image": 746,
                    "alt_text_small": "",
                    "product_image_key": "product_image_746",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/D041942Q?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/D041942Q",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 746,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 746
                },
                {
                    "fk_product_image_set": 190,
                    "id_product_image": 748,
                    "alt_text_small": "",
                    "product_image_key": "product_image_748",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/D041213V?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/D041213V",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 748,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 748
                }
            ],
            "id_product_labels": [],
            "price": 363,
            "abstract_name": "Post-it Index Standard adhesive stripes, 20 sheets, colored, 3 pieces\/pack",
            "id_product_abstract": 94,
            "type": "product_abstract",
            "add_to_cart_sku": "420689",
            "prices": {
                "DEFAULT": 363
            },
            "abstract_sku": "M21191",
            "url": "\/en\/post-it-haftstreifen-index-standard-20blatt-farbig-3-st-pack-M21191"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 192,
                    "id_product_image": 750,
                    "alt_text_small": "",
                    "product_image_key": "product_image_750",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006125Y?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006125Y",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 750,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 750
                }
            ],
            "id_product_labels": [],
            "price": 876,
            "abstract_name": "Post-it Index Mini Promotion adhesive stripes 683-VAD1 colored +2 684",
            "id_product_abstract": 95,
            "type": "product_abstract",
            "add_to_cart_sku": "420691",
            "prices": {
                "DEFAULT": 876
            },
            "abstract_sku": "M21193",
            "url": "\/en\/post-it-heftstreifen-index-mini-promotion-683-vad1-farbig-2-684-M21193"
        }
    ],
    "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": []
}
{}