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

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": 396,
        "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": "34"
    }
}
{
    "facets": {
        "category": {},
        "rating": {},
        "label": {},
        "farbe": {},
        "material": {},
        "brand": {},
        "merchant_name": {}
    },
    "sort": {},
    "pagination": {},
    "products": [
        {
            "images": [
                {
                    "fk_product_image_set": 12,
                    "id_product_image": 30,
                    "alt_text_small": "",
                    "product_image_key": "product_image_30",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00048297-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00048297-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 30,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 30
                },
                {
                    "fk_product_image_set": 12,
                    "id_product_image": 32,
                    "alt_text_small": "",
                    "product_image_key": "product_image_32",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00522213FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00522213FF-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 32,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 32
                },
                {
                    "fk_product_image_set": 12,
                    "id_product_image": 34,
                    "alt_text_small": "",
                    "product_image_key": "product_image_34",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00031340-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00031340-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 34,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 34
                }
            ],
            "id_product_labels": [],
            "price": 12938,
            "abstract_name": "HSM SECURIO document shredder - for open-plan offices, 205 l",
            "id_product_abstract": 6,
            "type": "product_abstract",
            "add_to_cart_sku": "212447",
            "prices": {
                "DEFAULT": 12938
            },
            "abstract_sku": "M1000840",
            "url": "\/en\/hsm-aktenvernichter-securio-fuer-grossraumbuero-205-l-M1000840"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 38,
                    "id_product_image": 128,
                    "alt_text_small": "",
                    "product_image_key": "product_image_128",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049630F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049630F-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 128,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 128
                },
                {
                    "fk_product_image_set": 38,
                    "id_product_image": 130,
                    "alt_text_small": "",
                    "product_image_key": "product_image_130",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049632-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049632-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 130,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 130
                },
                {
                    "fk_product_image_set": 38,
                    "id_product_image": 132,
                    "alt_text_small": "",
                    "product_image_key": "product_image_132",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049631-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049631-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 132,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 132
                }
            ],
            "id_product_labels": [],
            "price": 65755,
            "abstract_name": "Toyota Toyota pallet lift truck from TOYOTA - BT-Lifter with QuickLift hydraulics unit",
            "id_product_abstract": 18,
            "type": "product_abstract",
            "add_to_cart_sku": "464013",
            "prices": {
                "DEFAULT": 65755
            },
            "abstract_sku": "M1014643",
            "url": "\/en\/toyota-paletthubwagen-von-toyota-bt-lifter-mit-quicklift-hydraulikeinheit-M1014643"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 442,
                    "id_product_image": 1522,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1522",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006803J?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006803J",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1522,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1522
                }
            ],
            "id_product_labels": [],
            "price": 1372,
            "abstract_name": "Hama keyboard Basic Keybord K212 00057209 16x2x46 cm USB, black",
            "id_product_abstract": 232,
            "type": "product_abstract",
            "add_to_cart_sku": "425159",
            "prices": {
                "DEFAULT": 1372
            },
            "abstract_sku": "M23777",
            "url": "\/en\/hama-tastatur-basic-keybord-k212-00057209-16x2x46cm-usb-schwarz-M23777"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 582,
                    "id_product_image": 1892,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1892",
                    "updated_at": "2025-12-02 09:55:20.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA01015113FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA01015113FF-01",
                    "created_at": "2025-12-02 09:55:20.000000",
                    "id_product_image_set_to_product_image": 1892,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1892
                },
                {
                    "fk_product_image_set": 582,
                    "id_product_image": 1894,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1894",
                    "updated_at": "2025-12-02 09:55:20.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00034549-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00034549-01",
                    "created_at": "2025-12-02 09:55:20.000000",
                    "id_product_image_set_to_product_image": 1894,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1894
                }
            ],
            "id_product_labels": [
                5
            ],
            "price": 18731,
            "abstract_name": "Padded stacking chair - Seat HxWxD 470 x 450 x 490 mm",
            "id_product_abstract": 304,
            "type": "product_abstract",
            "add_to_cart_sku": "100949",
            "prices": {
                "DEFAULT": 18731,
                "ORIGINAL": 20812
            },
            "abstract_sku": "M53331",
            "url": "\/en\/polsterstapelstuhl-sitz-hxbxt-470-x-450-x-490-mm-M53331"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 36,
                    "id_product_image": 124,
                    "alt_text_small": "",
                    "product_image_key": "product_image_124",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049630F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049630F-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 124,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 124
                },
                {
                    "fk_product_image_set": 36,
                    "id_product_image": 126,
                    "alt_text_small": "",
                    "product_image_key": "product_image_126",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049631-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049631-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 126,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 126
                }
            ],
            "id_product_labels": [],
            "price": 58569,
            "abstract_name": "Toyota Toyota pallet lift truck from TOYOTA - BT-Lifter",
            "id_product_abstract": 17,
            "type": "product_abstract",
            "add_to_cart_sku": "464012",
            "prices": {
                "DEFAULT": 58569
            },
            "abstract_sku": "M1014642",
            "url": "\/en\/toyota-paletthubwagen-von-toyota-bt-lifter-M1014642"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 150,
                    "id_product_image": 608,
                    "alt_text_small": "",
                    "product_image_key": "product_image_608",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052676-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052676-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 608,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 608
                },
                {
                    "fk_product_image_set": 150,
                    "id_product_image": 610,
                    "alt_text_small": "",
                    "product_image_key": "product_image_610",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00757395FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00757395FF-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 610,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 610
                },
                {
                    "fk_product_image_set": 150,
                    "id_product_image": 612,
                    "alt_text_small": "",
                    "product_image_key": "product_image_612",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00757396FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00757396FF-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 612,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 612
                },
                {
                    "fk_product_image_set": 150,
                    "id_product_image": 614,
                    "alt_text_small": "",
                    "product_image_key": "product_image_614",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00053208-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00053208-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 614,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 614
                },
                {
                    "fk_product_image_set": 150,
                    "id_product_image": 616,
                    "alt_text_small": "",
                    "product_image_key": "product_image_616",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052676-03?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052676-03",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 616,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 616
                },
                {
                    "fk_product_image_set": 150,
                    "id_product_image": 618,
                    "alt_text_small": "",
                    "product_image_key": "product_image_618",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00757396II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00757396II-02",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 618,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 618
                },
                {
                    "fk_product_image_set": 150,
                    "id_product_image": 620,
                    "alt_text_small": "",
                    "product_image_key": "product_image_620",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00757396II-03?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00757396II-03",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 620,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 620
                }
            ],
            "id_product_labels": [
                5
            ],
            "price": 25523,
            "abstract_name": "Carto lectern, 2 shelves - Front made of fabric",
            "id_product_abstract": 74,
            "type": "product_abstract",
            "add_to_cart_sku": "101759",
            "prices": {
                "DEFAULT": 25523,
                "ORIGINAL": 28358
            },
            "abstract_sku": "M15226",
            "url": "\/en\/rednerpult-2-ablagen-front-aus-stoff-M15226"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 322,
                    "id_product_image": 1108,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1108",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007395I?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007395I",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1108,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1108
                }
            ],
            "id_product_labels": [],
            "price": 5487,
            "abstract_name": "Soennecken flipchart 1134 68x105 cm tripod gray",
            "id_product_abstract": 168,
            "type": "product_abstract",
            "add_to_cart_sku": "423237",
            "prices": {
                "DEFAULT": 5487
            },
            "abstract_sku": "M22682",
            "url": "\/en\/soennecken-flipchart-1134-68x105cm-dreibeinstativ-grau-M22682"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 478,
                    "id_product_image": 1572,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1572",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006339B?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006339B",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1572,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1572
                }
            ],
            "id_product_labels": [],
            "price": 1770,
            "abstract_name": "Logitech keyboard K120 920-002489 3x18x47 cm USB, black",
            "id_product_abstract": 250,
            "type": "product_abstract",
            "add_to_cart_sku": "427915",
            "prices": {
                "DEFAULT": 1770
            },
            "abstract_sku": "M25600",
            "url": "\/en\/logitech-tastatur-k120-920-002489-3x18x47cm-usb-schwarz-M25600"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 502,
                    "id_product_image": 1602,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1602",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124185II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124185II-01",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1602,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1602
                },
                {
                    "fk_product_image_set": 502,
                    "id_product_image": 1604,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1604",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124185II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124185II-02",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1604,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1604
                }
            ],
            "id_product_labels": [],
            "price": 29039,
            "abstract_name": "Safescan automatic banknote counter - UV counterfeit recognition",
            "id_product_abstract": 262,
            "type": "product_abstract",
            "add_to_cart_sku": "419871",
            "prices": {
                "DEFAULT": 29039
            },
            "abstract_sku": "M29501",
            "url": "\/en\/automatischer-banknotenzaehler-uv-falschgelderkennung-M29501"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 564,
                    "id_product_image": 1816,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1816",
                    "updated_at": "2025-12-02 09:55:20.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051657-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051657-01",
                    "created_at": "2025-12-02 09:55:20.000000",
                    "id_product_image_set_to_product_image": 1816,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1816
                }
            ],
            "id_product_labels": [],
            "price": 18813,
            "abstract_name": "EUROKRAFT aluminum hand truck - Load capacity 200 kg, with skids",
            "id_product_abstract": 292,
            "type": "product_abstract",
            "add_to_cart_sku": "401768",
            "prices": {
                "DEFAULT": 18813
            },
            "abstract_sku": "M5147",
            "url": "\/en\/eurokraft-alu-transportkarre-tragfaehigkeit-200-kg-mit-gleitkufen-M5147"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 10,
                    "id_product_image": 24,
                    "alt_text_small": "",
                    "product_image_key": "product_image_24",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00048296-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00048296-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 24,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 24
                },
                {
                    "fk_product_image_set": 10,
                    "id_product_image": 26,
                    "alt_text_small": "",
                    "product_image_key": "product_image_26",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00522209FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00522209FF-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 26,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 26
                },
                {
                    "fk_product_image_set": 10,
                    "id_product_image": 28,
                    "alt_text_small": "",
                    "product_image_key": "product_image_28",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00031340-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00031340-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 28,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 28
                }
            ],
            "id_product_labels": [
                4
            ],
            "price": 12938,
            "abstract_name": "HSM SECURIO document shredder - for open-plan offices, 145 l, 2100 watts",
            "id_product_abstract": 5,
            "type": "product_abstract",
            "add_to_cart_sku": "212444",
            "prices": {
                "DEFAULT": 12938
            },
            "abstract_sku": "M1000839",
            "url": "\/en\/hsm-aktenvernichter-securio-fuer-grossraumbuero-145-l-2100-watt-M1000839"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 18,
                    "id_product_image": 46,
                    "alt_text_small": "",
                    "product_image_key": "product_image_46",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00048848-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00048848-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 46,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 46
                },
                {
                    "fk_product_image_set": 18,
                    "id_product_image": 48,
                    "alt_text_small": "",
                    "product_image_key": "product_image_48",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00746824FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00746824FF-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 48,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 48
                },
                {
                    "fk_product_image_set": 18,
                    "id_product_image": 50,
                    "alt_text_small": "",
                    "product_image_key": "product_image_50",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00746823FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00746823FF-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 50,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 50
                },
                {
                    "fk_product_image_set": 18,
                    "id_product_image": 52,
                    "alt_text_small": "",
                    "product_image_key": "product_image_52",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00746826FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00746826FF-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 52,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 52
                },
                {
                    "fk_product_image_set": 18,
                    "id_product_image": 54,
                    "alt_text_small": "",
                    "product_image_key": "product_image_54",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00746825FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00746825FF-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 54,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 54
                },
                {
                    "fk_product_image_set": 18,
                    "id_product_image": 56,
                    "alt_text_small": "",
                    "product_image_key": "product_image_56",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00048847-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00048847-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 56,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 56
                },
                {
                    "fk_product_image_set": 18,
                    "id_product_image": 58,
                    "alt_text_small": "",
                    "product_image_key": "product_image_58",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046283F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046283F-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 58,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 58
                },
                {
                    "fk_product_image_set": 18,
                    "id_product_image": 60,
                    "alt_text_small": "",
                    "product_image_key": "product_image_60",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046282F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046282F-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 60,
                    "sort_order": 15,
                    "alt_text_large": "",
                    "fk_product_image": 60
                },
                {
                    "fk_product_image_set": 18,
                    "id_product_image": 62,
                    "alt_text_small": "",
                    "product_image_key": "product_image_62",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046285F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046285F-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 62,
                    "sort_order": 17,
                    "alt_text_large": "",
                    "fk_product_image": 62
                },
                {
                    "fk_product_image_set": 18,
                    "id_product_image": 64,
                    "alt_text_small": "",
                    "product_image_key": "product_image_64",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046284F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046284F-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 64,
                    "sort_order": 19,
                    "alt_text_large": "",
                    "fk_product_image": 64
                }
            ],
            "id_product_labels": [],
            "price": 13725,
            "abstract_name": "Visitor chair, stackable - backrest upholstered, substructure chromed",
            "id_product_abstract": 9,
            "type": "product_abstract",
            "add_to_cart_sku": "213103",
            "prices": {
                "DEFAULT": 13725
            },
            "abstract_sku": "M1006811",
            "url": "\/en\/besucherstuhl-stapelbar-rueckenlehne-gepolstert-gestell-verchromt-M1006811"
        }
    ],
    "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": []
}
{}