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

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": 36,
        "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": "4"
    }
}
{
    "facets": {
        "category": {},
        "rating": {},
        "label": {},
        "farbe": {},
        "material": {},
        "brand": {},
        "merchant_name": {}
    },
    "sort": {},
    "pagination": {},
    "products": [
        {
            "images": [
                {
                    "fk_product_image_set": 20,
                    "id_product_image": 66,
                    "alt_text_small": "",
                    "product_image_key": "product_image_66",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00752969FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00752969FF-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 66,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 66
                }
            ],
            "id_product_labels": [],
            "price": 28918,
            "abstract_name": "office akktiv base cabinet - HxWxD 942 x 913 x 420 mm",
            "id_product_abstract": 10,
            "type": "product_abstract",
            "add_to_cart_sku": "213216",
            "prices": {
                "DEFAULT": 28918
            },
            "abstract_sku": "M1006871",
            "url": "\/en\/office-akktiv-unterschrank-hxbxt-942-x-913-x-420-mm-M1006871"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 24,
                    "id_product_image": 70,
                    "alt_text_small": "",
                    "product_image_key": "product_image_70",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756546II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756546II-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 70,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 70
                },
                {
                    "fk_product_image_set": 24,
                    "id_product_image": 72,
                    "alt_text_small": "",
                    "product_image_key": "product_image_72",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756548II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756548II-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 72,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 72
                },
                {
                    "fk_product_image_set": 24,
                    "id_product_image": 74,
                    "alt_text_small": "",
                    "product_image_key": "product_image_74",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756546II-G1?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756546II-G1",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 74,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 74
                },
                {
                    "fk_product_image_set": 24,
                    "id_product_image": 76,
                    "alt_text_small": "",
                    "product_image_key": "product_image_76",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756546II-G2?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756546II-G2",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 76,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 76
                },
                {
                    "fk_product_image_set": 24,
                    "id_product_image": 78,
                    "alt_text_small": "",
                    "product_image_key": "product_image_78",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756546II-G3?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756546II-G3",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 78,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 78
                }
            ],
            "id_product_labels": [],
            "price": 2137,
            "abstract_name": "Smit Visual lectern, height-adjustable - mobile, with 4 rollers",
            "id_product_abstract": 12,
            "type": "product_abstract",
            "add_to_cart_sku": "517630",
            "prices": {
                "DEFAULT": 2137
            },
            "abstract_sku": "M1013287",
            "url": "\/en\/rednerpult-hoehenverstellbar-mobil-mit-4-rollen-M1013287"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 28,
                    "id_product_image": 84,
                    "alt_text_small": "",
                    "product_image_key": "product_image_84",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049521F-03?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049521F-03",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 84,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 84
                },
                {
                    "fk_product_image_set": 28,
                    "id_product_image": 86,
                    "alt_text_small": "",
                    "product_image_key": "product_image_86",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00907158FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00907158FF-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 86,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 86
                },
                {
                    "fk_product_image_set": 28,
                    "id_product_image": 88,
                    "alt_text_small": "",
                    "product_image_key": "product_image_88",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970134FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970134FF-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 88,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 88
                },
                {
                    "fk_product_image_set": 28,
                    "id_product_image": 90,
                    "alt_text_small": "",
                    "product_image_key": "product_image_90",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049526-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049526-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 90,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 90
                },
                {
                    "fk_product_image_set": 28,
                    "id_product_image": 92,
                    "alt_text_small": "",
                    "product_image_key": "product_image_92",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00907158II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00907158II-02",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 92,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 92
                },
                {
                    "fk_product_image_set": 28,
                    "id_product_image": 94,
                    "alt_text_small": "",
                    "product_image_key": "product_image_94",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95388-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95388-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 94,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 94
                }
            ],
            "id_product_labels": [],
            "price": 2250,
            "abstract_name": "CP steel cabinet, fire-resistant - 2 adjustable shelves, width 1200 mm",
            "id_product_abstract": 14,
            "type": "product_abstract",
            "add_to_cart_sku": "574599",
            "prices": {
                "DEFAULT": 2250
            },
            "abstract_sku": "M1014496",
            "url": "\/en\/cp-stahlschrank-feuergeschuetzt-2-fachboeden-verstellbar-breite-1200-mm-M1014496"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 32,
                    "id_product_image": 110,
                    "alt_text_small": "",
                    "product_image_key": "product_image_110",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049203F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049203F-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 110,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 110
                },
                {
                    "fk_product_image_set": 32,
                    "id_product_image": 112,
                    "alt_text_small": "",
                    "product_image_key": "product_image_112",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00030287-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00030287-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 112,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 112
                },
                {
                    "fk_product_image_set": 32,
                    "id_product_image": 114,
                    "alt_text_small": "",
                    "product_image_key": "product_image_114",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00048762-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00048762-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 114,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 114
                },
                {
                    "fk_product_image_set": 32,
                    "id_product_image": 116,
                    "alt_text_small": "",
                    "product_image_key": "product_image_116",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00044373-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00044373-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 116,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 116
                },
                {
                    "fk_product_image_set": 32,
                    "id_product_image": 118,
                    "alt_text_small": "",
                    "product_image_key": "product_image_118",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK94363-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK94363-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 118,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 118
                },
                {
                    "fk_product_image_set": 34,
                    "id_product_image": 120,
                    "alt_text_small": "",
                    "product_image_key": "product_image_120",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/P_JAHR0070CE-de?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/P_JAHR0070CE-de",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 120,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 120
                },
                {
                    "fk_product_image_set": 34,
                    "id_product_image": 122,
                    "alt_text_small": "",
                    "product_image_key": "product_image_122",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/P_QUI0100?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/P_QUI0100",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 122,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 122
                }
            ],
            "id_product_labels": [],
            "price": 40605,
            "abstract_name": "EUROKRAFT pallet lift truck with QuickLift, blue - wheels polyurethane",
            "id_product_abstract": 16,
            "type": "product_abstract",
            "add_to_cart_sku": "463994",
            "prices": {
                "DEFAULT": 40605
            },
            "abstract_sku": "M1014629",
            "url": "\/en\/eurokraft-paletthubwagen-mit-quicklift-blau-raeder-polyurethan-M1014629"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 42,
                    "id_product_image": 140,
                    "alt_text_small": "",
                    "product_image_key": "product_image_140",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046228F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046228F-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 140,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 140
                },
                {
                    "fk_product_image_set": 42,
                    "id_product_image": 142,
                    "alt_text_small": "",
                    "product_image_key": "product_image_142",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051530F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051530F-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 142,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 142
                }
            ],
            "id_product_labels": [],
            "price": 83721,
            "abstract_name": "pallet lift truck - galvanized",
            "id_product_abstract": 20,
            "type": "product_abstract",
            "add_to_cart_sku": "464003",
            "prices": {
                "DEFAULT": 83721
            },
            "abstract_sku": "M1014645",
            "url": "\/en\/paletthubwagen-verzinkt-M1014645"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 44,
                    "id_product_image": 144,
                    "alt_text_small": "",
                    "product_image_key": "product_image_144",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046223F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046223F-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 144,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 144
                },
                {
                    "fk_product_image_set": 44,
                    "id_product_image": 146,
                    "alt_text_small": "",
                    "product_image_key": "product_image_146",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051530F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051530F-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 146,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 146
                },
                {
                    "fk_product_image_set": 46,
                    "id_product_image": 148,
                    "alt_text_small": "",
                    "product_image_key": "product_image_148",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/P_ROST0054-de?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/P_ROST0054-de",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 148,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 148
                }
            ],
            "id_product_labels": [],
            "price": 220970,
            "abstract_name": "Pallet lift truck - V2A stainless steel",
            "id_product_abstract": 21,
            "type": "product_abstract",
            "prices": {
                "DEFAULT": 220970
            },
            "abstract_sku": "M1014646",
            "url": "\/en\/paletthubwagen-v2a-edelstahl-M1014646"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 48,
                    "id_product_image": 150,
                    "alt_text_small": "",
                    "product_image_key": "product_image_150",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049513-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049513-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 150,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 150
                },
                {
                    "fk_product_image_set": 48,
                    "id_product_image": 152,
                    "alt_text_small": "",
                    "product_image_key": "product_image_152",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049514-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049514-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 152,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 152
                },
                {
                    "fk_product_image_set": 48,
                    "id_product_image": 154,
                    "alt_text_small": "",
                    "product_image_key": "product_image_154",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00039136-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00039136-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 154,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 154
                }
            ],
            "id_product_labels": [],
            "price": 70666,
            "abstract_name": "QUIPO pallet lift truck, melon yellow - Load capacity 3000 kg",
            "id_product_abstract": 22,
            "type": "product_abstract",
            "add_to_cart_sku": "464005",
            "prices": {
                "DEFAULT": 70666
            },
            "abstract_sku": "M1014653",
            "url": "\/en\/quipo-paletthubwagen-melonengelb-tragfaehigkeit-3000-kg-M1014653"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 52,
                    "id_product_image": 160,
                    "alt_text_small": "",
                    "product_image_key": "product_image_160",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049669-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049669-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 160,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 160
                },
                {
                    "fk_product_image_set": 52,
                    "id_product_image": 162,
                    "alt_text_small": "",
                    "product_image_key": "product_image_162",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049676F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049676F-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 162,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 162
                }
            ],
            "id_product_labels": [],
            "price": 23834,
            "abstract_name": "FRIWA wood shell chair, VE 2 pieces - beech, natural, round, with upholstery",
            "id_product_abstract": 24,
            "type": "product_abstract",
            "add_to_cart_sku": "512081",
            "prices": {
                "DEFAULT": 23834
            },
            "abstract_sku": "M1014866",
            "url": "\/en\/holz-schalenstuhl-ve-2-stk-buche-natur-rund-mit-polster-M1014866"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 54,
                    "id_product_image": 164,
                    "alt_text_small": "",
                    "product_image_key": "product_image_164",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049672-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049672-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 164,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 164
                },
                {
                    "fk_product_image_set": 54,
                    "id_product_image": 166,
                    "alt_text_small": "",
                    "product_image_key": "product_image_166",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049676F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049676F-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 166,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 166
                }
            ],
            "id_product_labels": [],
            "price": 23834,
            "abstract_name": "FRIWA wood shell chair, VE 2 pieces - beech, black, angular, with upholstery",
            "id_product_abstract": 25,
            "type": "product_abstract",
            "add_to_cart_sku": "512094",
            "prices": {
                "DEFAULT": 23834
            },
            "abstract_sku": "M1014870",
            "url": "\/en\/holz-schalenstuhl-ve-2-stk-buche-schwarz-eckig-mit-polster-M1014870"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 64,
                    "id_product_image": 186,
                    "alt_text_small": "",
                    "product_image_key": "product_image_186",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00520029II-G1?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00520029II-G1",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 186,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 186
                },
                {
                    "fk_product_image_set": 64,
                    "id_product_image": 188,
                    "alt_text_small": "",
                    "product_image_key": "product_image_188",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00520029II-G2?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00520029II-G2",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 188,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 188
                },
                {
                    "fk_product_image_set": 64,
                    "id_product_image": 190,
                    "alt_text_small": "",
                    "product_image_key": "product_image_190",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052997-03?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052997-03",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 190,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 190
                }
            ],
            "id_product_labels": [],
            "price": 46591,
            "abstract_name": "QUIPO pallet lift truck, yellow - Full rubber steering wheels",
            "id_product_abstract": 30,
            "type": "product_abstract",
            "add_to_cart_sku": "464001",
            "prices": {
                "DEFAULT": 46591
            },
            "abstract_sku": "M1015356",
            "url": "\/en\/quipo-paletthubwagen-gelb-lenkraeder-vollgummi-M1015356"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 86,
                    "id_product_image": 258,
                    "alt_text_small": "",
                    "product_image_key": "product_image_258",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050962-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050962-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 258,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 258
                },
                {
                    "fk_product_image_set": 86,
                    "id_product_image": 260,
                    "alt_text_small": "",
                    "product_image_key": "product_image_260",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113309FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113309FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 260,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 260
                },
                {
                    "fk_product_image_set": 86,
                    "id_product_image": 262,
                    "alt_text_small": "",
                    "product_image_key": "product_image_262",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113311FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113311FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 262,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 262
                },
                {
                    "fk_product_image_set": 86,
                    "id_product_image": 264,
                    "alt_text_small": "",
                    "product_image_key": "product_image_264",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113312FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113312FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 264,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 264
                },
                {
                    "fk_product_image_set": 86,
                    "id_product_image": 266,
                    "alt_text_small": "",
                    "product_image_key": "product_image_266",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113313FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113313FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 266,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 266
                },
                {
                    "fk_product_image_set": 86,
                    "id_product_image": 268,
                    "alt_text_small": "",
                    "product_image_key": "product_image_268",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113314FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113314FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 268,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 268
                },
                {
                    "fk_product_image_set": 86,
                    "id_product_image": 270,
                    "alt_text_small": "",
                    "product_image_key": "product_image_270",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113315FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113315FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 270,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 270
                },
                {
                    "fk_product_image_set": 86,
                    "id_product_image": 272,
                    "alt_text_small": "",
                    "product_image_key": "product_image_272",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113316FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113316FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 272,
                    "sort_order": 15,
                    "alt_text_large": "",
                    "fk_product_image": 272
                },
                {
                    "fk_product_image_set": 86,
                    "id_product_image": 274,
                    "alt_text_small": "",
                    "product_image_key": "product_image_274",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113317FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113317FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 274,
                    "sort_order": 17,
                    "alt_text_large": "",
                    "fk_product_image": 274
                },
                {
                    "fk_product_image_set": 86,
                    "id_product_image": 276,
                    "alt_text_small": "",
                    "product_image_key": "product_image_276",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051111-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051111-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 276,
                    "sort_order": 19,
                    "alt_text_large": "",
                    "fk_product_image": 276
                }
            ],
            "id_product_labels": [],
            "price": 63212,
            "abstract_name": "Mauser sliding door cabinet - with glass front, 4 shelves",
            "id_product_abstract": 41,
            "type": "product_abstract",
            "add_to_cart_sku": "410090",
            "prices": {
                "DEFAULT": 63212
            },
            "abstract_sku": "M1024684",
            "url": "\/en\/mauser-schiebetuerschrank-mit-glasfront-4-fachboeden-M1024684"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 90,
                    "id_product_image": 300,
                    "alt_text_small": "",
                    "product_image_key": "product_image_300",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00034527-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00034527-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 300,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 300
                },
                {
                    "fk_product_image_set": 90,
                    "id_product_image": 302,
                    "alt_text_small": "",
                    "product_image_key": "product_image_302",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/G00034527F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/G00034527F-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 302,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 302
                }
            ],
            "id_product_labels": [
                5
            ],
            "price": 20057,
            "abstract_name": "Club chair - Softex covering",
            "id_product_abstract": 43,
            "type": "product_abstract",
            "add_to_cart_sku": "101172",
            "prices": {
                "DEFAULT": 20057,
                "ORIGINAL": 22285
            },
            "abstract_sku": "M1028038",
            "url": "\/en\/clubsessel-bezug-aus-softex-M1028038"
        }
    ],
    "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": []
}
{}