Not able to read data from Northwind Odata model

[Chandan]

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

[SimoneMilesi]

i see you refer to "model1" to get the invoices: can you share the setting for it?

[gill367 · Accepted solution]

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

[Chandan · Accepted solution]

Excellent Sarbjeet. It started working, finally my struggle of few days ended.

I appreciate everyone's time for reading and answering questions on SAP communities.

Thanks,

Chandan

[Abdul_Waheed]

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

[Chandan]

Thanks Abdul for your reply. I didn't check the key fields properly. Now I changed the code, but still getting some error.

Error in Batch call(501 Not Implemented). Screen shots attached.

I checked with both Invoices and Categories(which have only one key field). But still some issues are there.

Thanks,

Chandan

[former_member235383]

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

[Chandan]

Thanks Simone and Konstantia for your reply.

Please find some additional screen shots as requested.

[SimoneMilesi]

I think you have a "/Northwind" at the beginning of your declarations you should remove, given konstantia.zerva-spanou example

[Chandan]

Hi Simone,

The first "/Northwind" is the name of the destination. And it is able to load the metadata perfectly using the same link.

The issue may be due to some other reason.