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

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": 384,
        "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": "33"
    }
}
{
    "facets": {
        "category": {},
        "rating": {},
        "label": {},
        "farbe": {},
        "material": {},
        "brand": {},
        "merchant_name": {}
    },
    "sort": {},
    "pagination": {},
    "products": [
        {
            "images": [
                {
                    "fk_product_image_set": 830,
                    "id_product_image": 3204,
                    "alt_text_small": "",
                    "product_image_key": "product_image_3204",
                    "updated_at": "2025-12-02 09:55:28.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007410Q?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007410Q",
                    "created_at": "2025-12-02 09:55:28.000000",
                    "id_product_image_set_to_product_image": 3204,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 3204
                }
            ],
            "id_product_labels": [
                4,
                5
            ],
            "price": 103,
            "abstract_name": "Soennecken permanent marker 4 mm round tip",
            "rating": 3.5,
            "id_product_abstract": 166,
            "review_count": 4,
            "type": "product_abstract",
            "add_to_cart_sku": "423175",
            "prices": {
                "DEFAULT": 103,
                "ORIGINAL": 114
            },
            "abstract_sku": "M22663",
            "url": "\/en\/soennecken-permanentmarker-4mm-rundspitze-M22663"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 324,
                    "id_product_image": 1110,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1110",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006288W?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006288W",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1110,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1110
                },
                {
                    "fk_product_image_set": 324,
                    "id_product_image": 1112,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1112",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007360K?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007360K",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1112,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1112
                },
                {
                    "fk_product_image_set": 324,
                    "id_product_image": 1114,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1114",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007360L?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007360L",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1114,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 1114
                }
            ],
            "id_product_labels": [
                4,
                5
            ],
            "price": 110,
            "abstract_name": "Soennecken mechanical pencil   HB with eraser, black",
            "rating": 4,
            "id_product_abstract": 169,
            "review_count": 6,
            "type": "product_abstract",
            "add_to_cart_sku": "423452",
            "prices": {
                "DEFAULT": 110,
                "ORIGINAL": 122
            },
            "abstract_sku": "M22796",
            "url": "\/en\/soennecken-druckbleistift-hb-mit-radierer-schwarz-M22796"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 452,
                    "id_product_image": 1532,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1532",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007074R?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007074R",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1532,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1532
                }
            ],
            "id_product_labels": [
                4,
                5
            ],
            "price": 19099,
            "abstract_name": "Franken Flipchart Mobile Deluxe FC81 67x95 cm, round foot, light gray",
            "rating": 4,
            "id_product_abstract": 237,
            "review_count": 6,
            "type": "product_abstract",
            "add_to_cart_sku": "426378",
            "prices": {
                "DEFAULT": 19099,
                "ORIGINAL": 21221
            },
            "abstract_sku": "M24418",
            "url": "\/en\/franken-flipchart-mobile-deluxe-fc81-67x95cm-rundfuss-hellgrau-M24418"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 456,
                    "id_product_image": 1538,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1538",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007387M?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007387M",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1538,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1538
                }
            ],
            "id_product_labels": [
                4,
                5
            ],
            "price": 4196,
            "abstract_name": "Cherry keyboard Strait JK-0300DE metal-look, corded, USB, silver",
            "rating": 4,
            "id_product_abstract": 239,
            "review_count": 3,
            "type": "product_abstract",
            "add_to_cart_sku": "426581",
            "prices": {
                "DEFAULT": 4196,
                "ORIGINAL": 4662
            },
            "abstract_sku": "M24605",
            "url": "\/en\/cherry-tastatur-strait-jk-0300de-metall-look-schnurgebunden-usb-si-M24605"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 470,
                    "id_product_image": 1556,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1556",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006929Q?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006929Q",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1556,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1556
                },
                {
                    "fk_product_image_set": 470,
                    "id_product_image": 1558,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1558",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007970P?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007970P",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1558,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1558
                },
                {
                    "fk_product_image_set": 470,
                    "id_product_image": 1560,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1560",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007970Q?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007970Q",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1560,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 1560
                }
            ],
            "id_product_labels": [
                4
            ],
            "price": 1195,
            "abstract_name": "HSM waste sack 1661995150 28l 348x195x800 mm tr 10 pieces\/pack.",
            "rating": 4.25,
            "id_product_abstract": 246,
            "review_count": 4,
            "type": "product_abstract",
            "add_to_cart_sku": "426620",
            "prices": {
                "DEFAULT": 1195
            },
            "abstract_sku": "M24637",
            "url": "\/en\/hsm-abfallsack-1661995150-28l-348x195x800mm-tr-10-st-pack-M24637"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 494,
                    "id_product_image": 1592,
                    "alt_text_small": "View details of Gm\u00f6hling aluminum data disposal container",
                    "product_image_key": "product_image_1592",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124082II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124082II-01",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1592,
                    "sort_order": 1,
                    "alt_text_large": "Front view of Gm\u00f6hling aluminum data disposal container - Exterior - LxWxH 575 x 690 x 1010 mm, with feeder slit",
                    "fk_product_image": 1592
                },
                {
                    "fk_product_image_set": 494,
                    "id_product_image": 1594,
                    "alt_text_small": "View details of Gm\u00f6hling aluminum data disposal container",
                    "product_image_key": "product_image_1594",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124082II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124082II-02",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1594,
                    "sort_order": 3,
                    "alt_text_large": "Back view of Gm\u00f6hling aluminum data disposal container - Exterior - LxWxH 575 x 690 x 1010 mm, with feeder slits",
                    "fk_product_image": 1594
                }
            ],
            "id_product_labels": [
                4,
                5
            ],
            "price": 34293,
            "abstract_name": "Gm\u00f6hling aluminum data removal container - Exterior - LxWxH 575 x 690 x 1010 mm",
            "rating": 4,
            "id_product_abstract": 258,
            "review_count": 5,
            "type": "product_abstract",
            "add_to_cart_sku": "419780",
            "prices": {
                "DEFAULT": 34293,
                "ORIGINAL": 38103
            },
            "abstract_sku": "M29455",
            "url": "\/en\/alu-datenentsorgungsbehaelter-aussen-lxbxh-575-x-690-x-1010-mm-M29455"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 526,
                    "id_product_image": 1662,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1662",
                    "updated_at": "2025-12-02 09:55:19.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000023448812_PRD_org_all?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000023448812_PRD_org_all",
                    "created_at": "2025-12-02 09:55:19.000000",
                    "id_product_image_set_to_product_image": 1662,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1662
                },
                {
                    "fk_product_image_set": 526,
                    "id_product_image": 1664,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1664",
                    "updated_at": "2025-12-02 09:55:19.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000023448813_PRD_org_all?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000023448813_PRD_org_all",
                    "created_at": "2025-12-02 09:55:19.000000",
                    "id_product_image_set_to_product_image": 1664,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1664
                }
            ],
            "id_product_labels": [
                4
            ],
            "price": 1112479,
            "abstract_name": "HSM conveyor belt document shredder, POWERLINE FA 400.2 - collecting volume 460 l, particle cut",
            "rating": 4,
            "id_product_abstract": 274,
            "review_count": 3,
            "type": "product_abstract",
            "add_to_cart_sku": "621613",
            "prices": {
                "DEFAULT": 1112479
            },
            "abstract_sku": "M29930",
            "url": "\/en\/hsm-foerderband-aktenvernichter-powerline-fa-400-2-auffangvolumen-460-l-partikelschnitt-M29930"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 532,
                    "id_product_image": 1674,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1674",
                    "updated_at": "2025-12-02 09:55:19.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052674-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052674-01",
                    "created_at": "2025-12-02 09:55:19.000000",
                    "id_product_image_set_to_product_image": 1674,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1674
                },
                {
                    "fk_product_image_set": 532,
                    "id_product_image": 1676,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1676",
                    "updated_at": "2025-12-02 09:55:19.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00926273II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00926273II-01",
                    "created_at": "2025-12-02 09:55:19.000000",
                    "id_product_image_set_to_product_image": 1676,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1676
                },
                {
                    "fk_product_image_set": 532,
                    "id_product_image": 1678,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1678",
                    "updated_at": "2025-12-02 09:55:19.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052674-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052674-02",
                    "created_at": "2025-12-02 09:55:19.000000",
                    "id_product_image_set_to_product_image": 1678,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 1678
                }
            ],
            "id_product_labels": [
                5
            ],
            "price": 8364,
            "abstract_name": "Smit visual flip chart - height-adjustable with telescope legs",
            "id_product_abstract": 277,
            "type": "product_abstract",
            "add_to_cart_sku": "100429",
            "prices": {
                "DEFAULT": 8364,
                "ORIGINAL": 9293
            },
            "abstract_sku": "M39654",
            "url": "\/en\/flip-chart-hoehenverstellbar-mit-teleskopbeinen-M39654"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 600,
                    "id_product_image": 2040,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2040",
                    "updated_at": "2025-12-02 09:55:21.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035949-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035949-01",
                    "created_at": "2025-12-02 09:55:21.000000",
                    "id_product_image_set_to_product_image": 2040,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 2040
                },
                {
                    "fk_product_image_set": 600,
                    "id_product_image": 2042,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2042",
                    "updated_at": "2025-12-02 09:55:21.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035950-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035950-01",
                    "created_at": "2025-12-02 09:55:21.000000",
                    "id_product_image_set_to_product_image": 2042,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 2042
                },
                {
                    "fk_product_image_set": 600,
                    "id_product_image": 2044,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2044",
                    "updated_at": "2025-12-02 09:55:21.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035947-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035947-01",
                    "created_at": "2025-12-02 09:55:21.000000",
                    "id_product_image_set_to_product_image": 2044,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 2044
                },
                {
                    "fk_product_image_set": 600,
                    "id_product_image": 2046,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2046",
                    "updated_at": "2025-12-02 09:55:21.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035948-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035948-01",
                    "created_at": "2025-12-02 09:55:21.000000",
                    "id_product_image_set_to_product_image": 2046,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 2046
                }
            ],
            "id_product_labels": [
                5
            ],
            "price": 18279,
            "abstract_name": "office active vertebral disc swivel chair, backrest height 520 mm - point-synchronous mechanism",
            "id_product_abstract": 313,
            "type": "product_abstract",
            "add_to_cart_sku": "102177",
            "prices": {
                "DEFAULT": 18279,
                "ORIGINAL": 20310
            },
            "abstract_sku": "M58095",
            "url": "\/en\/office-akktiv-bandscheiben-drehstuhl-rueckenlehnenhoehe-520-mm-punktsynchron-mechanik-M58095"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 642,
                    "id_product_image": 2272,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2272",
                    "updated_at": "2025-12-02 09:55:22.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00037388-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00037388-01",
                    "created_at": "2025-12-02 09:55:22.000000",
                    "id_product_image_set_to_product_image": 2272,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 2272
                },
                {
                    "fk_product_image_set": 642,
                    "id_product_image": 2274,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2274",
                    "updated_at": "2025-12-02 09:55:22.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00037389-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00037389-01",
                    "created_at": "2025-12-02 09:55:22.000000",
                    "id_product_image_set_to_product_image": 2274,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 2274
                }
            ],
            "id_product_labels": [
                4
            ],
            "price": 19973,
            "abstract_name": "QUIPO universal cabinet - HxWxD 1950 x 915 x 421 mm",
            "id_product_abstract": 334,
            "type": "product_abstract",
            "add_to_cart_sku": "102841",
            "prices": {
                "DEFAULT": 19973
            },
            "abstract_sku": "M62584",
            "url": "\/en\/quipo-universalschrank-hxbxt-1950-x-915-x-421-mm-M62584"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 706,
                    "id_product_image": 2594,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2594",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052621-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052621-01",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2594,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 2594
                },
                {
                    "fk_product_image_set": 706,
                    "id_product_image": 2596,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2596",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610297FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610297FF-01",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2596,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 2596
                }
            ],
            "id_product_labels": [
                5
            ],
            "price": 39292,
            "abstract_name": "HSM SECURIO document shredder - for multi-person office,34 l",
            "id_product_abstract": 366,
            "type": "product_abstract",
            "add_to_cart_sku": "101863",
            "prices": {
                "DEFAULT": 39292,
                "ORIGINAL": 43657
            },
            "abstract_sku": "M74972",
            "url": "\/en\/hsm-aktenvernichter-securio-fuer-mehrpersonen-buero-34-l-M74972"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 712,
                    "id_product_image": 2610,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2610",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00980616FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00980616FF-01",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2610,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 2610
                },
                {
                    "fk_product_image_set": 712,
                    "id_product_image": 2612,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2612",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00048288-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00048288-01",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2612,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 2612
                }
            ],
            "id_product_labels": [
                5
            ],
            "price": 15444,
            "abstract_name": "HSM CLASSIC document shredder - HxWxD 423 x 326 x 240 mm",
            "id_product_abstract": 369,
            "type": "product_abstract",
            "add_to_cart_sku": "100683",
            "prices": {
                "DEFAULT": 15444,
                "ORIGINAL": 17160
            },
            "abstract_sku": "M75601",
            "url": "\/en\/hsm-aktenvernichter-classic-hxbxt-423-x-326-x-240-mm-M75601"
        }
    ],
    "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": []
}
{}