SAP Fiori CRUD Master-Detail Application template issues on SAP Web IDE

[Former Member]

Hello Experts,

I am facing certain issues with the new Fiori Master-Detail CRUD app template, on SAP Web IDE.

I tired using the CRUD app template for both SAPES1 OData service URL - " https://sapes1.sapdevcenter.com/sap/opu/odata/sap/ZGWSAMPLE_SRV/ "

as well as Northwind OData service URL - " http://services.odata.org/V2/(S(1kmuijkrksjfeu3nw4014hna))/OData/OData.svc/Products " .

Kindly note:-

Both SAPES1 and Northwind destinations have been properly added in my SAP HANA Cloud Trial account.

When I run the "test.html" file and choose "test/flpSandbox.html"  I am encountering error messages.

For the SAPES1 service, I am encountering "CSRF token validation failed" message and the UI is completely blank.

I also created another CRUD app with Northwind OData service, the one with Read/Write capabilities and by specifying "v2" in the OData service URL for version 2,.

In this app, I initially get a error prompt which reads "Query options $orderby, $inlinecount, $skip and $top cannot be applied to the requested resource". 

However, upon closing the error prompt, my app UI shows data from backend. When I click on the " + " , the Create New Entity screen is displayed, in which I am able to enter details and save it on to the backend.

Upon saving, I again encounter the same error prompt "Query options $orderby, $inlinecount, $skip and $top cannot be applied to the requested resource".

And the Entity I have created is visible , but only until I refresh the page.

Once I refresh or when I open the app after few hours, the new entity is no more available in the Master list.

Could you kindly tell me what needs to be done to get the Fiori Master-Detail CRUD app working, in order to update the records on back-end.

Thank you,

Suraj Kumar Y. Midgay

[offer_shostak · Accepted solution]

For the CSRF issue there is a solution here:

http://scn.sap.com/message/16527913#16527913

Could you please try and see if it helps you?

[Former Member · Accepted solution]

Hi Offer,

Thanks for sharing the link for CSRF issue.

I have tried the code snippet from the link and it has resolved my CSRF issue.

For the Northwind issue, I will check by using the URL you have mentioned.

Thanks for the inputs, will let you know.

Thanks,

Suraj Kumar.

[Former Member]

Hi Suraj,

I have a similar requirement and I am not able to create an entry and save it. It shows "Sorry, a technical error occurred! Please try again later".

And I am facing the same problem you faced while editing new entries.

Hope you help me resolve it. Experts in the forum also please provide your suggestions for the same.

Thanks,

Srinivasan

[offer_shostak]

Hi,

Are you using the original Northwind service I provided?

Regards,

Offer.

[Former Member]

Hi Offer,

No I am using a standard Odata service from c4c. My scenario is to integrate Service Tickets from c4c to hcp.

Regards,

Srinivasan

[Former Member]

Hi Offer,

Any suggestions from your side would be helpful.

Thanks,

Srinivasan

[offer_shostak]

Hi,

Please let's separate the issues:

1. CSRF token issue seems like a configuration issue because we are using the UI5 Odata model which handles CSRF seamlessly.

Could you please share your destination configuration?

2. Northwind issue - I took the specified service: http://services.odata.org/V2/(S(1kmuijkrksjfeu3nw4014hna))/OData/OData.svc/Products " . 

and it is different from the original Northwind.

Could you please describe how did you create this one and what is its backend system?

Regards,

Offer.

[Former Member]

Hello Offer,

I am currently using the Version 2 of the Northwind OData service. The URL for which is as following.

" http://services.odata.org/V2/(S(hquzgekfnzc5gxu11e1gyzef))/OData/OData.svc/ "

However, I am facing the same OData service error prompt as stated below.

" Query options $orderby, $inlinecount, $skip and $top cannot be applied to the requested resource ".

Below screenshots are of the Northwin DEstination in HCP and frm CRUD app template.

1) Northwind OData Service Destination in HCP

2) Specifying the Northwind URL in CRUD app template

3) Selecting Entity in Template Custumization

4) OData error prompt while executing / testing the app

I get the above error prompt when the app initially loads, as well as whenever I add a new entity on the  Create New Entity " + " button and click the " Save " button.

Could you kindly let me know, what am I missing to get the app running without any error prompts?

Looking forward for your valuable suggestions and insights.

Thanks,

Suraj Kumar