https://oalp.xiphias-digital.com/DE/en/search?page=20

Elasticsearch Search Requests

Destination Payload Result
Http://search:9200
{
    "query": {
        "query": {
            "bool": {
                "must": [
                    {
                        "match_all": {}
                    },
                    {
                        "match": {
                            "type": "product_abstract"
                        }
                    },
                    {
                        "match": {
                            "store": "DE"
                        }
                    },
                    {
                        "match": {
                            "locale": "en_US"
                        }
                    },
                    {
                        "match": {
                            "is-active": true
                        }
                    },
                    {
                        "bool": {
                            "should": [
                                {
                                    "range": {
                                        "active-from": {
                                            "lte": "now"
                                        }
                                    }
                                },
                                {
                                    "bool": {
                                        "must_not": [
                                            {
                                                "exists": {
                                                    "field": "active-from"
                                                }
                                            }
                                        ]
                                    }
                                }
                            ]
                        }
                    },
                    {
                        "bool": {
                            "should": [
                                {
                                    "range": {
                                        "active-to": {
                                            "gte": "now"
                                        }
                                    }
                                },
                                {
                                    "bool": {
                                        "must_not": [
                                            {
                                                "exists": {
                                                    "field": "active-to"
                                                }
                                            }
                                        ]
                                    }
                                }
                            ]
                        }
                    }
                ],
                "filter": [
                    {
                        "nested": {
                            "query": {
                                "term": {
                                    "integer-facet.facet-name": {
                                        "value": "price-DEFAULT-EUR-GROSS_MODE",
                                        "boost": 1
                                    }
                                }
                            },
                            "path": "integer-facet"
                        }
                    }
                ]
            }
        },
        "suggest": {
            "text": ""
        },
        "_source": [
            "search-result-data"
        ],
        "from": 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
                                }
                            }
                        }
                    }
                }
            }
        }
    },
    "parameters": {
        "page": "20"
    }
}
{
    "facets": {
        "category": {},
        "rating": {},
        "label": {},
        "farbe": {},
        "material": {},
        "brand": {},
        "merchant_name": {}
    },
    "sort": {},
    "pagination": {},
    "products": [
        {
            "images": [
                {
                    "fk_product_image_set": 200,
                    "id_product_image": 776,
                    "alt_text_small": "",
                    "product_image_key": "product_image_776",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007357V?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007357V",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 776,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 776
                },
                {
                    "fk_product_image_set": 200,
                    "id_product_image": 778,
                    "alt_text_small": "",
                    "product_image_key": "product_image_778",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007644T?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007644T",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 778,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 778
                }
            ],
            "id_product_labels": [],
            "price": 1231,
            "abstract_name": "Post-it stick note Super Sticky, 62212SE sorted 12 pieces\/pack.",
            "id_product_abstract": 99,
            "type": "product_abstract",
            "add_to_cart_sku": "420696",
            "prices": {
                "DEFAULT": 1231
            },
            "abstract_sku": "M21197",
            "url": "\/en\/post-it-haftnotiz-super-sticky-62212se-sortiert-12-st-pack-M21197"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 780,
                    "alt_text_small": "",
                    "product_image_key": "product_image_780",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006289M?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006289M",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 780,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 780
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 782,
                    "alt_text_small": "",
                    "product_image_key": "product_image_782",
                    "updated_at": "2025-12-02 09:55:13.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:13.000000",
                    "id_product_image_set_to_product_image": 782,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 782
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 784,
                    "alt_text_small": "",
                    "product_image_key": "product_image_784",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007553X?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007553X",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 784,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 784
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 786,
                    "alt_text_small": "",
                    "product_image_key": "product_image_786",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006289L?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006289L",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 786,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 786
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 788,
                    "alt_text_small": "",
                    "product_image_key": "product_image_788",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007554C?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007554C",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 788,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 788
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 790,
                    "alt_text_small": "",
                    "product_image_key": "product_image_790",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006289K?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006289K",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 790,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 790
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 792,
                    "alt_text_small": "",
                    "product_image_key": "product_image_792",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007553Z?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007553Z",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 792,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 792
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 794,
                    "alt_text_small": "",
                    "product_image_key": "product_image_794",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007554M?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007554M",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 794,
                    "sort_order": 15,
                    "alt_text_large": "",
                    "fk_product_image": 794
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 796,
                    "alt_text_small": "",
                    "product_image_key": "product_image_796",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006289I?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006289I",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 796,
                    "sort_order": 17,
                    "alt_text_large": "",
                    "fk_product_image": 796
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 798,
                    "alt_text_small": "",
                    "product_image_key": "product_image_798",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007554B?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007554B",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 798,
                    "sort_order": 19,
                    "alt_text_large": "",
                    "fk_product_image": 798
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 800,
                    "alt_text_small": "",
                    "product_image_key": "product_image_800",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006289H?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006289H",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 800,
                    "sort_order": 21,
                    "alt_text_large": "",
                    "fk_product_image": 800
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 802,
                    "alt_text_small": "",
                    "product_image_key": "product_image_802",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007553Y?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007553Y",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 802,
                    "sort_order": 23,
                    "alt_text_large": "",
                    "fk_product_image": 802
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 804,
                    "alt_text_small": "",
                    "product_image_key": "product_image_804",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006291E?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006291E",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 804,
                    "sort_order": 25,
                    "alt_text_large": "",
                    "fk_product_image": 804
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 806,
                    "alt_text_small": "",
                    "product_image_key": "product_image_806",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007554Y?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007554Y",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 806,
                    "sort_order": 27,
                    "alt_text_large": "",
                    "fk_product_image": 806
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 808,
                    "alt_text_small": "",
                    "product_image_key": "product_image_808",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006289N?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006289N",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 808,
                    "sort_order": 29,
                    "alt_text_large": "",
                    "fk_product_image": 808
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 810,
                    "alt_text_small": "",
                    "product_image_key": "product_image_810",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007554A?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007554A",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 810,
                    "sort_order": 31,
                    "alt_text_large": "",
                    "fk_product_image": 810
                }
            ],
            "id_product_labels": [],
            "price": 432,
            "abstract_name": "Post-it Index 2 adhesive stripes",
            "id_product_abstract": 100,
            "type": "product_abstract",
            "add_to_cart_sku": "420706",
            "prices": {
                "DEFAULT": 432
            },
            "abstract_sku": "M21200",
            "url": "\/en\/post-it-haftstreifen-index-2-M21200"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 204,
                    "id_product_image": 812,
                    "alt_text_small": "",
                    "product_image_key": "product_image_812",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007081Q?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007081Q",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 812,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 812
                }
            ],
            "id_product_labels": [],
            "price": 422,
            "abstract_name": "Post-it Index Strong adhesive stripes, 686-PLOY 6 sheets sorted, 4 pieces\/pack",
            "id_product_abstract": 101,
            "type": "product_abstract",
            "add_to_cart_sku": "420707",
            "prices": {
                "DEFAULT": 422
            },
            "abstract_sku": "M21201",
            "url": "\/en\/post-it-haftstreifen-index-strong-686-ploy-6blatt-sortiert-4-st-pack-M21201"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 206,
                    "id_product_image": 814,
                    "alt_text_small": "",
                    "product_image_key": "product_image_814",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007686U?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007686U",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 814,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 814
                }
            ],
            "id_product_labels": [],
            "price": 1043,
            "abstract_name": "Post-it Z-Notes adhesive notes R3306SJ 76x76 mm, 90 sheets, red\/green\/blue, 6 pieces\/pack.",
            "id_product_abstract": 102,
            "type": "product_abstract",
            "add_to_cart_sku": "420708",
            "prices": {
                "DEFAULT": 1043
            },
            "abstract_sku": "M21202",
            "url": "\/en\/post-it-haftnotiz-z-notes-r3306sj-76x76mm-90bl-rt-gn-bl-6-st-pack-M21202"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 208,
                    "id_product_image": 816,
                    "alt_text_small": "",
                    "product_image_key": "product_image_816",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007353S?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007353S",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 816,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 816
                },
                {
                    "fk_product_image_set": 208,
                    "id_product_image": 818,
                    "alt_text_small": "",
                    "product_image_key": "product_image_818",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007631M?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007631M",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 818,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 818
                },
                {
                    "fk_product_image_set": 208,
                    "id_product_image": 820,
                    "alt_text_small": "",
                    "product_image_key": "product_image_820",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007644D?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007644D",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 820,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 820
                }
            ],
            "id_product_labels": [],
            "price": 1043,
            "abstract_name": "Post-it Super Sticky adhesive notes, Bangkok Collection R3306SE 6 pieces\/pack.",
            "id_product_abstract": 103,
            "type": "product_abstract",
            "add_to_cart_sku": "420709",
            "prices": {
                "DEFAULT": 1043
            },
            "abstract_sku": "M21203",
            "url": "\/en\/post-it-haftnotiz-super-sticky-bangkok-coll-r3306se-6-st-pack-M21203"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 210,
                    "id_product_image": 822,
                    "alt_text_small": "",
                    "product_image_key": "product_image_822",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007736O?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007736O",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 822,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 822
                },
                {
                    "fk_product_image_set": 210,
                    "id_product_image": 824,
                    "alt_text_small": "",
                    "product_image_key": "product_image_824",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007736P?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007736P",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 824,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 824
                }
            ],
            "id_product_labels": [],
            "price": 245,
            "abstract_name": "Post-it adhesive note Super Sticky 6910YPOG 48x48 mm sorted. 4 pieces\/pack.",
            "id_product_abstract": 104,
            "type": "product_abstract",
            "add_to_cart_sku": "420712",
            "prices": {
                "DEFAULT": 245
            },
            "abstract_sku": "M21205",
            "url": "\/en\/post-it-haftnotiz-super-sticky-6910ypog-48x48mm-sort-4-st-pack-M21205"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 212,
                    "id_product_image": 826,
                    "alt_text_small": "",
                    "product_image_key": "product_image_826",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007787W?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007787W",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 826,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 826
                },
                {
                    "fk_product_image_set": 212,
                    "id_product_image": 828,
                    "alt_text_small": "",
                    "product_image_key": "product_image_828",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007787R?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007787R",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 828,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 828
                },
                {
                    "fk_product_image_set": 212,
                    "id_product_image": 830,
                    "alt_text_small": "",
                    "product_image_key": "product_image_830",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007787Q?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007787Q",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 830,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 830
                }
            ],
            "id_product_labels": [],
            "price": 1182,
            "abstract_name": "SanDisk SDHC storage card",
            "id_product_abstract": 105,
            "type": "product_abstract",
            "add_to_cart_sku": "420836",
            "prices": {
                "DEFAULT": 1182
            },
            "abstract_sku": "M21296",
            "url": "\/en\/sandisk-speicherkarte-sdhc-M21296"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 214,
                    "id_product_image": 832,
                    "alt_text_small": "",
                    "product_image_key": "product_image_832",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007435Y?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007435Y",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 832,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 832
                }
            ],
            "id_product_labels": [],
            "price": 3647,
            "abstract_name": "SanDisk USB stick Ultra USB3.0 black",
            "id_product_abstract": 106,
            "type": "product_abstract",
            "add_to_cart_sku": "420845",
            "prices": {
                "DEFAULT": 3647
            },
            "abstract_sku": "M21299",
            "url": "\/en\/sandisk-usb-stick-ultra-usb3-0-sw-M21299"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 216,
                    "id_product_image": 834,
                    "alt_text_small": "",
                    "product_image_key": "product_image_834",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046296F-03?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046296F-03",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 834,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 834
                },
                {
                    "fk_product_image_set": 216,
                    "id_product_image": 836,
                    "alt_text_small": "",
                    "product_image_key": "product_image_836",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00704087FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00704087FF-01",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 836,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 836
                },
                {
                    "fk_product_image_set": 216,
                    "id_product_image": 838,
                    "alt_text_small": "",
                    "product_image_key": "product_image_838",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00905994FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00905994FF-01",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 838,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 838
                },
                {
                    "fk_product_image_set": 216,
                    "id_product_image": 840,
                    "alt_text_small": "",
                    "product_image_key": "product_image_840",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00519688FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00519688FF-01",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 840,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 840
                },
                {
                    "fk_product_image_set": 216,
                    "id_product_image": 842,
                    "alt_text_small": "",
                    "product_image_key": "product_image_842",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00519737FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00519737FF-01",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 842,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 842
                },
                {
                    "fk_product_image_set": 216,
                    "id_product_image": 844,
                    "alt_text_small": "",
                    "product_image_key": "product_image_844",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046295-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046295-01",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 844,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 844
                },
                {
                    "fk_product_image_set": 216,
                    "id_product_image": 846,
                    "alt_text_small": "",
                    "product_image_key": "product_image_846",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK91863-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK91863-01",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 846,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 846
                }
            ],
            "id_product_labels": [],
            "price": 28488,
            "abstract_name": "Mauser steel cabinet with swing doors - 4 shelves, T 420 mm",
            "id_product_abstract": 107,
            "type": "product_abstract",
            "add_to_cart_sku": "107305",
            "prices": {
                "DEFAULT": 28488
            },
            "abstract_sku": "M213",
            "url": "\/en\/mauser-stahlschrank-mit-fluegeltueren-4-fachboeden-t-420-mm-M213"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 218,
                    "id_product_image": 848,
                    "alt_text_small": "",
                    "product_image_key": "product_image_848",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007846R?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007846R",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 848,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 848
                }
            ],
            "id_product_labels": [],
            "price": 1428,
            "abstract_name": "Oxford Collegeblock International Organizerbook 100102777, checkered",
            "id_product_abstract": 108,
            "type": "product_abstract",
            "add_to_cart_sku": "421245",
            "prices": {
                "DEFAULT": 1428
            },
            "abstract_sku": "M21635",
            "url": "\/en\/oxford-collegeblock-international-organizerbook-100102777-kariert-M21635"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 220,
                    "id_product_image": 850,
                    "alt_text_small": "",
                    "product_image_key": "product_image_850",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007846M?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007846M",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 850,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 850
                },
                {
                    "fk_product_image_set": 220,
                    "id_product_image": 852,
                    "alt_text_small": "",
                    "product_image_key": "product_image_852",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007849W?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007849W",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 852,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 852
                },
                {
                    "fk_product_image_set": 220,
                    "id_product_image": 854,
                    "alt_text_small": "",
                    "product_image_key": "product_image_854",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007849X?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007849X",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 854,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 854
                },
                {
                    "fk_product_image_set": 220,
                    "id_product_image": 856,
                    "alt_text_small": "",
                    "product_image_key": "product_image_856",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007849Y?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007849Y",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 856,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 856
                }
            ],
            "id_product_labels": [],
            "price": 995,
            "abstract_name": "Oxford notebook 100100570 DIN A4 checkered, 96 sheets, sorted",
            "id_product_abstract": 109,
            "type": "product_abstract",
            "add_to_cart_sku": "421246",
            "prices": {
                "DEFAULT": 995
            },
            "abstract_sku": "M21636",
            "url": "\/en\/oxford-kladde-100100570-din-a4-kariert-96blatt-sortiert-M21636"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 222,
                    "id_product_image": 858,
                    "alt_text_small": "",
                    "product_image_key": "product_image_858",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845X?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845X",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 858,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 858
                },
                {
                    "fk_product_image_set": 222,
                    "id_product_image": 860,
                    "alt_text_small": "",
                    "product_image_key": "product_image_860",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845Y?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845Y",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 860,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 860
                },
                {
                    "fk_product_image_set": 222,
                    "id_product_image": 862,
                    "alt_text_small": "",
                    "product_image_key": "product_image_862",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845Z?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845Z",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 862,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 862
                },
                {
                    "fk_product_image_set": 222,
                    "id_product_image": 864,
                    "alt_text_small": "",
                    "product_image_key": "product_image_864",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007846A?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007846A",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 864,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 864
                },
                {
                    "fk_product_image_set": 222,
                    "id_product_image": 866,
                    "alt_text_small": "",
                    "product_image_key": "product_image_866",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007846B?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007846B",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 866,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 866
                },
                {
                    "fk_product_image_set": 222,
                    "id_product_image": 868,
                    "alt_text_small": "",
                    "product_image_key": "product_image_868",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007846C?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007846C",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 868,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 868
                }
            ],
            "id_product_labels": [],
            "price": 560,
            "abstract_name": "Oxford Collegeblock 100104341 DIN A5, checkered, 90 sheets",
            "id_product_abstract": 110,
            "type": "product_abstract",
            "add_to_cart_sku": "421247",
            "prices": {
                "DEFAULT": 560
            },
            "abstract_sku": "M21637",
            "url": "\/en\/oxford-collegeblock-100104341-din-a5-kariert-90blatt-M21637"
        }
    ],
    "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": []
}
{}