https://oalp.xiphias-digital.com/DE/en/newsletter/subscribe

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": 276,
        "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": "24"
    }
}
{
    "facets": {
        "category": {},
        "rating": {},
        "label": {},
        "farbe": {},
        "material": {},
        "brand": {},
        "merchant_name": {}
    },
    "sort": {},
    "pagination": {},
    "products": [
        {
            "images": [
                {
                    "fk_product_image_set": 304,
                    "id_product_image": 1048,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1048",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S016958T?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S016958T",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1048,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1048
                },
                {
                    "fk_product_image_set": 304,
                    "id_product_image": 1050,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1050",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S016958U?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S016958U",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1050,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1050
                },
                {
                    "fk_product_image_set": 304,
                    "id_product_image": 1052,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1052",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007118L?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007118L",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1052,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 1052
                },
                {
                    "fk_product_image_set": 304,
                    "id_product_image": 1054,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1054",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007118S?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007118S",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1054,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 1054
                },
                {
                    "fk_product_image_set": 304,
                    "id_product_image": 1056,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1056",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007118N?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007118N",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1056,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 1056
                },
                {
                    "fk_product_image_set": 304,
                    "id_product_image": 1058,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1058",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007118R?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007118R",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1058,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 1058
                },
                {
                    "fk_product_image_set": 304,
                    "id_product_image": 1060,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1060",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007118T?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007118T",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1060,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 1060
                }
            ],
            "id_product_labels": [],
            "price": 48,
            "abstract_name": "Soennecken text market 2-5 mm chisel tip",
            "id_product_abstract": 155,
            "type": "product_abstract",
            "add_to_cart_sku": "422722",
            "prices": {
                "DEFAULT": 48
            },
            "abstract_sku": "M22398",
            "url": "\/en\/soennecken-textmarker-2-5mm-keilspitze-M22398"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 306,
                    "id_product_image": 1062,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1062",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S104009I?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S104009I",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1062,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1062
                }
            ],
            "id_product_labels": [],
            "price": 734,
            "abstract_name": "Soennecken copy paper Star DIN 80 g, white, 500 sheets\/pack.",
            "id_product_abstract": 156,
            "type": "product_abstract",
            "add_to_cart_sku": "422741",
            "prices": {
                "DEFAULT": 734
            },
            "abstract_sku": "M22410",
            "url": "\/en\/soennecken-kopierpapier-star-din-80g-weiss-500-bl-pack-M22410"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 308,
                    "id_product_image": 1064,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1064",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003705B?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003705B",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1064,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1064
                }
            ],
            "id_product_labels": [],
            "price": 734,
            "abstract_name": "Soennecken copy paper Brilliant 5800 DIN A4 80 g, white, 500 sheets\/pack.",
            "id_product_abstract": 157,
            "type": "product_abstract",
            "add_to_cart_sku": "422743",
            "prices": {
                "DEFAULT": 734
            },
            "abstract_sku": "M22411",
            "url": "\/en\/soennecken-kopierpapier-brillant-5800-din-a4-80g-weiss-500-bl-pack-M22411"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 310,
                    "id_product_image": 1066,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1066",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003002A?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003002A",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1066,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1066
                }
            ],
            "id_product_labels": [],
            "price": 1259,
            "abstract_name": "Soennecken copy paper Special DIN 80 g, white, 500 sheets\/pack.",
            "id_product_abstract": 158,
            "type": "product_abstract",
            "add_to_cart_sku": "422745",
            "prices": {
                "DEFAULT": 1259
            },
            "abstract_sku": "M22412",
            "url": "\/en\/soennecken-kopierpapier-spezial-din-80g-weiss-500-bl-pack-M22412"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 312,
                    "id_product_image": 1068,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1068",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003003A?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003003A",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1068,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1068
                },
                {
                    "fk_product_image_set": 312,
                    "id_product_image": 1070,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1070",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007409E?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007409E",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1070,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1070
                }
            ],
            "id_product_labels": [],
            "price": 576,
            "abstract_name": "Soennecken copy paper Standard DIN 80 g, white, 500 sheets\/pack.",
            "id_product_abstract": 159,
            "type": "product_abstract",
            "prices": {
                "DEFAULT": 576
            },
            "abstract_sku": "M22432",
            "url": "\/en\/soennecken-kopierpapier-standard-din-80g-weiss-500-bl-pack-M22432"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 314,
                    "id_product_image": 1072,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1072",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003006H?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003006H",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1072,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1072
                },
                {
                    "fk_product_image_set": 314,
                    "id_product_image": 1074,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1074",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007120F?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007120F",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1074,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1074
                }
            ],
            "id_product_labels": [],
            "price": 90,
            "abstract_name": "Soennecken fine refill   HB 12 pieces\/pack.",
            "id_product_abstract": 160,
            "type": "product_abstract",
            "add_to_cart_sku": "422855",
            "prices": {
                "DEFAULT": 90
            },
            "abstract_sku": "M22484",
            "url": "\/en\/soennecken-feinmine-hb-12-st-pack-M22484"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 318,
                    "id_product_image": 1088,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1088",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003050A?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003050A",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1088,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1088
                },
                {
                    "fk_product_image_set": 318,
                    "id_product_image": 1090,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1090",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S038702A?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S038702A",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1090,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1090
                },
                {
                    "fk_product_image_set": 318,
                    "id_product_image": 1092,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1092",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B032798H?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B032798H",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1092,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 1092
                },
                {
                    "fk_product_image_set": 318,
                    "id_product_image": 1094,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1094",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B032798I?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B032798I",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1094,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 1094
                },
                {
                    "fk_product_image_set": 318,
                    "id_product_image": 1096,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1096",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S038702B?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S038702B",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1096,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 1096
                }
            ],
            "id_product_labels": [],
            "price": 208,
            "abstract_name": "Soennecken disposable pens No. 1 M 10 pieces\/pack.",
            "id_product_abstract": 162,
            "type": "product_abstract",
            "add_to_cart_sku": "423105",
            "prices": {
                "DEFAULT": 208
            },
            "abstract_sku": "M22613",
            "url": "\/en\/soennecken-einwegkugelschreiber-nr-1-m-10-st-pack-M22613"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 320,
                    "id_product_image": 1098,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1098",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007415C?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007415C",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1098,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1098
                },
                {
                    "fk_product_image_set": 320,
                    "id_product_image": 1100,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1100",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B032982G?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B032982G",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1100,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1100
                },
                {
                    "fk_product_image_set": 320,
                    "id_product_image": 1102,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1102",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007415F?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007415F",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1102,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 1102
                },
                {
                    "fk_product_image_set": 320,
                    "id_product_image": 1104,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1104",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007415B?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007415B",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1104,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 1104
                },
                {
                    "fk_product_image_set": 320,
                    "id_product_image": 1106,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1106",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007415D?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007415D",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1106,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 1106
                }
            ],
            "id_product_labels": [],
            "price": 99,
            "abstract_name": "Soennecken permanent marker 1-4 mm chisel tip",
            "id_product_abstract": 167,
            "type": "product_abstract",
            "add_to_cart_sku": "423178",
            "prices": {
                "DEFAULT": 99
            },
            "abstract_sku": "M22664",
            "url": "\/en\/soennecken-permanentmarker-1-4mm-keilspitze-M22664"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 326,
                    "id_product_image": 1116,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1116",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006304C?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006304C",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1116,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1116
                },
                {
                    "fk_product_image_set": 326,
                    "id_product_image": 1118,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1118",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006304B?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006304B",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1118,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1118
                },
                {
                    "fk_product_image_set": 326,
                    "id_product_image": 1120,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1120",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006304A?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006304A",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1120,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 1120
                }
            ],
            "id_product_labels": [],
            "price": 104,
            "abstract_name": "Soennecken ballpoint pen No. 180 printing mechanism M",
            "id_product_abstract": 170,
            "type": "product_abstract",
            "add_to_cart_sku": "423456",
            "prices": {
                "DEFAULT": 104
            },
            "abstract_sku": "M22797",
            "url": "\/en\/soennecken-kugelschreiber-nr-180-druckmechanik-m-M22797"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 328,
                    "id_product_image": 1122,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1122",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046296F-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046296F-02",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1122,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1122
                },
                {
                    "fk_product_image_set": 328,
                    "id_product_image": 1124,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1124",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00704112FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00704112FF-01",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1124,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1124
                },
                {
                    "fk_product_image_set": 328,
                    "id_product_image": 1126,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1126",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00906007FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00906007FF-01",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1126,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 1126
                },
                {
                    "fk_product_image_set": 328,
                    "id_product_image": 1128,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1128",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00519690FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00519690FF-01",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1128,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 1128
                },
                {
                    "fk_product_image_set": 328,
                    "id_product_image": 1130,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1130",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00519739FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00519739FF-01",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1130,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 1130
                },
                {
                    "fk_product_image_set": 328,
                    "id_product_image": 1132,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1132",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK91863-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK91863-01",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1132,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 1132
                }
            ],
            "id_product_labels": [],
            "price": 37680,
            "abstract_name": "Mauser steel cabinet with swing doors - 4 shelves, T 500 mm",
            "id_product_abstract": 171,
            "type": "product_abstract",
            "add_to_cart_sku": "107306",
            "prices": {
                "DEFAULT": 37680
            },
            "abstract_sku": "M229",
            "url": "\/en\/mauser-stahlschrank-mit-fluegeltueren-4-fachboeden-t-500-mm-M229"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 330,
                    "id_product_image": 1134,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1134",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006847W?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006847W",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1134,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1134
                }
            ],
            "id_product_labels": [],
            "price": 4022,
            "abstract_name": "Ballpoint pen stand Mod. 1 metal silver\/black",
            "id_product_abstract": 172,
            "type": "product_abstract",
            "add_to_cart_sku": "423909",
            "prices": {
                "DEFAULT": 4022
            },
            "abstract_sku": "M23067",
            "url": "\/en\/kugelschreiberstaender-mod-1-metall-silber-schwarz-M23067"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 332,
                    "id_product_image": 1136,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1136",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007053G?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007053G",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1136,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1136
                },
                {
                    "fk_product_image_set": 332,
                    "id_product_image": 1138,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1138",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007052Z?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007052Z",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1138,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1138
                },
                {
                    "fk_product_image_set": 332,
                    "id_product_image": 1140,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1140",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007053P?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007053P",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1140,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 1140
                },
                {
                    "fk_product_image_set": 332,
                    "id_product_image": 1142,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1142",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007053E?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007053E",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1142,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 1142
                },
                {
                    "fk_product_image_set": 332,
                    "id_product_image": 1144,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1144",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007053Q?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007053Q",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1144,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 1144
                },
                {
                    "fk_product_image_set": 332,
                    "id_product_image": 1146,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1146",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007053A?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007053A",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1146,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 1146
                }
            ],
            "id_product_labels": [],
            "price": 880,
            "abstract_name": "Sigel chalk marker, 5-15 mm chisel tip",
            "id_product_abstract": 173,
            "type": "product_abstract",
            "add_to_cart_sku": "424265",
            "prices": {
                "DEFAULT": 880
            },
            "abstract_sku": "M23340",
            "url": "\/en\/sigel-kreidemarker-5-15mm-keilspitze-M23340"
        }
    ],
    "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": []
}
{}