SAP Build Challenge – Week 4 – OData Services

[Dan_Wroblewski]

This post is part of the SAP Build Community Challenge (April 2023)

We're going back to SAP Build Apps for this week's challenge.

Probably the most important thing you will do with one of your SAP Build app is to access SAP data, like in S/4HANA or SuccessFactors backends. And you will generally do this using an OData service. So we want to challenge you to use some of the OData features in the tool – for paging, filtering and sorting the data from OData calls.

In the challenge, you will start with an app we will give you, which fetches data from Northwind, and you will have to use the OData settings to bring back a specific subset of the data.

 

Eventing

As a bonus, you will also learn about SAP Build Apps eventing, since the project we give you has eventing for retrieving the data.

Since we wanted the fetching of data to occur for a variety of events, we created our own event called GetData on the page’s logic canvas, and tied the fetching to that event. Then, the event could be called from any other logic canvas.

To learn more, see:

• Trigger Event Logic
• My first steps with BTP destinations (S/4HANA) in AppGyver

 

Setup

1. Download the skeleton project called Challenge - OData.zip.gpg.
2. Create a new SAP Build Apps project.
3. Import the downloaded project by selecting History > Replace in the top-right corner, and then selecting the downloaded project.

 

Out of the box if you run the app it will look like this:

The Previous and Next buttons will not work. You will have to implement them.

We have already given you a page variable page (Number) to keep track of the current page, and a data variable Customer1 to hold the data fetched from Northwind.

 

Challenge

1. Implement the following (note that the Get record collection flow function on which you should implement these is located on the logic canvas for the page, found by selecting Page Layout from the Component Tree (lower right corner). 

   Paging	Show only 5 products per page. Set your page based on the page variable. (Optional) Set up formulas to prevent the current page from going below 1 and above the number of pages there are. (Optional) Enable/Disable the buttons based on whether there is a previous/next page.
   Filtering	Only show customers where ContactTitle is Owner.
   Sorting	Sort the records by the country and show the countries in ascending order.
   Header	Change the header to your name (Page name property of the page)

2. Add logic to the Previous and Next buttons to:
   • Increment/decrement the page variable.
   • Call the GetData event to retrieve the data.
3. When you are done, run the app, and go to Page 3, and take a screenshot. Post your screenshot.

It should look something like this (with your name, of course), but the records will be different. To accomplish the challenge, the correct records must be shown.

Good luck!

And feel free to Kudo this post and all the challenges.

Bonus Question

Add in your post the name of the animated movie in which the song "Escape" (often known as the Pina Colada song) is played, and describe in 1 sentence the scene in which it appears.

Add the movie and scene description to your entry, and then go enjoy a Pina Colada (or your favorite drink). 

[SubaR]

Hi Dan,

Thanks for this challenge, learnt a lot about Odata usage here and the concept of trigger events.

Here is the screenshot for page 3.

Also applied logic for enabling/disabling the buttons based on whether there is a previous/next page.

[HelenaFortun]

Hello Dan,

interesting challenge again...

I didn't manage to get the number of records - that is the task for week after next.

Looking forward for the last one.

Best regards!

Helena

[Dan_Wroblewski]

Glad you liked the challenge. For total count, you need to say you want the count in the paging part of the get record collection, and then you should immediately store it into a page variable. Good luck 😺

[JVLebbink]

I liked this challenge. For me getting the total count (although optional) was the most complicated part,.

[govardhansahil]

Hi @Dan_Wroblewski 

Thank you for the challenge! It was very interesting.

[Dan_Wroblewski]

Thanks for joining 😺

[staseeb]

Hi @Dan_Wroblewski ,

Here is my output over challenge No. 4

i was able to achieve optional tasks as well.

The animated movie in which the song "Escape" (often known as the Pina Colada song) is played is Shrek (2001), and it appears in a scene where Shrek and Donkey enter the castle to rescue Princess Fiona.

Thanks,

Taseeb Saeed

[Dan_Wroblewski]

That's a great job 😺

You had me all the way until you said the song was when Shrek and Donkey enter the castle ... I don;t remember that scene ... does it really play? The scene I know is when the Lord Farquaad chooses Fioni in the mirror. 

[former_member136915]

Hello Dan,

Thanks for this challenge that I could manage directly with my OData Know How and in challenge 1 and 2 acquired SAP Build knowledge.

Regarding the movie, I am not familiar with ''Shrek'' and the Pina Colada song (but I like the cocktail) and I do not know the scene “when Lord Farquaad picks Princess Fiona from the Magic Mirror's dating game as part of his plan to marry her and become king“. Thankfully many other knew this.😊

Achim

[saranraj_9021]

Hi @Dan_Wroblewski , 

Here is my submission for the 4th challenge, 

Page 3 : 

Page 1 and 4 where preview and next button is disabled respectively with formulas.

Thanks for the challenge  Dan !

[Dan_Wroblewski]

Nice work ... thanks for joining 😺

[brodierose]

Here is my Week 4 Challenge submission.

Movie: Shrek
Scene: The mirror introduces Fiona to Lord Farquaad as a princess he could marry to become a king. 

Regards, Brodie.

[P000636]

My result

Thx

[PrashantJayaram]

Hi Daniel,

Please see below:

The animated movie where the song "Escape" appears is Shrek, specifically in the scene where Farquaad is trying to find a queen for Duloc, and chooses Fiona .

[Dan_Wroblewski]

"Duloc is, Duloc is, Duloc is a perfect place." 😺

[Pamela]

Hello Daniel,

Here is my Week 4 Challenge submission.

thanks,

Pamela

[Dan_Wroblewski]

Thanks for participating ... which challenge did you enjoy the best? What did you think overall?

[hismail]

Hi Dan,

My submission for week 4.

Thank you for this amazing challenge.

[Dan_Wroblewski]

Thanks for the kind words 😺

[KarthickD]

Hi Dan,
Here is my Output for Week 4 

[Dan_Wroblewski]

Great job ... what did you think of the challenge? Hard or easy? Learned something?

[TimothySanty]

Hi Dan,

here you go:

Cheers, Timothy

[Dan_Wroblewski]

Thanks for entering 😺

[VinayKumawat]

Thanks for the details in challenge steps, it became self-explanatory. I quite enjoyed it, now only one challenge left to conquer.

though I am fan of animation movies however I did not watch Sherk, not sure why 😅

However I cannot understand by only triggering event GetData and setting paging in Get record collection handles the request for next 5 records for each page

Thanks,

Vinay

[Dan_Wroblewski]

In the page logic canvas, I have defined an event (GetData) that will retrieve data by executing Get record collection flow function ... I did this to show you the eventing feature. Show for the Next button all you have to do is trigger GetData and the records are retrieved. Is that what you are asking?

[former_member139572]

Hi Daniel,

Thanks again!

[aonunes]

Took a while but got it!

[Dan_Wroblewski]

Glad you stayed with it

[amuktha12]

Thanks for the interesting challenge.