🌟 🕒 30 mins
In the next step we want to integrate the Ordered Items in Excel. Use OData v2 instead of OData v4 to verify legacy support. Luckily creating an OData v2 services from default v4 is just a click away with RAP.
http://13.81.170.205:50000/sap/opu/odata/sap/ZUI_ONLINESHOP_MS1_O2/Online_Shop Note - As before we are using here HTTP and Port 50000 (not HTTPS), because we have not configured any certificates.
The video shall provide hints where lore, poetic code snippets, and narrative cannot.
- Open Microsoft Excel (You can either install Office on the VM as mentioned before, or for this Quest you can also easily use Excel installed on your PC)
Note - If you use your Excel installed on your local computer, please use this URL instead (the 13.81.170.205 requires you to have an entry in our etc/hosts file)
http://13.81.170.205:50000/sap/opu/odata/sap/ZUI_ONLINESHOP_MS1_O2/Online_Shop - From a clean Excel Worksheet, navigate to Data and select Get Data -> Open From Other Sources -> From OData Feed
- When prompted enter the URL
http://13.81.170.205:50000/sap/opu/odata/sap/ZUI_ONLINESHOP_MS1_O2/Online_Shop
Note - you can also open this URL in a browser first to validate that you get the Ordered Items in JSON
- In order to authenticate with the SAP System, select Basic and enter your SAP Username and Password
- In the preview screen you could now filter and transform the data. We will leave it as is, and just click on Load
- As a results we have the live data from the SAP system in Excel. If you go back and create another order item in the Online Shop , you can just click on Refresh and get the latest data from SAP.
