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

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": 24,
        "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": "3"
    }
}
{
    "facets": {
        "category": {},
        "rating": {},
        "label": {},
        "farbe": {},
        "material": {},
        "brand": {},
        "merchant_name": {}
    },
    "sort": {},
    "pagination": {},
    "products": [
        {
            "images": [
                {
                    "fk_product_image_set": 806,
                    "id_product_image": 3180,
                    "alt_text_small": "",
                    "product_image_key": "product_image_3180",
                    "updated_at": "2025-12-02 09:55:28.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/657712?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/657712",
                    "created_at": "2025-12-02 09:55:28.000000",
                    "id_product_image_set_to_product_image": 3180,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 3180
                }
            ],
            "id_product_labels": [],
            "price": 11641,
            "abstract_name": "FRIWA stackable chair - with closed back",
            "id_product_abstract": 389,
            "type": "product_abstract",
            "add_to_cart_sku": "657712",
            "prices": {
                "DEFAULT": 11641
            },
            "abstract_sku": "M83",
            "url": "\/en\/stapelstuhl-mit-geschlossenem-ruecken-M83"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 572,
                    "id_product_image": 1832,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1832",
                    "updated_at": "2025-12-02 09:55:20.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00034569F-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00034569F-02",
                    "created_at": "2025-12-02 09:55:20.000000",
                    "id_product_image_set_to_product_image": 1832,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1832
                },
                {
                    "fk_product_image_set": 572,
                    "id_product_image": 1834,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1834",
                    "updated_at": "2025-12-02 09:55:20.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00980031FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00980031FF-01",
                    "created_at": "2025-12-02 09:55:20.000000",
                    "id_product_image_set_to_product_image": 1834,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1834
                },
                {
                    "fk_product_image_set": 572,
                    "id_product_image": 1836,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1836",
                    "updated_at": "2025-12-02 09:55:20.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00980032FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00980032FF-01",
                    "created_at": "2025-12-02 09:55:20.000000",
                    "id_product_image_set_to_product_image": 1836,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 1836
                },
                {
                    "fk_product_image_set": 572,
                    "id_product_image": 1838,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1838",
                    "updated_at": "2025-12-02 09:55:20.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00047307F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00047307F-01",
                    "created_at": "2025-12-02 09:55:20.000000",
                    "id_product_image_set_to_product_image": 1838,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 1838
                },
                {
                    "fk_product_image_set": 572,
                    "id_product_image": 1840,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1840",
                    "updated_at": "2025-12-02 09:55:20.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00980032II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00980032II-02",
                    "created_at": "2025-12-02 09:55:20.000000",
                    "id_product_image_set_to_product_image": 1840,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 1840
                },
                {
                    "fk_product_image_set": 574,
                    "id_product_image": 1842,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1842",
                    "updated_at": "2025-12-02 09:55:20.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/P_LEDER0052-de?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/P_LEDER0052-de",
                    "created_at": "2025-12-02 09:55:20.000000",
                    "id_product_image_set_to_product_image": 1842,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 1842
                }
            ],
            "id_product_labels": [
                5
            ],
            "price": 40120,
            "abstract_name": "Topstar cantilever visitor chair - leather, backrest height 460 mm",
            "id_product_abstract": 300,
            "type": "product_abstract",
            "add_to_cart_sku": "101102",
            "prices": {
                "DEFAULT": 40120,
                "ORIGINAL": 44577
            },
            "abstract_sku": "M53235",
            "url": "\/en\/topstar-freischwinger-besuchersessel-leder-rueckenlehnenhoehe-460-mm-M53235"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 14,
                    "id_product_image": 36,
                    "alt_text_small": "",
                    "product_image_key": "product_image_36",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/G00047132-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/G00047132-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 36,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 36
                },
                {
                    "fk_product_image_set": 14,
                    "id_product_image": 38,
                    "alt_text_small": "",
                    "product_image_key": "product_image_38",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/G00047133-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/G00047133-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 38,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 38
                },
                {
                    "fk_product_image_set": 14,
                    "id_product_image": 40,
                    "alt_text_small": "",
                    "product_image_key": "product_image_40",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/G00047133-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/G00047133-02",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 40,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 40
                }
            ],
            "id_product_labels": [],
            "price": 3750,
            "abstract_name": "Mauser universal steel cabinet with swing doors - HxWxD 1850 x 800 x 420 mm",
            "id_product_abstract": 7,
            "type": "product_abstract",
            "add_to_cart_sku": "463981",
            "prices": {
                "DEFAULT": 3750
            },
            "abstract_sku": "M1002203",
            "url": "\/en\/mauser-universal-stahlschrank-mit-fluegeltueren-hxbxt-1850-x-800-x-420-mm-M1002203"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 26,
                    "id_product_image": 80,
                    "alt_text_small": "",
                    "product_image_key": "product_image_80",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00759524II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00759524II-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 80,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 80
                },
                {
                    "fk_product_image_set": 26,
                    "id_product_image": 82,
                    "alt_text_small": "",
                    "product_image_key": "product_image_82",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00759524II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00759524II-02",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 82,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 82
                }
            ],
            "id_product_labels": [],
            "price": 1717,
            "abstract_name": "Universal lectern - with upper shelf",
            "id_product_abstract": 13,
            "type": "product_abstract",
            "add_to_cart_sku": "519762",
            "prices": {
                "DEFAULT": 1717
            },
            "abstract_sku": "M1013541",
            "url": "\/en\/rednerpult-universell-mit-ablageboden-M1013541"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 58,
                    "id_product_image": 172,
                    "alt_text_small": "",
                    "product_image_key": "product_image_172",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049673-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049673-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 172,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 172
                },
                {
                    "fk_product_image_set": 58,
                    "id_product_image": 174,
                    "alt_text_small": "",
                    "product_image_key": "product_image_174",
                    "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": 174,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 174
                }
            ],
            "id_product_labels": [],
            "price": 22637,
            "abstract_name": "FRIWA wood shell chair, VE 2 pieces - beech, black, round, with upholstery",
            "id_product_abstract": 27,
            "type": "product_abstract",
            "add_to_cart_sku": "512067",
            "prices": {
                "DEFAULT": 22637
            },
            "abstract_sku": "M1014874",
            "url": "\/en\/holz-schalenstuhl-ve-2-stk-buche-schwarz-rund-mit-polster-M1014874"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 130,
                    "id_product_image": 500,
                    "alt_text_small": "",
                    "product_image_key": "product_image_500",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035082F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035082F-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 500,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 500
                },
                {
                    "fk_product_image_set": 130,
                    "id_product_image": 502,
                    "alt_text_small": "",
                    "product_image_key": "product_image_502",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00014490-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00014490-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 502,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 502
                },
                {
                    "fk_product_image_set": 130,
                    "id_product_image": 504,
                    "alt_text_small": "",
                    "product_image_key": "product_image_504",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00014491-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00014491-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 504,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 504
                },
                {
                    "fk_product_image_set": 130,
                    "id_product_image": 506,
                    "alt_text_small": "",
                    "product_image_key": "product_image_506",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00014492-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00014492-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 506,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 506
                },
                {
                    "fk_product_image_set": 130,
                    "id_product_image": 508,
                    "alt_text_small": "",
                    "product_image_key": "product_image_508",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00014493-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00014493-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 508,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 508
                }
            ],
            "id_product_labels": [],
            "price": 12185,
            "abstract_name": "conference chair - stacking chair, substructure chromed",
            "id_product_abstract": 63,
            "type": "product_abstract",
            "add_to_cart_sku": "104192",
            "prices": {
                "DEFAULT": 12185
            },
            "abstract_sku": "M10872",
            "url": "\/en\/konferenzstuhl-stapelstuhl-gestell-verchromt-M10872"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 136,
                    "id_product_image": 518,
                    "alt_text_small": "",
                    "product_image_key": "product_image_518",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00016485-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00016485-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 518,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 518
                },
                {
                    "fk_product_image_set": 136,
                    "id_product_image": 520,
                    "alt_text_small": "",
                    "product_image_key": "product_image_520",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00018145-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00018145-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 520,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 520
                },
                {
                    "fk_product_image_set": 136,
                    "id_product_image": 522,
                    "alt_text_small": "",
                    "product_image_key": "product_image_522",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00018147-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00018147-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 522,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 522
                },
                {
                    "fk_product_image_set": 136,
                    "id_product_image": 524,
                    "alt_text_small": "",
                    "product_image_key": "product_image_524",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00018146-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00018146-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 524,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 524
                }
            ],
            "id_product_labels": [],
            "price": 17920,
            "abstract_name": "Topstar spinal swivel chair - without armrests",
            "id_product_abstract": 66,
            "type": "product_abstract",
            "add_to_cart_sku": "103235",
            "prices": {
                "DEFAULT": 17920
            },
            "abstract_sku": "M11306",
            "url": "\/en\/topstar-bandscheibendrehstuhl-ohne-armlehnen-M11306"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 138,
                    "id_product_image": 526,
                    "alt_text_small": "",
                    "product_image_key": "product_image_526",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00743641FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00743641FF-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 526,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 526
                },
                {
                    "fk_product_image_set": 138,
                    "id_product_image": 528,
                    "alt_text_small": "",
                    "product_image_key": "product_image_528",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00743643FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00743643FF-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 528,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 528
                },
                {
                    "fk_product_image_set": 138,
                    "id_product_image": 530,
                    "alt_text_small": "",
                    "product_image_key": "product_image_530",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00743645FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00743645FF-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 530,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 530
                },
                {
                    "fk_product_image_set": 138,
                    "id_product_image": 532,
                    "alt_text_small": "",
                    "product_image_key": "product_image_532",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00743647FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00743647FF-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 532,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 532
                },
                {
                    "fk_product_image_set": 138,
                    "id_product_image": 534,
                    "alt_text_small": "",
                    "product_image_key": "product_image_534",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050425-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050425-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 534,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 534
                },
                {
                    "fk_product_image_set": 138,
                    "id_product_image": 536,
                    "alt_text_small": "",
                    "product_image_key": "product_image_536",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00743641II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00743641II-02",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 536,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 536
                },
                {
                    "fk_product_image_set": 138,
                    "id_product_image": 538,
                    "alt_text_small": "",
                    "product_image_key": "product_image_538",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050389-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050389-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 538,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 538
                }
            ],
            "id_product_labels": [],
            "price": 12620,
            "abstract_name": "Topstar standard swivel chair - without armrests, backrest 550 mm",
            "id_product_abstract": 67,
            "type": "product_abstract",
            "add_to_cart_sku": "104440",
            "prices": {
                "DEFAULT": 12620
            },
            "abstract_sku": "M11473",
            "url": "\/en\/topstar-standard-drehstuhl-ohne-armlehnen-rueckenlehne-550-mm-M11473"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 406,
                    "id_product_image": 1456,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1456",
                    "updated_at": "2025-12-02 09:55:17.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00016422F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00016422F-01",
                    "created_at": "2025-12-02 09:55:17.000000",
                    "id_product_image_set_to_product_image": 1456,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1456
                }
            ],
            "id_product_labels": [],
            "price": 30531,
            "abstract_name": "Wood stacking chair with continuous shell - substructure coated, VE 4 pieces",
            "id_product_abstract": 214,
            "type": "product_abstract",
            "add_to_cart_sku": "104524",
            "prices": {
                "DEFAULT": 30531
            },
            "abstract_sku": "M2366",
            "url": "\/en\/holz-schalenstuhl-mit-durchgehender-schale-gestell-verchromt-ve-4-stk-M2366"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 444,
                    "id_product_image": 1524,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1524",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00036964F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00036964F-01",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1524,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1524
                }
            ],
            "id_product_labels": [
                5
            ],
            "price": 12272,
            "abstract_name": "Plastic stackable chair with upholstery - shell gray",
            "id_product_abstract": 233,
            "type": "product_abstract",
            "add_to_cart_sku": "100588",
            "prices": {
                "DEFAULT": 12272,
                "ORIGINAL": 13635
            },
            "abstract_sku": "M2393",
            "url": "\/en\/kunststoff-stapelstuhl-mit-polster-schale-grau-M2393"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 2,
                    "id_product_image": 2,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/22115z Stehpult lichtgrau?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/22115z Stehpult lichtgrau",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 2,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 2
                }
            ],
            "id_product_labels": [
                5
            ],
            "price": 2438,
            "abstract_name": "Schomburg standing desk - HxWxD 1094 x 600 x 500 mm ",
            "id_product_abstract": 1,
            "type": "product_abstract",
            "add_to_cart_sku": "1001454",
            "prices": {
                "DEFAULT": 2438,
                "ORIGINAL": 10541
            },
            "abstract_sku": "C2235",
            "url": "\/en\/schomburg-stehpult-hxbxt-1094-x-600-x-500-mm-C2235"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 4,
                    "id_product_image": 4,
                    "alt_text_small": "",
                    "product_image_key": "product_image_4",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00047883F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00047883F-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 4,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 4
                },
                {
                    "fk_product_image_set": 4,
                    "id_product_image": 6,
                    "alt_text_small": "",
                    "product_image_key": "product_image_6",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00945514FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00945514FF-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 6,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 6
                },
                {
                    "fk_product_image_set": 4,
                    "id_product_image": 8,
                    "alt_text_small": "",
                    "product_image_key": "product_image_8",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00945512FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00945512FF-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 8,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 8
                },
                {
                    "fk_product_image_set": 4,
                    "id_product_image": 10,
                    "alt_text_small": "",
                    "product_image_key": "product_image_10",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00945513FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00945513FF-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 10,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 10
                },
                {
                    "fk_product_image_set": 4,
                    "id_product_image": 12,
                    "alt_text_small": "",
                    "product_image_key": "product_image_12",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00945515FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00945515FF-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 12,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 12
                }
            ],
            "id_product_labels": [],
            "price": 2625,
            "abstract_name": "Wood stackable chair, upholstered - VE 4 pieces, substructure chromed",
            "id_product_abstract": 2,
            "type": "product_abstract",
            "add_to_cart_sku": "212427",
            "prices": {
                "DEFAULT": 2625
            },
            "abstract_sku": "M1000785",
            "url": "\/en\/holz-schalenstuhl-gepolstert-ve-4-stk-gestell-verchromt-M1000785"
        }
    ],
    "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": []
}
{}