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

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": 192,
        "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": "17"
    }
}
{
    "facets": {
        "category": {},
        "rating": {},
        "label": {},
        "farbe": {},
        "material": {},
        "brand": {},
        "merchant_name": {}
    },
    "sort": {},
    "pagination": {},
    "products": [
        {
            "images": [
                {
                    "fk_product_image_set": 430,
                    "id_product_image": 1496,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1496",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041463Y?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041463Y",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1496,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1496
                },
                {
                    "fk_product_image_set": 430,
                    "id_product_image": 1498,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1498",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041463X?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041463X",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1498,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1498
                }
            ],
            "id_product_labels": [],
            "price": 812,
            "abstract_name": "Brennenstuhl socket strip, 6-fold",
            "id_product_abstract": 226,
            "type": "product_abstract",
            "add_to_cart_sku": "425093",
            "prices": {
                "DEFAULT": 812
            },
            "abstract_sku": "M23732",
            "url": "\/en\/brennenstuhl-steckdosenleiste-6fach-M23732"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 432,
                    "id_product_image": 1500,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1500",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007314W?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007314W",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1500,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1500
                }
            ],
            "id_product_labels": [],
            "price": 3299,
            "abstract_name": "Hama card reader SuperSpeed 00039878 USB3.0, black",
            "id_product_abstract": 227,
            "type": "product_abstract",
            "add_to_cart_sku": "425123",
            "prices": {
                "DEFAULT": 3299
            },
            "abstract_sku": "M23751",
            "url": "\/en\/hama-kartenleser-superspeed-00039878-usb3-0-schwarz-M23751"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 434,
                    "id_product_image": 1502,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1502",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007021T?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007021T",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1502,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1502
                },
                {
                    "fk_product_image_set": 434,
                    "id_product_image": 1504,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1504",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007058P?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007058P",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1504,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1504
                }
            ],
            "id_product_labels": [],
            "price": 2146,
            "abstract_name": "Hama Optical Mouse Milano USB nano-receiver",
            "id_product_abstract": 228,
            "type": "product_abstract",
            "add_to_cart_sku": "425150",
            "prices": {
                "DEFAULT": 2146
            },
            "abstract_sku": "M23764",
            "url": "\/en\/hama-optical-mouse-milano-usb-nano-empfaenger-M23764"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 440,
                    "id_product_image": 1518,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1518",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006935C?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006935C",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1518,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1518
                },
                {
                    "fk_product_image_set": 440,
                    "id_product_image": 1520,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1520",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007093M?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007093M",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1520,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1520
                }
            ],
            "id_product_labels": [],
            "price": 3050,
            "abstract_name": "Hama laser mouse Mirano Wireless",
            "id_product_abstract": 231,
            "type": "product_abstract",
            "add_to_cart_sku": "425152",
            "prices": {
                "DEFAULT": 3050
            },
            "abstract_sku": "M23771",
            "url": "\/en\/hama-lasermaus-mirano-wireless-M23771"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 458,
                    "id_product_image": 1540,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1540",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007369L?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007369L",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1540,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1540
                }
            ],
            "id_product_labels": [],
            "price": 819,
            "abstract_name": "Cherry Optical Mouse GENTIX JM-0300-2 corded USB, black",
            "id_product_abstract": 240,
            "type": "product_abstract",
            "add_to_cart_sku": "426582",
            "prices": {
                "DEFAULT": 819
            },
            "abstract_sku": "M24606",
            "url": "\/en\/cherry-optical-mouse-gentix-jm-0300-2-corded-usb-schwarz-M24606"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 460,
                    "id_product_image": 1542,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1542",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007369J?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007369J",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1542,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1542
                }
            ],
            "id_product_labels": [],
            "price": 8299,
            "abstract_name": "Cherry keyboard mouse set B.UNLIMITED AES JD-0400DE-2, black",
            "id_product_abstract": 241,
            "type": "product_abstract",
            "add_to_cart_sku": "426587",
            "prices": {
                "DEFAULT": 8299
            },
            "abstract_sku": "M24609",
            "url": "\/en\/cherry-tastatur-maus-set-b-unlimited-aes-jd-0400de-2-schwarz-M24609"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 466,
                    "id_product_image": 1548,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1548",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007787B?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007787B",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1548,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1548
                }
            ],
            "id_product_labels": [],
            "price": 925,
            "abstract_name": "Cherry Optical Mouse GENTIX JM-0300-2 corded USB, white\/gray",
            "id_product_abstract": 244,
            "type": "product_abstract",
            "add_to_cart_sku": "426591",
            "prices": {
                "DEFAULT": 925
            },
            "abstract_sku": "M24613",
            "url": "\/en\/cherry-optical-mouse-gentix-jm-0300-2-corded-usb-weiss-grau-M24613"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 480,
                    "id_product_image": 1574,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1574",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845E?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845E",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1574,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1574
                },
                {
                    "fk_product_image_set": 480,
                    "id_product_image": 1576,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1576",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041168L?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041168L",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1576,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1576
                }
            ],
            "id_product_labels": [],
            "price": 3456,
            "abstract_name": "Brennenstuhl socket strip Secure-Tec 1159540376, 6-fold, anthracite",
            "id_product_abstract": 251,
            "type": "product_abstract",
            "add_to_cart_sku": "425086",
            "prices": {
                "DEFAULT": 3456
            },
            "abstract_sku": "M26415",
            "url": "\/en\/brennenstuhl-steckdosenleiste-secure-tec-1159540376-6fach-an-M26415"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 482,
                    "id_product_image": 1578,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1578",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007458Q?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007458Q",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1578,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1578
                }
            ],
            "id_product_labels": [],
            "price": 4304,
            "abstract_name": "Brennenstuhl socket strip SecureTec 1159490936, 8-fold, anthracite",
            "id_product_abstract": 252,
            "type": "product_abstract",
            "add_to_cart_sku": "425096",
            "prices": {
                "DEFAULT": 4304
            },
            "abstract_sku": "M26416",
            "url": "\/en\/brennenstuhl-steckdosenleiste-securetec-1159490936-8-fach-an-M26416"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 484,
                    "id_product_image": 1580,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1580",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007780Q?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007780Q",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1580,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1580
                }
            ],
            "id_product_labels": [],
            "price": 1637,
            "abstract_name": "Brennenstuhl socket strip Premium-Line 1951140100, 4-fold, black",
            "id_product_abstract": 253,
            "type": "product_abstract",
            "add_to_cart_sku": "425097",
            "prices": {
                "DEFAULT": 1637
            },
            "abstract_sku": "M26417",
            "url": "\/en\/brennenstuhl-steckdosenleiste-premium-line-1951140100-4fach-sw-M26417"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 6,
                    "id_product_image": 14,
                    "alt_text_small": "",
                    "product_image_key": "product_image_14",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00522202FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00522202FF-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 14,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 14
                },
                {
                    "fk_product_image_set": 6,
                    "id_product_image": 16,
                    "alt_text_small": "",
                    "product_image_key": "product_image_16",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052619-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052619-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 16,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 16
                }
            ],
            "id_product_labels": [],
            "price": 2625,
            "abstract_name": "HSM SECURIO document shredder - for desktop, 25 l, 300 watts",
            "id_product_abstract": 3,
            "type": "product_abstract",
            "add_to_cart_sku": "212440",
            "prices": {
                "DEFAULT": 2625
            },
            "abstract_sku": "M1000786",
            "url": "\/en\/hsm-aktenvernichter-securio-fuer-schreibtisch-25-l-300-watt-M1000786"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 8,
                    "id_product_image": 18,
                    "alt_text_small": "",
                    "product_image_key": "product_image_18",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00048295-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00048295-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 18,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 18
                },
                {
                    "fk_product_image_set": 8,
                    "id_product_image": 20,
                    "alt_text_small": "",
                    "product_image_key": "product_image_20",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00522206FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00522206FF-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 20,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 20
                },
                {
                    "fk_product_image_set": 8,
                    "id_product_image": 22,
                    "alt_text_small": "",
                    "product_image_key": "product_image_22",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00031340-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00031340-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 22,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 22
                }
            ],
            "id_product_labels": [],
            "price": 12938,
            "abstract_name": "HSM SECURIO document shredder - for open-plan offices, 145 l, 1800 watts",
            "id_product_abstract": 4,
            "type": "product_abstract",
            "prices": {
                "DEFAULT": 12938
            },
            "abstract_sku": "M1000838",
            "url": "\/en\/hsm-aktenvernichter-securio-fuer-grossraumbuero-145-l-1800-watt-M1000838"
        }
    ],
    "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": []
}
{}