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

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": 156,
        "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": "14"
    }
}
{
    "facets": {
        "category": {},
        "rating": {},
        "label": {},
        "farbe": {},
        "material": {},
        "brand": {},
        "merchant_name": {}
    },
    "sort": {},
    "pagination": {},
    "products": [
        {
            "images": [
                {
                    "fk_product_image_set": 118,
                    "id_product_image": 464,
                    "alt_text_small": "",
                    "product_image_key": "product_image_464",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052639-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052639-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 464,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 464
                },
                {
                    "fk_product_image_set": 118,
                    "id_product_image": 466,
                    "alt_text_small": "",
                    "product_image_key": "product_image_466",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052640-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052640-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 466,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 466
                },
                {
                    "fk_product_image_set": 118,
                    "id_product_image": 468,
                    "alt_text_small": "",
                    "product_image_key": "product_image_468",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052641-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052641-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 468,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 468
                }
            ],
            "id_product_labels": [],
            "price": 41819,
            "abstract_name": "IDEAL document shredder, large, SHREDCAT - Collecting volume 30 l",
            "id_product_abstract": 57,
            "type": "product_abstract",
            "add_to_cart_sku": "413850",
            "prices": {
                "DEFAULT": 41819
            },
            "abstract_sku": "M1079219",
            "url": "\/en\/ideal-aktenvernichter-gross-shredcat-auffangvolumen-30-l-M1079219"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 290,
                    "id_product_image": 992,
                    "alt_text_small": "",
                    "product_image_key": "product_image_992",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/V005518O?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/V005518O",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 992,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 992
                }
            ],
            "id_product_labels": [
                2
            ],
            "price": 3086,
            "abstract_name": "Veloflex table flipchart 4132280 DIN A3 crosswise, 4 rings, 10 covers, black",
            "id_product_abstract": 148,
            "type": "product_abstract",
            "add_to_cart_sku": "421540",
            "prices": {
                "DEFAULT": 3086
            },
            "abstract_sku": "M21779",
            "url": "\/en\/veloflex-tischflipchart-4132280-din-a3-quer-4ringe-10huellen-schwarz-M21779"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 316,
                    "id_product_image": 1076,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1076",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046295F-03?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046295F-03",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1076,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1076
                },
                {
                    "fk_product_image_set": 316,
                    "id_product_image": 1078,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1078",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00704101FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00704101FF-01",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1078,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1078
                },
                {
                    "fk_product_image_set": 316,
                    "id_product_image": 1080,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1080",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00512288FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00512288FF-01",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1080,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 1080
                },
                {
                    "fk_product_image_set": 316,
                    "id_product_image": 1082,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1082",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00519714FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00519714FF-01",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1082,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 1082
                },
                {
                    "fk_product_image_set": 316,
                    "id_product_image": 1084,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1084",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00519746FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00519746FF-01",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1084,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 1084
                },
                {
                    "fk_product_image_set": 316,
                    "id_product_image": 1086,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1086",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK91861-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK91861-01",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1086,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 1086
                }
            ],
            "id_product_labels": [],
            "price": 46531,
            "abstract_name": "Mauser steel cabinet with swing doors - 3 shelves, short, and wardrobe",
            "id_product_abstract": 161,
            "type": "product_abstract",
            "add_to_cart_sku": "102809",
            "prices": {
                "DEFAULT": 46531
            },
            "abstract_sku": "M226",
            "url": "\/en\/mauser-stahlschrank-mit-fluegeltueren-3-fachboeden-kurz-und-garderobe-M226"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 454,
                    "id_product_image": 1534,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1534",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007158W?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007158W",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1534,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1534
                },
                {
                    "fk_product_image_set": 454,
                    "id_product_image": 1536,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1536",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007751L?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007751L",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1536,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1536
                }
            ],
            "id_product_labels": [],
            "price": 1836,
            "abstract_name": "IDEAL Oil paper 9000631 for document shredder, 18 sheets\/pack.",
            "id_product_abstract": 238,
            "type": "product_abstract",
            "add_to_cart_sku": "426531",
            "prices": {
                "DEFAULT": 1836
            },
            "abstract_sku": "M24563",
            "url": "\/en\/ideal-oelpapier-9000631-fuer-aktenvernichter-18-bl-pack-M24563"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 504,
                    "id_product_image": 1606,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1606",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124186II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124186II-01",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1606,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1606
                },
                {
                    "fk_product_image_set": 504,
                    "id_product_image": 1608,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1608",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124186II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124186II-02",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1608,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1608
                },
                {
                    "fk_product_image_set": 504,
                    "id_product_image": 1610,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1610",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124188II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124188II-01",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1610,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 1610
                },
                {
                    "fk_product_image_set": 504,
                    "id_product_image": 1612,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1612",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124188II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124188II-02",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1612,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 1612
                }
            ],
            "id_product_labels": [],
            "price": 3912,
            "abstract_name": "Safescan counterfeit test device - SAFESCAN 50 UV",
            "id_product_abstract": 263,
            "type": "product_abstract",
            "add_to_cart_sku": "419872",
            "prices": {
                "DEFAULT": 3912
            },
            "abstract_sku": "M29502",
            "url": "\/en\/falschgeld-pruefgeraet-safescan-50-uv-M29502"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 506,
                    "id_product_image": 1614,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1614",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124187II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124187II-01",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1614,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1614
                },
                {
                    "fk_product_image_set": 506,
                    "id_product_image": 1616,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1616",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124187II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124187II-02",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1616,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1616
                },
                {
                    "fk_product_image_set": 506,
                    "id_product_image": 1618,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1618",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124189II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124189II-01",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1618,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 1618
                },
                {
                    "fk_product_image_set": 506,
                    "id_product_image": 1620,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1620",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124189II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124189II-02",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1620,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 1620
                }
            ],
            "id_product_labels": [],
            "price": 6155,
            "abstract_name": "Safescan counterfeit test device - SAFESCAN 70 UV and white light",
            "id_product_abstract": 264,
            "type": "product_abstract",
            "add_to_cart_sku": "419873",
            "prices": {
                "DEFAULT": 6155
            },
            "abstract_sku": "M29503",
            "url": "\/en\/falschgeld-pruefgeraet-safescan-70-uv-und-weisslicht-M29503"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 508,
                    "id_product_image": 1622,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1622",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124190II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124190II-01",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1622,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1622
                },
                {
                    "fk_product_image_set": 508,
                    "id_product_image": 1624,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1624",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124190II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124190II-02",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1624,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1624
                }
            ],
            "id_product_labels": [],
            "price": 33524,
            "abstract_name": "Safescan automatic banknote counter - 3-fold counterfeit recognition",
            "id_product_abstract": 265,
            "type": "product_abstract",
            "add_to_cart_sku": "419876",
            "prices": {
                "DEFAULT": 33524
            },
            "abstract_sku": "M29504",
            "url": "\/en\/automatischer-banknotenzaehler-3fache-falschgelderkennung-M29504"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 510,
                    "id_product_image": 1626,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1626",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124194II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124194II-01",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1626,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1626
                },
                {
                    "fk_product_image_set": 510,
                    "id_product_image": 1628,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1628",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124194II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124194II-02",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1628,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1628
                },
                {
                    "fk_product_image_set": 510,
                    "id_product_image": 1630,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1630",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000016457032_PRD_org_all?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000016457032_PRD_org_all",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1630,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 1630
                },
                {
                    "fk_product_image_set": 510,
                    "id_product_image": 1632,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1632",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000016457034_PRD_org_all?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000016457034_PRD_org_all",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1632,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 1632
                }
            ],
            "id_product_labels": [],
            "price": 22312,
            "abstract_name": "Safescan automatic coin counter and sorter - SAFESCAN 1250",
            "id_product_abstract": 266,
            "type": "product_abstract",
            "add_to_cart_sku": "419880",
            "prices": {
                "DEFAULT": 22312
            },
            "abstract_sku": "M29507",
            "url": "\/en\/automatischer-muenzzaehler-und-sortierer-safescan-1250-M29507"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 558,
                    "id_product_image": 1800,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1800",
                    "updated_at": "2025-12-02 09:55:19.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052638-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052638-01",
                    "created_at": "2025-12-02 09:55:19.000000",
                    "id_product_image_set_to_product_image": 1800,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1800
                },
                {
                    "fk_product_image_set": 558,
                    "id_product_image": 1802,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1802",
                    "updated_at": "2025-12-02 09:55:19.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/G00044636-04?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/G00044636-04",
                    "created_at": "2025-12-02 09:55:19.000000",
                    "id_product_image_set_to_product_image": 1802,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1802
                }
            ],
            "id_product_labels": [],
            "price": 21189,
            "abstract_name": "EUROKRAFT steel hand truck - Load capacity 350 kg, shovel depth 250 mm",
            "id_product_abstract": 289,
            "type": "product_abstract",
            "add_to_cart_sku": "403006",
            "prices": {
                "DEFAULT": 21189
            },
            "abstract_sku": "M5044",
            "url": "\/en\/eurokraft-stahl-sackkarre-tragfaehigkeit-350-kg-schaufeltiefe-250-mm-M5044"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 820,
                    "id_product_image": 3194,
                    "alt_text_small": "",
                    "product_image_key": "product_image_3194",
                    "updated_at": "2025-12-02 09:55:28.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00030993-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00030993-01",
                    "created_at": "2025-12-02 09:55:28.000000",
                    "id_product_image_set_to_product_image": 3194,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 3194
                }
            ],
            "id_product_labels": [
                4,
                5
            ],
            "price": 32884,
            "abstract_name": "Dauphin vertebral disc swivel chair, synchronous mechanism",
            "rating": 3.5,
            "id_product_abstract": 298,
            "review_count": 4,
            "type": "product_abstract",
            "add_to_cart_sku": "104939",
            "prices": {
                "DEFAULT": 32884,
                "ORIGINAL": 36537
            },
            "abstract_sku": "M528",
            "url": "\/en\/dauphin-bandscheiben-drehstuhl-synchronmechanik-rueckenlehnenhoehe-400-mm-M528"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 602,
                    "id_product_image": 2048,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2048",
                    "updated_at": "2025-12-02 09:55:21.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035954-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035954-01",
                    "created_at": "2025-12-02 09:55:21.000000",
                    "id_product_image_set_to_product_image": 2048,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 2048
                },
                {
                    "fk_product_image_set": 602,
                    "id_product_image": 2050,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2050",
                    "updated_at": "2025-12-02 09:55:21.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035951-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035951-01",
                    "created_at": "2025-12-02 09:55:21.000000",
                    "id_product_image_set_to_product_image": 2050,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 2050
                },
                {
                    "fk_product_image_set": 602,
                    "id_product_image": 2052,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2052",
                    "updated_at": "2025-12-02 09:55:21.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035953-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035953-01",
                    "created_at": "2025-12-02 09:55:21.000000",
                    "id_product_image_set_to_product_image": 2052,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 2052
                },
                {
                    "fk_product_image_set": 602,
                    "id_product_image": 2054,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2054",
                    "updated_at": "2025-12-02 09:55:21.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035952-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035952-01",
                    "created_at": "2025-12-02 09:55:21.000000",
                    "id_product_image_set_to_product_image": 2054,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 2054
                }
            ],
            "id_product_labels": [
                5
            ],
            "price": 31506,
            "abstract_name": "office akktiv vertebral disc swivel chair, backrest height 580 mm - point-synchronous mechanism, sliding seat",
            "id_product_abstract": 314,
            "type": "product_abstract",
            "add_to_cart_sku": "102169",
            "prices": {
                "DEFAULT": 31506,
                "ORIGINAL": 35006
            },
            "abstract_sku": "M58100",
            "url": "\/en\/office-akktiv-bandscheiben-drehstuhl-rueckenlehnenhoehe-580-mm-punktsynchron-mechanik-schiebesitz-M58100"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 634,
                    "id_product_image": 2224,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2224",
                    "updated_at": "2025-12-02 09:55:22.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00032553F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00032553F-01",
                    "created_at": "2025-12-02 09:55:22.000000",
                    "id_product_image_set_to_product_image": 2224,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 2224
                },
                {
                    "fk_product_image_set": 634,
                    "id_product_image": 2226,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2226",
                    "updated_at": "2025-12-02 09:55:22.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000027422001_PRD_org_all?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000027422001_PRD_org_all",
                    "created_at": "2025-12-02 09:55:22.000000",
                    "id_product_image_set_to_product_image": 2226,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 2226
                },
                {
                    "fk_product_image_set": 634,
                    "id_product_image": 2228,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2228",
                    "updated_at": "2025-12-02 09:55:22.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000027422856_PRD_org_all?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000027422856_PRD_org_all",
                    "created_at": "2025-12-02 09:55:22.000000",
                    "id_product_image_set_to_product_image": 2228,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 2228
                }
            ],
            "id_product_labels": [
                5
            ],
            "price": 18437,
            "abstract_name": "FRIWA conference table, round - Height 720 mm, \u00d8 1000 mm",
            "id_product_abstract": 330,
            "type": "product_abstract",
            "add_to_cart_sku": "100107",
            "prices": {
                "DEFAULT": 18437,
                "ORIGINAL": 20485
            },
            "abstract_sku": "M61240",
            "url": "\/en\/besprechungstisch-rund-hoehe-720-mm-oe-1000-mm-M61240"
        }
    ],
    "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": []
}
{}