02-12-2019 7:04 AM - edited 02-04-2024 12:14 AM
Hello everyone,
A custom CDS has been generated by another user and it contains parameters.
When the URL is created, the required information for the parameters is omitted from the URL.
Thus, when trying to use the generated URL within Excel, using the Get Data functionality (Get Data>From Other Sources>From ODATA fee) I get an error reported by Excel stating that the request failed... with part of the error message indicating that the YY1_... source "was not found".
Searching around, I have found a SAP Knowledgebase article # 2600276 that attempts to explain possible solutions to my problem.
Trouble is, being very new to this SAP development stuff, I don't know how to really interpret the information given in the SAP Note.
The information in the note states the following:
Calling an OData EntitySets with parameter like that, <URL>\YY1_<ODATA-SERVICE>\EntitySets is not correct. Refer to the resolution section
To call the correct Entitysets with parameter, do the following:
No idea what they are referring to with regards to the "EntitySets" in the first part and the $metadata tag referred to in point 1 in the Resolution section.
Can anyone please offer some advice/guidance to a beginner in this area?
I have been given an ODATA feed url that I have used in another project, but that one did not contain a Parameterised CDS query.
Thanks in advance,
Brian.
Hi Brian,
I hope you’re all well!
As I understand from the problem statement, a custom CDS views has been created that has to be exposed into a excel and you’re running into an error, right?
If this is the case, I would assume, you have satisfied the following pre-requisites:
1. A custom CDS view with API (OData) enabled is checked marked. This helps you to expose your custom CDS view outside of S4HC. Publish the Custom CDS View.
2. A custom Communication scenario is created, and it must be published as well.
3. The Custom Communication scenario created should be linked to a Communication arrangement and must be saved and activated as well.( A communication user and Communication system should be satisfied as well)
4. Now, you will have the OData link available.
Now, before you expose your custom CDS view into an excel, I would recommend you call this OData service in a browser to confirm if the data is populating. For this you can do the following:
1. Open the browser incognito mode, call the URL in the following format(sample for your reference):
enter the credentials you created under communication user(while creating communication arrangement?)
2. Now, to fetch the metadata, use the following sample as reference by appending $metadata
please note that Metadata can only be fetched in second call.
Now, if this works successfully (if you’re able to fetch the desired result) you’re OData to good to go and we can be exposed successfully!
Now, you may try to expose this into an Excel. Here is a YouTube link from one of our colleague who has demonstrated your use case neatly with some check points that should help you to take forward.
https://www.youtube.com/watch?v=figt8pCOO0M&index=5&list=LLf65ovoh3T2MrCGu99IqQdw&t=40s
Please let me know how this goes and if we need further troubleshooting, then it must be logged as an incident so that we could further evaluate this in your S4HC tenant.
Hope this helps!
Thank you! Amith Nair
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.