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

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": 12,
        "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": "2"
    }
}
{
    "facets": {
        "category": {},
        "rating": {},
        "label": {},
        "farbe": {},
        "material": {},
        "brand": {},
        "merchant_name": {}
    },
    "sort": {},
    "pagination": {},
    "products": [
        {
            "images": [
                {
                    "fk_product_image_set": 748,
                    "id_product_image": 2858,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2858",
                    "updated_at": "2025-12-02 09:55:26.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00043968-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00043968-01",
                    "created_at": "2025-12-02 09:55:26.000000",
                    "id_product_image_set_to_product_image": 2858,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 2858
                },
                {
                    "fk_product_image_set": 748,
                    "id_product_image": 2860,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2860",
                    "updated_at": "2025-12-02 09:55:26.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00043969-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00043969-01",
                    "created_at": "2025-12-02 09:55:26.000000",
                    "id_product_image_set_to_product_image": 2860,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 2860
                },
                {
                    "fk_product_image_set": 748,
                    "id_product_image": 2862,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2862",
                    "updated_at": "2025-12-02 09:55:26.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00043967F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00043967F-01",
                    "created_at": "2025-12-02 09:55:26.000000",
                    "id_product_image_set_to_product_image": 2862,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 2862
                }
            ],
            "id_product_labels": [],
            "price": 9944,
            "abstract_name": "Multi-purpose table, HxW 720 x 800 mm - Length 800 mm",
            "id_product_abstract": 387,
            "type": "product_abstract",
            "add_to_cart_sku": "107063",
            "prices": {
                "DEFAULT": 9944
            },
            "abstract_sku": "M79932",
            "url": "\/en\/mehrzwecktisch-hxb-720-x-800-mm-laenge-800-mm-M79932"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 556,
                    "id_product_image": 1798,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1798",
                    "updated_at": "2025-12-02 09:55:19.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/G00044636-03?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/G00044636-03",
                    "created_at": "2025-12-02 09:55:19.000000",
                    "id_product_image_set_to_product_image": 1798,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1798
                }
            ],
            "id_product_labels": [],
            "price": 31981,
            "abstract_name": "EUROKRAFT steel hand truck - Load capacity 500 kg",
            "id_product_abstract": 288,
            "type": "product_abstract",
            "add_to_cart_sku": "400072",
            "prices": {
                "DEFAULT": 31981
            },
            "abstract_sku": "M5043",
            "url": "\/en\/eurokraft-sackkarre-aus-stahl-tragfaehigkeit-500-kg-M5043"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 568,
                    "id_product_image": 1822,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1822",
                    "updated_at": "2025-12-02 09:55:20.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052637-03?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052637-03",
                    "created_at": "2025-12-02 09:55:20.000000",
                    "id_product_image_set_to_product_image": 1822,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1822
                },
                {
                    "fk_product_image_set": 568,
                    "id_product_image": 1824,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1824",
                    "updated_at": "2025-12-02 09:55:20.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00704492II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00704492II-01",
                    "created_at": "2025-12-02 09:55:20.000000",
                    "id_product_image_set_to_product_image": 1824,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1824
                }
            ],
            "id_product_labels": [],
            "price": 13062,
            "abstract_name": "EUROKRAFT hand truck with wire frame - Load capacity 100 kg",
            "id_product_abstract": 294,
            "type": "product_abstract",
            "add_to_cart_sku": "401627",
            "prices": {
                "DEFAULT": 13062
            },
            "abstract_sku": "M5154",
            "url": "\/en\/eurokraft-stapelkarre-mit-drahtgitter-tragfaehigkeit-100-kg-M5154"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 570,
                    "id_product_image": 1826,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1826",
                    "updated_at": "2025-12-02 09:55:20.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052637-05?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052637-05",
                    "created_at": "2025-12-02 09:55:20.000000",
                    "id_product_image_set_to_product_image": 1826,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1826
                },
                {
                    "fk_product_image_set": 570,
                    "id_product_image": 1828,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1828",
                    "updated_at": "2025-12-02 09:55:20.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00704493II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00704493II-01",
                    "created_at": "2025-12-02 09:55:20.000000",
                    "id_product_image_set_to_product_image": 1828,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1828
                },
                {
                    "fk_product_image_set": 570,
                    "id_product_image": 1830,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1830",
                    "updated_at": "2025-12-02 09:55:20.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00704494II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00704494II-01",
                    "created_at": "2025-12-02 09:55:20.000000",
                    "id_product_image_set_to_product_image": 1830,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 1830
                }
            ],
            "id_product_labels": [],
            "price": 18297,
            "abstract_name": "EUROKRAFT trolley - Load capacity 350 kg",
            "id_product_abstract": 295,
            "type": "product_abstract",
            "add_to_cart_sku": "401629",
            "prices": {
                "DEFAULT": 18297
            },
            "abstract_sku": "M5155",
            "url": "\/en\/eurokraft-transportkarre-tragfaehigkeit-350-kg-M5155"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 560,
                    "id_product_image": 1804,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1804",
                    "updated_at": "2025-12-02 09:55:19.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052637-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052637-02",
                    "created_at": "2025-12-02 09:55:19.000000",
                    "id_product_image_set_to_product_image": 1804,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1804
                },
                {
                    "fk_product_image_set": 560,
                    "id_product_image": 1806,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1806",
                    "updated_at": "2025-12-02 09:55:19.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00154539II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00154539II-01",
                    "created_at": "2025-12-02 09:55:19.000000",
                    "id_product_image_set_to_product_image": 1806,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1806
                }
            ],
            "id_product_labels": [],
            "price": 10739,
            "abstract_name": "EUROKRAFT hand truck, wheelbarrow, and handcart - Load capacity 100 kg",
            "id_product_abstract": 290,
            "type": "product_abstract",
            "add_to_cart_sku": "400065",
            "prices": {
                "DEFAULT": 10739
            },
            "abstract_sku": "M5108",
            "url": "\/en\/eurokraft-stapel-lade-und-sackkarre-tragfaehigkeit-100-kg-M5108"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 562,
                    "id_product_image": 1808,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1808",
                    "updated_at": "2025-12-02 09:55:19.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00265470II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00265470II-01",
                    "created_at": "2025-12-02 09:55:19.000000",
                    "id_product_image_set_to_product_image": 1808,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1808
                },
                {
                    "fk_product_image_set": 562,
                    "id_product_image": 1810,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1810",
                    "updated_at": "2025-12-02 09:55:19.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052593-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052593-01",
                    "created_at": "2025-12-02 09:55:19.000000",
                    "id_product_image_set_to_product_image": 1810,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1810
                },
                {
                    "fk_product_image_set": 562,
                    "id_product_image": 1812,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1812",
                    "updated_at": "2025-12-02 09:55:19.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052594-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052594-01",
                    "created_at": "2025-12-02 09:55:19.000000",
                    "id_product_image_set_to_product_image": 1812,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 1812
                },
                {
                    "fk_product_image_set": 562,
                    "id_product_image": 1814,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1814",
                    "updated_at": "2025-12-02 09:55:19.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/LO_Eurokraft_RAL_FINAL?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/LO_Eurokraft_RAL_FINAL",
                    "created_at": "2025-12-02 09:55:19.000000",
                    "id_product_image_set_to_product_image": 1814,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 1814
                }
            ],
            "id_product_labels": [],
            "price": 19243,
            "abstract_name": "EUROKRAFT hand truck - Load capacity 350 kg, with skids",
            "id_product_abstract": 291,
            "type": "product_abstract",
            "add_to_cart_sku": "400434",
            "prices": {
                "DEFAULT": 19243
            },
            "abstract_sku": "M5113",
            "url": "\/en\/eurokraft-stapelkarre-tragfaehigkeit-350-kg-mit-gleitkufen-M5113"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 674,
                    "id_product_image": 2404,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2404",
                    "updated_at": "2025-12-02 09:55:23.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00608951FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00608951FF-01",
                    "created_at": "2025-12-02 09:55:23.000000",
                    "id_product_image_set_to_product_image": 2404,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 2404
                },
                {
                    "fk_product_image_set": 674,
                    "id_product_image": 2406,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2406",
                    "updated_at": "2025-12-02 09:55:23.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00608951II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00608951II-02",
                    "created_at": "2025-12-02 09:55:23.000000",
                    "id_product_image_set_to_product_image": 2406,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 2406
                },
                {
                    "fk_product_image_set": 674,
                    "id_product_image": 2408,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2408",
                    "updated_at": "2025-12-02 09:55:23.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00608951II-03?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00608951II-03",
                    "created_at": "2025-12-02 09:55:23.000000",
                    "id_product_image_set_to_product_image": 2408,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 2408
                }
            ],
            "id_product_labels": [],
            "price": 76882,
            "abstract_name": "office akktiv hinged-door cabinet - HxWxD 1864 x 913 x 440 mm, 4 shelves",
            "id_product_abstract": 350,
            "type": "product_abstract",
            "add_to_cart_sku": "103836",
            "prices": {
                "DEFAULT": 76882
            },
            "abstract_sku": "M72844",
            "url": "\/en\/office-akktiv-fluegeltuerenschrank-hxbxt-1864-x-913-x-440-mm-4-fachboeden-M72844"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 72,
                    "id_product_image": 206,
                    "alt_text_small": "",
                    "product_image_key": "product_image_206",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050065F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050065F-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 206,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 206
                },
                {
                    "fk_product_image_set": 72,
                    "id_product_image": 208,
                    "alt_text_small": "",
                    "product_image_key": "product_image_208",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970568FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970568FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 208,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 208
                },
                {
                    "fk_product_image_set": 72,
                    "id_product_image": 210,
                    "alt_text_small": "",
                    "product_image_key": "product_image_210",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970563FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970563FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 210,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 210
                },
                {
                    "fk_product_image_set": 72,
                    "id_product_image": 212,
                    "alt_text_small": "",
                    "product_image_key": "product_image_212",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050066F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050066F-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 212,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 212
                }
            ],
            "id_product_labels": [],
            "price": 42998,
            "abstract_name": "fm b\u00fcrom\u00f6bel PETRA filing cabinet - HxWxD 1851 x 800 x 362 mm",
            "id_product_abstract": 34,
            "type": "product_abstract",
            "add_to_cart_sku": "574987",
            "prices": {
                "DEFAULT": 42998
            },
            "abstract_sku": "M1017945",
            "url": "\/en\/petra-aktenschrank-hxbxt-1851-x-800-x-362-mm-M1017945"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 76,
                    "id_product_image": 220,
                    "alt_text_small": "",
                    "product_image_key": "product_image_220",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00927696FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00927696FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 220,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 220
                },
                {
                    "fk_product_image_set": 76,
                    "id_product_image": 222,
                    "alt_text_small": "",
                    "product_image_key": "product_image_222",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00927699FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00927699FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 222,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 222
                },
                {
                    "fk_product_image_set": 76,
                    "id_product_image": 224,
                    "alt_text_small": "",
                    "product_image_key": "product_image_224",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00611423FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00611423FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 224,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 224
                },
                {
                    "fk_product_image_set": 76,
                    "id_product_image": 226,
                    "alt_text_small": "",
                    "product_image_key": "product_image_226",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00611426FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00611426FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 226,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 226
                },
                {
                    "fk_product_image_set": 76,
                    "id_product_image": 228,
                    "alt_text_small": "",
                    "product_image_key": "product_image_228",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00611422FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00611422FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 228,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 228
                },
                {
                    "fk_product_image_set": 76,
                    "id_product_image": 230,
                    "alt_text_small": "",
                    "product_image_key": "product_image_230",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00611424FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00611424FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 230,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 230
                },
                {
                    "fk_product_image_set": 76,
                    "id_product_image": 232,
                    "alt_text_small": "",
                    "product_image_key": "product_image_232",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050660-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050660-02",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 232,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 232
                },
                {
                    "fk_product_image_set": 76,
                    "id_product_image": 234,
                    "alt_text_small": "",
                    "product_image_key": "product_image_234",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00044809-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00044809-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 234,
                    "sort_order": 15,
                    "alt_text_large": "",
                    "fk_product_image": 234
                },
                {
                    "fk_product_image_set": 76,
                    "id_product_image": 236,
                    "alt_text_small": "",
                    "product_image_key": "product_image_236",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK01018212II-G1?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK01018212II-G1",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 236,
                    "sort_order": 17,
                    "alt_text_large": "",
                    "fk_product_image": 236
                }
            ],
            "id_product_labels": [
                5
            ],
            "price": 51185,
            "abstract_name": "CP office steel cabinet with swing doors - HxW 1950 x 1200 mm",
            "id_product_abstract": 36,
            "type": "product_abstract",
            "add_to_cart_sku": "102121",
            "prices": {
                "DEFAULT": 51185,
                "ORIGINAL": 56872
            },
            "abstract_sku": "M1018212",
            "url": "\/en\/cp-buero-stahlschrank-mit-fluegeltueren-hxb-1950-x-1200-mm-M1018212"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 80,
                    "id_product_image": 242,
                    "alt_text_small": "",
                    "product_image_key": "product_image_242",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970792II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970792II-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 242,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 242
                },
                {
                    "fk_product_image_set": 80,
                    "id_product_image": 244,
                    "alt_text_small": "",
                    "product_image_key": "product_image_244",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970793II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970793II-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 244,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 244
                }
            ],
            "id_product_labels": [],
            "price": 36352,
            "abstract_name": "mauser ARCOS hinged door cabinet - 4 compartments - HxWxD 1950 x 950 x 420 mm",
            "id_product_abstract": 38,
            "type": "product_abstract",
            "add_to_cart_sku": "575193",
            "prices": {
                "DEFAULT": 36352
            },
            "abstract_sku": "M1022640",
            "url": "\/en\/fluegeltuerenschrank-arcos-4-fachboeden-hxbxt-1950-x-950-x-420-mm-M1022640"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 82,
                    "id_product_image": 246,
                    "alt_text_small": "",
                    "product_image_key": "product_image_246",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970790II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970790II-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 246,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 246
                },
                {
                    "fk_product_image_set": 82,
                    "id_product_image": 248,
                    "alt_text_small": "",
                    "product_image_key": "product_image_248",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970791II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970791II-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 248,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 248
                }
            ],
            "id_product_labels": [],
            "price": 42757,
            "abstract_name": "mauser ARCOS sliding door cabinet - 2 compartments - HxWxD 1240 x 1200 x 420 mm",
            "id_product_abstract": 39,
            "type": "product_abstract",
            "add_to_cart_sku": "575191",
            "prices": {
                "DEFAULT": 42757
            },
            "abstract_sku": "M1022643",
            "url": "\/en\/schiebetuerenschrank-arcos-2-fachboeden-hxbxt-1240-x-1200-x-420-mm-M1022643"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 78,
                    "id_product_image": 238,
                    "alt_text_small": "",
                    "product_image_key": "product_image_238",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970783II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970783II-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 238,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 238
                },
                {
                    "fk_product_image_set": 78,
                    "id_product_image": 240,
                    "alt_text_small": "",
                    "product_image_key": "product_image_240",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970784II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970784II-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 240,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 240
                }
            ],
            "id_product_labels": [],
            "price": 42757,
            "abstract_name": "mauser ARCOS writing desk - WxD 1800 x 800 mm",
            "id_product_abstract": 37,
            "type": "product_abstract",
            "add_to_cart_sku": "575186",
            "prices": {
                "DEFAULT": 42757
            },
            "abstract_sku": "M1022632",
            "url": "\/en\/schreibtisch-arcos-bxt-1800-x-800-mm-M1022632"
        }
    ],
    "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": []
}
{}