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"
                        }
                    },
                    {
                        "term": {
                            "category.all-parents": {
                                "value": "30",
                                "boost": 1
                            }
                        }
                    }
                ]
            }
        },
        "suggest": {
            "text": ""
        },
        "_source": [
            "search-result-data"
        ],
        "sort": [
            {
                "integer-sort.category:30": {
                    "order": "ASC",
                    "mode": "min",
                    "unmapped_type": "integer"
                }
            }
        ],
        "from": 0,
        "size": 12,
        "aggs": {
            "category.all-parents.category": {
                "terms": {
                    "field": "category.all-parents",
                    "size": 1000
                }
            },
            "global-category": {
                "global": {},
                "aggs": {
                    "filter": {
                        "filter": {
                            "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"
                                        }
                                    }
                                ]
                            }
                        },
                        "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": {
        "category": 30
    }
}
{
    "facets": {
        "category": {},
        "rating": {},
        "label": {},
        "farbe": {},
        "material": {},
        "brand": {},
        "merchant_name": {}
    },
    "sort": {},
    "pagination": {},
    "products": [
        {
            "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": 416,
                    "id_product_image": 1470,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1470",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041461Q?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041461Q",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1470,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1470
                },
                {
                    "fk_product_image_set": 416,
                    "id_product_image": 1472,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1472",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041461R?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041461R",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1472,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1472
                }
            ],
            "id_product_labels": [],
            "price": 959,
            "abstract_name": "Brennenstuhl extension cable 5 m",
            "id_product_abstract": 219,
            "type": "product_abstract",
            "prices": {
                "DEFAULT": 959
            },
            "abstract_sku": "M23724",
            "url": "\/en\/brennenstuhl-verlaengerungskabel-5m-M23724"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 428,
                    "id_product_image": 1492,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1492",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041463U?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041463U",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1492,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1492
                },
                {
                    "fk_product_image_set": 428,
                    "id_product_image": 1494,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1494",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041463T?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041463T",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1494,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1494
                }
            ],
            "id_product_labels": [],
            "price": 540,
            "abstract_name": "Brennenstuhl socket strip, 3-fold",
            "id_product_abstract": 225,
            "type": "product_abstract",
            "add_to_cart_sku": "425090",
            "prices": {
                "DEFAULT": 540
            },
            "abstract_sku": "M23731",
            "url": "\/en\/brennenstuhl-steckdosenleiste-3fach-M23731"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 418,
                    "id_product_image": 1474,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1474",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041461R?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041461R",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1474,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1474
                },
                {
                    "fk_product_image_set": 418,
                    "id_product_image": 1476,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1476",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041461Q?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041461Q",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1476,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1476
                }
            ],
            "id_product_labels": [],
            "price": 1784,
            "abstract_name": "Brennenstuhl extension cable 10 m",
            "id_product_abstract": 220,
            "type": "product_abstract",
            "prices": {
                "DEFAULT": 1784
            },
            "abstract_sku": "M23725",
            "url": "\/en\/brennenstuhl-verlaengerungskabel-10m-M23725"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 420,
                    "id_product_image": 1478,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1478",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845B?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845B",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1478,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1478
                },
                {
                    "fk_product_image_set": 420,
                    "id_product_image": 1480,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1480",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041614C?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041614C",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1480,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1480
                }
            ],
            "id_product_labels": [],
            "price": 1944,
            "abstract_name": "Brennenstuhl socket strip Alu-Line 1391000014, 4-fold, black",
            "id_product_abstract": 221,
            "type": "product_abstract",
            "add_to_cart_sku": "425083",
            "prices": {
                "DEFAULT": 1944
            },
            "abstract_sku": "M23726",
            "url": "\/en\/brennenstuhl-steckdosenleiste-alu-line-1391000014-4fach-sw-M23726"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 422,
                    "id_product_image": 1482,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1482",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845F?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845F",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1482,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1482
                },
                {
                    "fk_product_image_set": 422,
                    "id_product_image": 1484,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1484",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041614D?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041614D",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1484,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1484
                }
            ],
            "id_product_labels": [],
            "price": 2677,
            "abstract_name": "Brennenstuhl socket strip Alu-Line 1391000016, 6-fold, black",
            "id_product_abstract": 222,
            "type": "product_abstract",
            "add_to_cart_sku": "425084",
            "prices": {
                "DEFAULT": 2677
            },
            "abstract_sku": "M23727",
            "url": "\/en\/brennenstuhl-steckdosenleiste-alu-line-1391000016-6fach-sw-M23727"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 424,
                    "id_product_image": 1486,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1486",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006668J?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006668J",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1486,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1486
                }
            ],
            "id_product_labels": [],
            "price": 2575,
            "abstract_name": "Brennenstuhl socket strip Eco-Line 1159750015, 6-fold, gray",
            "id_product_abstract": 223,
            "type": "product_abstract",
            "add_to_cart_sku": "425087",
            "prices": {
                "DEFAULT": 2575
            },
            "abstract_sku": "M23729",
            "url": "\/en\/brennenstuhl-steckdosenleiste-eco-line-1159750015-6fach-grau-M23729"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 426,
                    "id_product_image": 1488,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1488",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041463V?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041463V",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1488,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1488
                },
                {
                    "fk_product_image_set": 426,
                    "id_product_image": 1490,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1490",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041463W?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041463W",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1490,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1490
                }
            ],
            "id_product_labels": [],
            "price": 473,
            "abstract_name": "Brennenstuhl socket strip, 3-fold",
            "id_product_abstract": 224,
            "type": "product_abstract",
            "add_to_cart_sku": "425088",
            "prices": {
                "DEFAULT": 473
            },
            "abstract_sku": "M23730",
            "url": "\/en\/brennenstuhl-steckdosenleiste-3fach-M23730"
        },
        {
            "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": 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"
        }
    ],
    "spellingSuggestion": null,
    "categoryTreeFilter": {
        "0": {},
        "1": {},
        "2": {},
        "3": {},
        "4": {},
        "5": {}
    }
}