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

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": 168,
        "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": "15"
    }
}
{
    "facets": {
        "category": {},
        "rating": {},
        "label": {},
        "farbe": {},
        "material": {},
        "brand": {},
        "merchant_name": {}
    },
    "sort": {},
    "pagination": {},
    "products": [
        {
            "images": [
                {
                    "fk_product_image_set": 670,
                    "id_product_image": 2392,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2392",
                    "updated_at": "2025-12-02 09:55:23.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00011896F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00011896F-01",
                    "created_at": "2025-12-02 09:55:23.000000",
                    "id_product_image_set_to_product_image": 2392,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 2392
                },
                {
                    "fk_product_image_set": 670,
                    "id_product_image": 2394,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2394",
                    "updated_at": "2025-12-02 09:55:23.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00016322-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00016322-01",
                    "created_at": "2025-12-02 09:55:23.000000",
                    "id_product_image_set_to_product_image": 2394,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 2394
                },
                {
                    "fk_product_image_set": 670,
                    "id_product_image": 2396,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2396",
                    "updated_at": "2025-12-02 09:55:23.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK91600-03?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK91600-03",
                    "created_at": "2025-12-02 09:55:23.000000",
                    "id_product_image_set_to_product_image": 2396,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 2396
                }
            ],
            "id_product_labels": [
                4
            ],
            "price": 22931,
            "abstract_name": "Rectangular table, rectangular tubing - 1600 x 800 mm",
            "rating": 4.25,
            "id_product_abstract": 348,
            "review_count": 4,
            "type": "product_abstract",
            "prices": {
                "DEFAULT": 22931
            },
            "abstract_sku": "M719",
            "url": "\/en\/rechtecktisch-vierkantrohr-1600-x-800-mm-M719"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 702,
                    "id_product_image": 2566,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2566",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00044316-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00044316-01",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2566,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 2566
                },
                {
                    "fk_product_image_set": 702,
                    "id_product_image": 2568,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2568",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00044317-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00044317-01",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2568,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 2568
                },
                {
                    "fk_product_image_set": 702,
                    "id_product_image": 2570,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2570",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00044318-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00044318-01",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2570,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 2570
                },
                {
                    "fk_product_image_set": 702,
                    "id_product_image": 2572,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2572",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00044319-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00044319-01",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2572,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 2572
                },
                {
                    "fk_product_image_set": 702,
                    "id_product_image": 2574,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2574",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610611II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610611II-01",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2574,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 2574
                },
                {
                    "fk_product_image_set": 702,
                    "id_product_image": 2576,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2576",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610612II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610612II-02",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2576,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 2576
                },
                {
                    "fk_product_image_set": 702,
                    "id_product_image": 2578,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2578",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610612II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610612II-01",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2578,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 2578
                }
            ],
            "id_product_labels": [
                5
            ],
            "price": 71077,
            "abstract_name": "Topstar operator swivel chair, can carry up to 150 kg - point synchronous mechanism, sliding seat, headrest",
            "id_product_abstract": 364,
            "type": "product_abstract",
            "add_to_cart_sku": "101940",
            "prices": {
                "DEFAULT": 71077,
                "ORIGINAL": 78974
            },
            "abstract_sku": "M74907",
            "url": "\/en\/topstar-operator-drehstuhl-belastbar-bis-150-kg-punktsynchron-mechanik-schiebesitz-kopfstuetze-M74907"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 734,
                    "id_product_image": 2804,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2804",
                    "updated_at": "2025-12-02 09:55:26.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00011896F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00011896F-01",
                    "created_at": "2025-12-02 09:55:26.000000",
                    "id_product_image_set_to_product_image": 2804,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 2804
                },
                {
                    "fk_product_image_set": 734,
                    "id_product_image": 2806,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2806",
                    "updated_at": "2025-12-02 09:55:26.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00016322-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00016322-01",
                    "created_at": "2025-12-02 09:55:26.000000",
                    "id_product_image_set_to_product_image": 2806,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 2806
                },
                {
                    "fk_product_image_set": 734,
                    "id_product_image": 2808,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2808",
                    "updated_at": "2025-12-02 09:55:26.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK91600-03?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK91600-03",
                    "created_at": "2025-12-02 09:55:26.000000",
                    "id_product_image_set_to_product_image": 2808,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 2808
                }
            ],
            "id_product_labels": [],
            "price": 29793,
            "abstract_name": "Rectangular table, rectangular tubing, chromed - 1600 x 800 mm",
            "id_product_abstract": 380,
            "type": "product_abstract",
            "add_to_cart_sku": "102922",
            "prices": {
                "DEFAULT": 29793
            },
            "abstract_sku": "M771",
            "url": "\/en\/rechtecktisch-rundrohr-verchromt-1600-x-800-mm-M771"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 760,
                    "id_product_image": 2910,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2910",
                    "updated_at": "2025-12-02 09:55:26.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00003913F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00003913F-01",
                    "created_at": "2025-12-02 09:55:26.000000",
                    "id_product_image_set_to_product_image": 2910,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 2910
                },
                {
                    "fk_product_image_set": 760,
                    "id_product_image": 2912,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2912",
                    "updated_at": "2025-12-02 09:55:26.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00895164FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00895164FF-01",
                    "created_at": "2025-12-02 09:55:26.000000",
                    "id_product_image_set_to_product_image": 2912,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 2912
                },
                {
                    "fk_product_image_set": 760,
                    "id_product_image": 2914,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2914",
                    "updated_at": "2025-12-02 09:55:26.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00895172FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00895172FF-01",
                    "created_at": "2025-12-02 09:55:26.000000",
                    "id_product_image_set_to_product_image": 2914,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 2914
                },
                {
                    "fk_product_image_set": 760,
                    "id_product_image": 2916,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2916",
                    "updated_at": "2025-12-02 09:55:26.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00926937FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00926937FF-01",
                    "created_at": "2025-12-02 09:55:26.000000",
                    "id_product_image_set_to_product_image": 2916,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 2916
                }
            ],
            "id_product_labels": [
                4
            ],
            "price": 56140,
            "abstract_name": "Wolf steel cabinet - wide storage cabinet, with base plinth",
            "id_product_abstract": 396,
            "type": "product_abstract",
            "add_to_cart_sku": "507871",
            "prices": {
                "DEFAULT": 56140
            },
            "abstract_sku": "M859",
            "url": "\/en\/wolf-stahlschrank-lagerschrank-breit-mit-bodensockel-M859"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 22,
                    "id_product_image": 68,
                    "alt_text_small": "",
                    "product_image_key": "product_image_68",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756515II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756515II-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 68,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 68
                }
            ],
            "id_product_labels": [],
            "price": 13725,
            "abstract_name": "magnetoplan\u00ae Flipchart JUNIOR PLUS - writing surface 680 x 980 mm, magnetic",
            "id_product_abstract": 11,
            "type": "product_abstract",
            "add_to_cart_sku": "517598",
            "prices": {
                "DEFAULT": 13725
            },
            "abstract_sku": "M1013168",
            "url": "\/en\/magnetoplan-flipchart-junior-plus-schreibflaeche-680-x-980-mm-magnethaftend-M1013168"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 98,
                    "id_product_image": 318,
                    "alt_text_small": "",
                    "product_image_key": "product_image_318",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051143F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051143F-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 318,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 318
                },
                {
                    "fk_product_image_set": 98,
                    "id_product_image": 320,
                    "alt_text_small": "",
                    "product_image_key": "product_image_320",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051148-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051148-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 320,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 320
                }
            ],
            "id_product_labels": [],
            "price": 9929,
            "abstract_name": "IDEAL document shredder, small, SHREDCAT - Collecting volume 18 l",
            "id_product_abstract": 47,
            "type": "product_abstract",
            "add_to_cart_sku": "574969",
            "prices": {
                "DEFAULT": 9929
            },
            "abstract_sku": "M1028095",
            "url": "\/en\/ideal-aktenvernichter-klein-shredcat-auffangvolumen-18-l-M1028095"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 250,
                    "id_product_image": 920,
                    "alt_text_small": "",
                    "product_image_key": "product_image_920",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010717Q?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010717Q",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 920,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 920
                }
            ],
            "id_product_labels": [],
            "price": 442,
            "abstract_name": "Clairefontaine Collegeblock 8279C DIN A4 checkered, 80 sheets, white",
            "id_product_abstract": 128,
            "type": "product_abstract",
            "add_to_cart_sku": "421426",
            "prices": {
                "DEFAULT": 442
            },
            "abstract_sku": "M21711",
            "url": "\/en\/clairefontaine-collegeblock-8279c-din-a4-kariert-80blatt-weiss-M21711"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 348,
                    "id_product_image": 1212,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1212",
                    "updated_at": "2025-12-02 09:55:16.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S016958A?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S016958A",
                    "created_at": "2025-12-02 09:55:16.000000",
                    "id_product_image_set_to_product_image": 1212,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1212
                },
                {
                    "fk_product_image_set": 348,
                    "id_product_image": 1214,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1214",
                    "updated_at": "2025-12-02 09:55:16.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S016958B?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S016958B",
                    "created_at": "2025-12-02 09:55:16.000000",
                    "id_product_image_set_to_product_image": 1214,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1214
                },
                {
                    "fk_product_image_set": 348,
                    "id_product_image": 1216,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1216",
                    "updated_at": "2025-12-02 09:55:16.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S016957Z?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S016957Z",
                    "created_at": "2025-12-02 09:55:16.000000",
                    "id_product_image_set_to_product_image": 1216,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 1216
                },
                {
                    "fk_product_image_set": 348,
                    "id_product_image": 1218,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1218",
                    "updated_at": "2025-12-02 09:55:16.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S016957Y?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S016957Y",
                    "created_at": "2025-12-02 09:55:16.000000",
                    "id_product_image_set_to_product_image": 1218,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 1218
                },
                {
                    "fk_product_image_set": 348,
                    "id_product_image": 1220,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1220",
                    "updated_at": "2025-12-02 09:55:16.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007678O?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007678O",
                    "created_at": "2025-12-02 09:55:16.000000",
                    "id_product_image_set_to_product_image": 1220,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 1220
                },
                {
                    "fk_product_image_set": 348,
                    "id_product_image": 1222,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1222",
                    "updated_at": "2025-12-02 09:55:16.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007678P?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007678P",
                    "created_at": "2025-12-02 09:55:16.000000",
                    "id_product_image_set_to_product_image": 1222,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 1222
                }
            ],
            "id_product_labels": [],
            "price": 213,
            "abstract_name": "Schneider Fineliner Xpress 0.8 mm",
            "id_product_abstract": 181,
            "type": "product_abstract",
            "add_to_cart_sku": "424409",
            "prices": {
                "DEFAULT": 213
            },
            "abstract_sku": "M23444",
            "url": "\/en\/schneider-fineliner-xpress-s-0-8mm-M23444"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 410,
                    "id_product_image": 1462,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1462",
                    "updated_at": "2025-12-02 09:55:17.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006133I?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006133I",
                    "created_at": "2025-12-02 09:55:17.000000",
                    "id_product_image_set_to_product_image": 1462,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1462
                }
            ],
            "id_product_labels": [],
            "price": 2123,
            "abstract_name": "Brennenstuhl Kabelbox Vario-Line 1092200, 4-fold, 5-m cable, black",
            "id_product_abstract": 216,
            "type": "product_abstract",
            "add_to_cart_sku": "425074",
            "prices": {
                "DEFAULT": 2123
            },
            "abstract_sku": "M23721",
            "url": "\/en\/brennenstuhl-kabelbox-vario-line-1092200-4fach-5m-kabel-schwarz-M23721"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 486,
                    "id_product_image": 1582,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1582",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007780R?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007780R",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1582,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1582
                }
            ],
            "id_product_labels": [],
            "price": 1998,
            "abstract_name": "Brennenstuhl socket strip Premium-Line 1951160100, 6-fold, black",
            "id_product_abstract": 254,
            "type": "product_abstract",
            "add_to_cart_sku": "425098",
            "prices": {
                "DEFAULT": 1998
            },
            "abstract_sku": "M26418",
            "url": "\/en\/brennenstuhl-steckdosenleiste-premium-line-1951160100-6fach-sw-M26418"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 518,
                    "id_product_image": 1646,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1646",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124217II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124217II-01",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1646,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1646
                },
                {
                    "fk_product_image_set": 518,
                    "id_product_image": 1648,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1648",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124217II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124217II-02",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1648,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1648
                }
            ],
            "id_product_labels": [
                4
            ],
            "price": 11434,
            "abstract_name": "Safescan Automatisches Falschgeld-Pr\u00fcfger\u00e4t - SAFESCAN 155-S",
            "rating": 4,
            "id_product_abstract": 270,
            "review_count": 5,
            "type": "product_abstract",
            "add_to_cart_sku": "419901",
            "prices": {
                "DEFAULT": 11434
            },
            "abstract_sku": "M29526",
            "url": "\/en\/automatisches-falschgeld-pruefgeraet-safescan-155-s-M29526"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 524,
                    "id_product_image": 1658,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1658",
                    "updated_at": "2025-12-02 09:55:19.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000023448812_PRD_org_all?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000023448812_PRD_org_all",
                    "created_at": "2025-12-02 09:55:19.000000",
                    "id_product_image_set_to_product_image": 1658,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1658
                },
                {
                    "fk_product_image_set": 524,
                    "id_product_image": 1660,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1660",
                    "updated_at": "2025-12-02 09:55:19.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000023448813_PRD_org_all?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000023448813_PRD_org_all",
                    "created_at": "2025-12-02 09:55:19.000000",
                    "id_product_image_set_to_product_image": 1660,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1660
                }
            ],
            "id_product_labels": [],
            "price": 1000108,
            "abstract_name": "HSM conveyor belt document shredder, POWERLINE FA 400.2 - collecting volume 460 l, strip width",
            "id_product_abstract": 273,
            "type": "product_abstract",
            "add_to_cart_sku": "621614",
            "prices": {
                "DEFAULT": 1000108
            },
            "abstract_sku": "M29929",
            "url": "\/en\/hsm-foerderband-aktenvernichter-powerline-fa-400-2-auffangvolumen-460-l-streifenschnitt-M29929"
        }
    ],
    "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": []
}
{}