Example 1: Use OData Actions in an Application
You can execute OData (V4) actions exposed by a connected on-premise SAP S/4HANA
system within an analytic application.
Prerequisites
You have created an analytic application and have added an OData service to your
application.
Context
In this example you see the following elements for ODataService_1:
-
The system: FUB
-
The end-point URL for the OData service
-
As metadata, the OData version and two actions,
Flight/Book and
CancelMyFlights
Procedure
-
Insert a Button widget and change the text of the button
to Cancel Flight in the Properties
of the Styling panel.
-
Start the script editor by clicking in the quick actions menu of
the widget.
You will be creating a script to trigger execution of the OData action in the
source system.
-
Type in the name of the OData service you have added and specified.
The script editor assists you with code completion and value help wherever
possible when you click
CTRL
+ Space
. In the script editor, do the following:
-
Type in the name of the OData Service:
ODataService_1, followed by
.
-
Press
CTRL
+ Space
, then select the function
executeAction().
-
Place the mouse cursor between the brackets ( () ) and press
CTRL
+ Space
, then select action CancelMyFlights from
the value help of executeAction(), followed by
, and {}. Select
Action CancelMyFlights from value help of
executeAction() by placing the cursor between
the brackets ( () )and
CTRL
+ Space
, followed by, and
{}.
-
Place the mouse cursor between the brackets ({}), then press
CTRL
+ Space
to select the parameter DateFrom from
value help,, followed by : .
-
Type in the date 2019-01-01, followed by
,.
-
Press
CTRL
+ Space
and select DateTo from value help,
folllowed by :.
-
Type in the date 2019-12-31 and finish with
;.
You have created a script to execute an OData action. This action has a
simple syntax with two parameters and looks like this:
ODataService_1.executeAction("CancelMyFlights", {DateFrom: "2019-01-01", DateTo: "2019-12-31"});
-
Insert another button, rename it to Book Flight in the
Styling panel, and open the script editor.
The BookFlight Action is a bound action which is more
complex than the first one.
-
Type in the following script in the script editor by using code completion and
value help:
ODataService_1.executeAction("Flight/Book", {Flight:{Airline:"UA",Flightconnection:"0941", Flightdate: "2019-01-05"},NumberOfSeats: 1});
Results
You finished a simple OData action and a second one that is
more complex. Now you can run your application and book and cancel flights for the
selected values.
You can enhance your application and start using other script
methods to fill the parameter values dynamically with local or global variables.
Finally, you can make the response from the backend system visible in the
application by writing the response as a message in a text field.
To find out
how to do this, see Example 2: Using OData Actions in an Application