Skip to Content

Not able to read data from Northwind Odata model

Hi Experts,

I am not able to connect the Northwind service from WebIDE. Tried many ways and went through different blogs, but there is no luck.

I am able to configure the destination properly. But Not able to read the data. Please see the screen shots.

I wrote the below line of code.

But value not coming in output.

Please help me to solve this problem.

Thanks,

Chandan

code.png (136.4 kB)
output.png (173.4 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    Posted on Oct 18, 2018 at 10:11 PM

    Batch call is not supported for northwind. Swtich off Batch for your model in manifest.json and it will start working.

    "settings" : { "useBatch" : false },

    Regards,

    Sarbjeet Singh


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 18, 2018 at 07:38 AM

    You are calling invalid URI

    "Invoice" entity has 9 key values

    The valid URI will be

    /Northwind/Northwind.svc/Invoices(CustomerName='Alfreds%20Futterkiste',Discount=0f,OrderID=10692,ProductID=63,ProductName='Vegie-spread',Quantity=20,Salesperson='Margaret%20Peacock',ShipperName='United%20Package',UnitPrice=43.9000M)/ShippedDate


    2.png (7.2 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 17, 2018 at 11:43 AM

    Hi Chandan,

    Can you attach a screenshot of the Destination Configuration?

    You may check the following blog to ensure that everything is on place:

    https://blogs.sap.com/2014/07/07/how-to-use-northwind-odata-service-with-sap-river-rde/

    Though the Service URL should be /V2/northwind/northwind.svc as you have set.

    Best regards,

    Konstantia

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 17, 2018 at 01:27 PM

    Thanks Simone and Konstantia for your reply.

    Please find some additional screen shots as requested.


    destination.png (130.9 kB)
    manifest1.png (67.1 kB)
    manifest2.png (47.1 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.