SAP Business Application Studio add Data Source

Hi Yuval Morad, thanks for your help.

The values in xs-app.json and mta.yaml was added manually, not by the Template Generator because I could not find the destination through the Generator.

Heres my answers to your questions:

Which template did you use to create the UI?

R: SAP Fiori Freestyle Project: "SAPUI5 Application"

Which target runtime did you choose? CF or ABAP?

R: CF

In case of CF, did you use central approuter or standalone approuter

R: Standalone approuter

1. in xs-app.json you have a route to a destination

R:

{
    "authenticationMethod": "none",
    "routes": [
        {
            "source": "(.*)(.xsodata)",
            "destination": "fcf7b533HanaDB"
        },
        {
            "source": "^/V2/(.*)$",
            "destination": "northwind_api"
        }
    ]
}<strong><br></strong>

2. In MTA.yaml in case it is CF project, you have destination resource and approuter module requires the destination

R:

(...)
modules:
- name: fiori20201129-approuter
  type: approuter.nodejs
  path: fiori20201129-approuter
  requires:
  - name: fioribank_destination
  - name: fiori20201129_html_repo_runtime
(...)
resources:
- name: fioribank_destination
  type: org.cloudfoundry.managed-service
  parameters:
    service: destination
    service-plan: lite
(...)<br>

OBS.: The Destination did work in the deployed application, my problem is to make it work inside the SAP Business Application Studio.

Destination fcf7b533HanaDB

Destination northwind_api

My calls are not in the manifest.json, they are in the controller, this is for test purpouses.

callNorthwind: function() {
  new sap.ui.model.odata.v2.ODataModel("/V2/Northwind/Northwind.svc/");
},
callfcf7b533HanaDB: function() {
  new sap.ui.model.odata.v2.ODataModel("/odata/catalog.xsodata");
}<br>

The data source now is on the screen of SAP Business Application Studio (I've added the "required" destination in mta.yaml to the wrong module, when I added it to the HTML5Module, it worked).

The problem now is that even with data sources destination active in Business Application Studio, my requests are given me 503.

I don't know exactly what was wrong, but I was able to fix it with a new project.

I just added the router section in the xs-app.json, added a "destination" as a "resource" in the mta.yaml file and final step was adding this destination in the "require" section of my HTML5Module in the mta.yaml (This destinations not necessarily need to exist on CF, but it need to be on the mta.yaml).

The only thing that is different now, is my xs-app.json (that now it looks like the code below). Maybe my "source" regex was wrong, maybe the "source" and "destination" need to have the same name. I'm not sure, but now it works.

{
    "welcomeFile": "/index.html",
    "authenticationMethod": "none",
    "logout": {
        "logoutEndpoint": "/do/logout"
    },
    "routes": [
        {
            "authenticationType": "none",
            "csrfProtection": false,
            "source": "^/fcf7b533HanaDB/(.*)$",
            "destination": "fcf7b533HanaDB",
            "target": "$1"
        },
        {
            "authenticationType": "none",
            "csrfProtection": false,
            "source": "^/northwind_api/(.*)$",
            "destination": "northwind_api",
            "target": "$1"
        },
        {
            "source": "^(.*)$",
            "target": "$1",
            "service": "html5-apps-repo-rt",
            "authenticationType": "xsuaa"
        }
    ]
}