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

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": 408,
        "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": "35"
    }
}
{
    "facets": {
        "category": {},
        "rating": {},
        "label": {},
        "farbe": {},
        "material": {},
        "brand": {},
        "merchant_name": {}
    },
    "sort": {},
    "pagination": {},
    "products": [
        {
            "images": [
                {
                    "fk_product_image_set": 40,
                    "id_product_image": 134,
                    "alt_text_small": "",
                    "product_image_key": "product_image_134",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049630F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049630F-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 134,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 134
                },
                {
                    "fk_product_image_set": 40,
                    "id_product_image": 136,
                    "alt_text_small": "",
                    "product_image_key": "product_image_136",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00053202-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00053202-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 136,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 136
                },
                {
                    "fk_product_image_set": 40,
                    "id_product_image": 138,
                    "alt_text_small": "",
                    "product_image_key": "product_image_138",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049631-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049631-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 138,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 138
                }
            ],
            "id_product_labels": [],
            "price": 75337,
            "abstract_name": "Toyota Toyota pallet lift truck from TOYOTA - BT-Lifter Silent",
            "id_product_abstract": 19,
            "type": "product_abstract",
            "add_to_cart_sku": "464014",
            "prices": {
                "DEFAULT": 75337
            },
            "abstract_sku": "M1014644",
            "url": "\/en\/toyota-paletthubwagen-von-toyota-bt-lifter-silent-M1014644"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 162,
                    "id_product_image": 686,
                    "alt_text_small": "",
                    "product_image_key": "product_image_686",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006852Z?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006852Z",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 686,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 686
                },
                {
                    "fk_product_image_set": 162,
                    "id_product_image": 688,
                    "alt_text_small": "",
                    "product_image_key": "product_image_688",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007836K?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007836K",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 688,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 688
                },
                {
                    "fk_product_image_set": 162,
                    "id_product_image": 690,
                    "alt_text_small": "",
                    "product_image_key": "product_image_690",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006852Y?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006852Y",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 690,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 690
                },
                {
                    "fk_product_image_set": 162,
                    "id_product_image": 692,
                    "alt_text_small": "",
                    "product_image_key": "product_image_692",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006811L?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006811L",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 692,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 692
                },
                {
                    "fk_product_image_set": 162,
                    "id_product_image": 694,
                    "alt_text_small": "",
                    "product_image_key": "product_image_694",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007836J?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007836J",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 694,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 694
                }
            ],
            "id_product_labels": [],
            "price": 2170,
            "abstract_name": "Verbatim storage card SDHC Card Class 10",
            "id_product_abstract": 80,
            "type": "product_abstract",
            "add_to_cart_sku": "420549",
            "prices": {
                "DEFAULT": 2170
            },
            "abstract_sku": "M21090",
            "url": "\/en\/verbatim-speicherkarte-sdhc-card-class-10-M21090"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 178,
                    "id_product_image": 726,
                    "alt_text_small": "",
                    "product_image_key": "product_image_726",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007050E?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007050E",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 726,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 726
                }
            ],
            "id_product_labels": [],
            "price": 2413,
            "abstract_name": "Verbatim USB stick Store n Go V3 49174 64GB USB3.0 black\/gray",
            "id_product_abstract": 88,
            "type": "product_abstract",
            "add_to_cart_sku": "420567",
            "prices": {
                "DEFAULT": 2413
            },
            "abstract_sku": "M21101",
            "url": "\/en\/verbatim-usb-stick-storen-go-v3-49174-64gb-usb3-0-schwarz-grau-M21101"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 298,
                    "id_product_image": 1036,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1036",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007118K?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007118K",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1036,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1036
                }
            ],
            "id_product_labels": [],
            "price": 891,
            "abstract_name": "Soennecken USB stick 2.0 black\/silver",
            "id_product_abstract": 152,
            "type": "product_abstract",
            "add_to_cart_sku": "422573",
            "prices": {
                "DEFAULT": 891
            },
            "abstract_sku": "M22269",
            "url": "\/en\/soennecken-usb-stick-2-0-schwarz-silber-M22269"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 408,
                    "id_product_image": 1458,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1458",
                    "updated_at": "2025-12-02 09:55:17.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845D?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845D",
                    "created_at": "2025-12-02 09:55:17.000000",
                    "id_product_image_set_to_product_image": 1458,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1458
                },
                {
                    "fk_product_image_set": 408,
                    "id_product_image": 1460,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1460",
                    "updated_at": "2025-12-02 09:55:17.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041717C?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041717C",
                    "created_at": "2025-12-02 09:55:17.000000",
                    "id_product_image_set_to_product_image": 1460,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1460
                }
            ],
            "id_product_labels": [],
            "price": 1535,
            "abstract_name": "Brennenstuhl Kabelbox Comfort-Line 1109220, 4-fold, 3-m cable, black",
            "id_product_abstract": 215,
            "type": "product_abstract",
            "add_to_cart_sku": "425073",
            "prices": {
                "DEFAULT": 1535
            },
            "abstract_sku": "M23720",
            "url": "\/en\/brennenstuhl-kabelbox-comfort-line-1109220-4fach-3m-kabel-sw-M23720"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 490,
                    "id_product_image": 1586,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1586",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007780V?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007780V",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1586,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1586
                }
            ],
            "id_product_labels": [],
            "price": 2801,
            "abstract_name": "Brennenstuhl socket strip Premium-Line 1951100100, 10-fold, black",
            "id_product_abstract": 256,
            "type": "product_abstract",
            "add_to_cart_sku": "425100",
            "prices": {
                "DEFAULT": 2801
            },
            "abstract_sku": "M26420",
            "url": "\/en\/brennenstuhl-steckdosenleiste-premium-line-1951100100-10fach-sw-M26420"
        }
    ],
    "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": []
}
{}