Skip to Content

Display Data from the Northwind Service

0 %
Display Data from the Northwind Service

Display Data from the Northwind Service

The current web app already contains one view. This `MainView` serves as the outermost container, which includes two other views (each of which is a page). This tutorial shows how to add new views and data to the application.

You will learn

  • How to use a sub-generator to add an OData model to the SAPUI5 application
  • How to navigate between SAPUI5 views
  • How to configure UI5 tooling tasks

Step 1: Add a new view

Add a new view to display a list of products. For this, you can use another easy-ui5 sub-generator.

Open a new terminal session, to keep local web server running, and execute:

yo easy-ui5:newview
Parameter Value
What is the name of the new view? Products
Would you like to create a corresponding controller as well? Yes
Would you like to create a route in the manifest? Yes

The routes are added to the webapp/manifest.json file. The generator asks you whether you want to override the manifest.json file. If prompted, accept this.

Log on to answer question
Step 2: Inspect the modifications

As you can see in the log, there are two new files and one modified file. As the generator is only able to create boilerplate code, we have to make some modifications to the webapp/manifest.json application descriptor.

Open the file and replace the routing pattern of the new view with an empty string.

  "name": "Products",
  "pattern": "",
  "target": [
product route
Log on to answer question
Step 3: Enable routing
  1. The webapp/view/Mainview.view.xml will be the outer container of the application. Therefore, remove the entire content (nested tags) of the <App> tag.

    <mvc:View controllerName="tutorial.products.controller.MainView"
        <App id="idAppControl" />
  2. The newly generated view webapp/view/Products.view.xml defines one page of the whole application. Replace the current content of the view, the <App> tag, with a page that contains one list that uses an aggregation binding.

    <Page title="Available Products">
            <List items="{/Products}">
                <StandardListItem type="Active" title="{ProductName}" />
    product view

You’ll immediately be able to see that the MainView embeds the Products view and displays an empty list. The list is still empty, because there is not data source bound to the application yet.

Log on to answer question
Step 4: Add a data source

To populate the list with items, bind a data source to the application. For this, there exists another sub-generator:

You can find a list of all available sub-generator on GitHub

yo easy-ui5:newmodel
Parameter Value
What is the name of your model, press enter if it is the default model? keep blank
Which type of model do you want to add? OData
Which binding mode do you want to use? TwoWay
What is the data source URL? /V2/Northwind/Northwind.svc/
Which count mode do you want to use? Inline

Again, please accept the modification of the manifest file.

Log on to answer question
Step 5: Redirect traffic to the data source
  1. All requests to the data source will be sent to <webapp URL>/V2/Northwind/Northwind.svc/.

    Modify the approuter/xsapp.json file to redirect the traffic to a destination. Also, turn off the authentication and replace the entire file with the following content.

      "welcomeFile": "/cp.portal",
      "authenticationMethod": "none",
      "logout": {
        "logoutEndpoint": "/do/logout"
      "routes": [
          "source": "^/V2/(.*)$",
          "authenticationType": "none",
          "destination": "Northwind",
          "csrfProtection": false
  2. You already created a destination named Northwind in Cloud Foundry. Now it’s time to add a mocked destination to your local setup as well.

    Replace the empty array of the property destinations in the ui5.yaml file to declare the local destination.

      - name: "Northwind"
        url: ""
  3. Switch to the first terminal session, stop the process and restart it. Restarting is necessary because the live-reload feature doesn’t notice changes in the ui5.yaml file.

<ctrl + c>
npm start

Alternatively, you can directly invoke npx ui5 serve -o flpSandbox.html (which is equivalent to npm start or run npx ui5 serve (which won’t open a new page in the browser))

Now you should see the Northwind products in the SAPUI5 list control:

empty list
Log on to answer question
Step 6: Display more product information on a detail page

In this step, you will add a detail page that shows some additional information. Same as for the overview page, you’ll use the sub-generator to create a new view.

  1. Switch back to the second terminal session and run the same sub-generator as before.

    yo easy-ui5:newview

    Parameter Value
    What is the name of the new view? ProductDetail
    Would you like to create a corresponding controller as well? Yes
    Would you like to create a route in the manifest? Yes

    Accept that the generator can overwrite the manifest.json file.

  2. Open the webapp/manifest.json file and add the product ID to the pattern of the newly created route ProductDetail.

      "name": "ProductDetail",
      "pattern": "Product/{productId}",
      "target": [
    new route
  3. Change the type of the list items and an event listener in the webapp/view/Products.view.xml file.

    <StandardListItem type="Navigation" press="handleListItemPress" title="{ProductName}" />
    standard list item
  4. Add navigation logic to the webapp/controller/Products.controller.js to handle the press event.

    handleListItemPress: function (oEvent) {
      var oRouter = sap.ui.core.UIComponent.getRouterFor(this);
      var selectedProductId = oEvent.getSource().getBindingContext().getProperty("ProductID");
      oRouter.navTo("ProductDetail", {
        productId: selectedProductId
    handle press
  5. Click on any list item. This should trigger a navigation to a new page.

Which title do you see on the page you just navigated to?
Step 7: Add UI elements to the empty detail page
  1. Add controller logic to webapp/controller/ProductDetail.controller.js to parse selected product from the routing arguments and to bind the product to the view.

    onInit: function () {
      const oRouter = sap.ui.core.UIComponent.getRouterFor(this);
      oRouter.getRoute("ProductDetail").attachMatched(this._onRouteMatched, this);
    _onRouteMatched: function (oEvent) {
      const iProductId = oEvent.getParameter("arguments").productId;
      const oView = this.getView();
        path: "/Products(" + iProductId + ")",
        events: {
          dataRequested: function () {
          dataReceived: function () {
  2. Add the required declarations to the webapp/view/ProductDetail.view.xml view to display some properties.

    <Page title="Detail Page">
            <Text text="{ProductName}" />
            <Text text="{UnitPrice}" />
            <Text text="{QuantityPerUnit}" />
            <Text text="{UnitsInStock}" />
  3. Once you saved the view, the web app should update automatically and display a view similar to this this one.

detail view
Log on to answer question

Next Steps

Back to top