topic Re: Task 8 - Responding to an OData query with navigation (July Developer Challenge - "Reverse in Application Development and Automation Discussions

Task 8 - Responding to an OData query with navigation (July Developer Challenge - "Reverse APIs")

qmacro — Wed, 24 Jul 2024 06:44:10 GMT

This is a task in the July Developer Challenge - "Reverse APIs".

This time, a simple one that should take you no time! After the previous task where you created a brand new Northbreeze service, complete with data (right?), as well as implementing the first API endpoint in that new service, this task is designed to give you a bit of a break, and to allow you to reflect on the power that CAP gives you out of the box, and on just some of the many wondrous aspects of OData.

Background

With all the functions and actions you've had to define and implement so far, it's easy to forget what CAP gives you for free, when creating and serving services. And in terms of support for OData, a very accomplished and "complete" protocol, it is second to none, particularly with regards to the mechanisms you get for free.

The requirements

Here are the specific requirements for this task. Your Northbreeze service, still served via the OData V4 protocol, must respond appropriately to an OData QUERY operation that expresses a navigation from one entity to a related one, in the resource path. Specifically, it must respond to a request for an entity set of the Products belonging to a particular Supplier (see the Northwind and Northbreeze section of the previous task for details on these entity types).

In other words, your service needs to return an entity set containing products, for a specific supplier.

Some examples

Using the standard Northwind service, here are a couple of examples of that.

First, a list of the products belonging to the supplier with ID 22 ("Zaanse Snoepfabriek"): /Suppliers(22)/Products, which should produce:

{
  "@odata.context": "https://services.odata.org/V4/Northwind/Northwind.svc/$metadata#Products",
  "value": [
    {
      "ProductID": 47,
      "ProductName": "Zaanse koeken",
      "SupplierID": 22,
      "CategoryID": 3,
      "QuantityPerUnit": "10 - 4 oz boxes",
      "UnitPrice": 9.5000,
      "UnitsInStock": 36,
      "UnitsOnOrder": 0,
      "ReorderLevel": 0,
      "Discontinued": false
    },
    {
      "ProductID": 48,
      "ProductName": "Chocolade",
      "SupplierID": 22,
      "CategoryID": 3,
      "QuantityPerUnit": "10 pkgs.",
      "UnitPrice": 12.7500,
      "UnitsInStock": 15,
      "UnitsOnOrder": 70,
      "ReorderLevel": 25,
      "Discontinued": false
    }
  ]
}

Next, the products for supplier "Tokyo Traders" (ID 4), but just the product name and unit price: /Suppliers(4)/Products?$select=ProductName,UnitPrice, which should produce:

{
  "@odata.context": "https://services.odata.org/V4/Northwind/Northwind.svc/$metadata#Products(ProductName,UnitPrice)",
  "value": [
    {
      "ProductName": "Mishi Kobe Niku",
      "UnitPrice": 97.0000
    },
    {
      "ProductName": "Ikura",
      "UnitPrice": 31.0000
    },
    {
      "ProductName": "Longlife Tofu",
      "UnitPrice": 10.0000
    }
  ]
}

Back to the requirements

So your service must do this too. The great thing is, if you've set up your Northbreeze service as I recommended in the previous task (i.e. starting from a clone of the Northbreeze repo, then you're already set, and don't need to do anything specific to have the TESTER successfully test this in your service. That's thanks to the power of CAP.

The service must be served using the OData V4 protocol, with the (default) path prefix /odata/v4 plus the service name northbreeze, and return an entity set of products belonging to a given supplier. Those products must be the correct ones (for example, products "Zaanse koeken" and "Chocolade" are the two products for supplier "Zaanse Snoepfabriek" (ID 22) and have the same IDs as they have in Northwind (as the TESTER will be checking the products returned in the entity set and examining the order of their IDs).

And that's it!

As there is, in theory, nothing more for you to do in this task (except to submit to the TESTER as usual, see below), if you've correctly implemented the service for the previous task already, then why not use the remainder of your coffee time to consider the power of OData, and think about the answers to the following questions:

First, the Northwind service only allows the "traditional" OData key specification in the the resource path, e.g. /Suppliers(7) and not the more recent Key-as-Segment style. Does your Northbreeze service, powered by CAP, support that? What does that look like?

While we're talking about resource paths, what about going one level deeper - is that supported? For example, Northwind supports paths such as /Products(70)/Category/CategoryName to get just the name of the category to which the product with ID 70 belongs. Does CAP support that too - can you do it with your Northbreeze service?

Even what one might think should be single scalar value responses, such as a category name like Beverages, come delivered inside some wrapping, by default in either an XML representation in the case of Northwind (extra whitespace added for readability):

<m:value 
    xmlns:d="http://docs.oasis-open.org/odata/ns/data" 
    xmlns:georss="http://www.georss.org/georss" 
    xmlns:gml="http://www.opengis.net/gml" 
    xmlns:m="http://docs.oasis-open.org/odata/ns/metadata" 
    m:context="https://services.odata.org/V4/Northwind/Northwind.svc/$metadata#Products(70)/Category/CategoryName">
    Beverages
</m:value>

or in a JSON representation in the case of the CAP powered Northbreeze equivalent:

{
  "@odata.context": "../../$metadata#Categories(1)/CategoryName",
  "value": "Beverages"
}

What if you wanted just the scalar value Beverages? Is that possible? If so, how?

On these questions and any related ones that occur to you - be sure to put your thoughts in the comments below!

Submitting to the TESTER

Now you're ready to submit your CANDIDATE service to the TESTER!

The payload

The task identifier you need to supply in the payload of your submission is: northbreeze-Products.

You'll have already done this sort of thing previously so just head back there for the more detailed instructions if you need them, or to the the section titled "The Tester service, and making a test request" in the main challenge blog post.

You'll need to submit a JSON payload like this:

{
  "communityid": "<your-community-id>",
  "serviceurl": "<the-URL-of-your-service>",
  "task": "northbreeze-Products"
}

And, just as with the previous (and all further tasks):

the value for the communityid property should be your ID on this SAP Community platform (e.g. mine is "qmacro")
the value for the serviceurl property should be the absolute URL (i.e. including the scheme), of your CANDIDATE service.

That's it!

Logging of test results

Remember that you can check on your progress, and the progress of your fellow participants - all requests are logged and are available in an entity set served by the TESTER service. The entity set URL is https://developer-challenge-2024-07.cfapps.eu10.hana.ondemand.com/tester/Testlog and being an OData V4 entity set, all the normal OData system query options are available to you for digging into that information.

Until the next task, have fun, and if you have any questions or comments, leave them below!

Re: Task 8 - Responding to an OData query with navigation (July Developer Challenge - "Reverse

Liyon_SV — Wed, 24 Jul 2024 08:15:48 GMT

Still thinking about those additional questions.

Re: Task 8 - Responding to an OData query with navigation (July Developer Challenge - "Reverse

cguttikonda24 — Wed, 24 Jul 2024 09:00:15 GMT

Hello DJ @qmacro ,

Here is my observation.

1. Calling the entity with Key-as-Segmen is possible in CAP, as it is supporting oData v4 out-of the box.

2 To read just the scalar values, we can use the $value get the data.

odata/v4/northbreeze/Products/11/Category/CategoryName/$value

Re: Task 8 - Responding to an OData query with navigation (July Developer Challenge - "Reverse

qmacro — Wed, 24 Jul 2024 09:11:21 GMT

Excellent! Thanks for providing your thoughts.

It's worth mentioning here that it's possible to use key-as-segment addressing CAP, not because CAP supports OData V4 out of the box, just that CAP supports this optional alternate convention. The Northwind service at https://services.odata.org/V4/Northwind/Northwind.svc/ doesn't support that, but it's still an OData V4 service.

Also, I can't resist pointing out that it's "OData", not "oData" 🙂

Re: Task 8 - Responding to an OData query with navigation (July Developer Challenge - "Reverse

Liyon_SV — Wed, 24 Jul 2024 09:38:13 GMT

Re: Task 8 - Responding to an OData query with navigation (July Developer Challenge - "Reverse

mxmw — Wed, 24 Jul 2024 11:25:31 GMT

This easy one is a nice time to catch a breathe after the amount of troubleshooting on the previous:

In regards to the questions I have played a little bit around with the endpoints and came to the same conclusion as cguttikonda24.

Especially properly amazed by the ease of SAP CAP for creating services with all features that you can wish for.

Re: Task 8 - Responding to an OData query with navigation (July Developer Challenge - "Reverse

qmacro — Wed, 24 Jul 2024 12:49:14 GMT

Good to hear!

Re: Task 8 - Responding to an OData query with navigation (July Developer Challenge - "Reverse

YogSSohanee — Wed, 24 Jul 2024 20:28:35 GMT

Hello @qmacro ,

I am getting an error as below when i am trying to call URL -

GET {{baseURL}}/odata/v4/northbreeze/Products/11

Does this mean that the service is not implemented properly, kindly suggest!

Re: Task 8 - Responding to an OData query with navigation (July Developer Challenge - "Reverse

MioYasutake — Wed, 24 Jul 2024 20:50:49 GMT

My submission for task 8.

Re: Task 8 - Responding to an OData query with navigation (July Developer Challenge - "Reverse

MioYasutake — Wed, 24 Jul 2024 22:52:53 GMT

Hi @YogSSohanee ,

I faced the same issue in the previous task. In my case, at the end of my event handler code, I wrote `return super.init`, but it had to be corrected to `return super.init()`.

Re: Task 8 - Responding to an OData query with navigation (July Developer Challenge - "Reverse

Alpesa1990 — Wed, 24 Jul 2024 21:12:48 GMT

My submission for task 8.

Re: Task 8 - Responding to an OData query with navigation (July Developer Challenge - "Reverse

sudarshan_b — Thu, 25 Jul 2024 09:41:13 GMT

Here's my submission for task 8 -

The Key-as-segment convention is new learning for me, however I somehow see it similar to the cds.ql option of WHERE clause, like in example SELECT.from (Books,201), I may be completely wrong though 🙂

Re: Task 8 - Responding to an OData query with navigation (July Developer Challenge - "Reverse

geek61 — Thu, 25 Jul 2024 09:53:58 GMT

No issues deploying this one...

While we're talking about resource paths, what about going one level deeper - is that supported?

What if you wanted just the scalar value Beverages? Is that possible? If so, how?

Following the instructions from Task 7:

First, the Northwind service only allows the "traditional" OData key specification in the the resource path, e.g. /Suppliers(7) and not the more recent Key-as-Segment style. Does your Northbreeze service, powered by CAP, support that? What does that look like?

Re: Task 8 - Responding to an OData query with navigation (July Developer Challenge - "Reverse

qmacro — Thu, 25 Jul 2024 11:33:43 GMT

Nice one @MioYasutake - yes, this is likely the cause.

Re: Task 8 - Responding to an OData query with navigation (July Developer Challenge - "Reverse

qmacro — Thu, 25 Jul 2024 11:34:10 GMT

Thanks for the thoughts, @sudarshan_b !

Re: Task 8 - Responding to an OData query with navigation (July Developer Challenge - "Reverse

qmacro — Thu, 25 Jul 2024 11:34:50 GMT

Great answer / comment, thanks!

Re: Task 8 - Responding to an OData query with navigation (July Developer Challenge - "Reverse

YogSSohanee — Thu, 25 Jul 2024 14:43:53 GMT

Hi @MioYasutake , bang on! That was the problem, a mere typo. 🙂 Thanks for your help!

@qmacro : Please find below my submission for Task 8.

Tried few OData calls and its in line with the regular OData calls.

Re: Task 8 - Responding to an OData query with navigation (July Developer Challenge - "Reverse

MatLakaemper — Thu, 25 Jul 2024 16:24:29 GMT

my Submission,

Scalar-Value:

Re: Task 8 - Responding to an OData query with navigation (July Developer Challenge - "Reverse

vineelaallamnen — Thu, 25 Jul 2024 20:38:25 GMT

Re: Task 8 - Responding to an OData query with navigation (July Developer Challenge - "Reverse

gphadnis2000 — Fri, 26 Jul 2024 00:19:12 GMT

My submission for Task 8