on 02-12-2015 4:11 PM
Hello everyone,
I've created a "FixedQueryWithOutpu" with a simple SELECT query for test reasons. I want to get a valid OData request out of MII.
The query is stored in the project examples, in the folder "Tests", containing the same folder "Tests" and finally in the folder "Reports".
Examples/Tests/Tests/Reports/TestData
I've used this path to request the OData:
http://hostname:10000/XMII/IlluminatorOData?QueryTemplate=Examples%2FTests%2FTests%2FReports%2FTestD...
However, I get this response (what isn't too bad actually 😞
This XML file does not appear to have any style information associated with it. The document tree is shown below.
<service xmlns="http://www.w3.org/2007/app" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:app="http://www.w3.org/2007/app" xml:base="http://hostname:10000/XMII/IlluminatorOData/">
<workspace>
<atom:title>Default</atom:title>
<collection href="Rowsets">
<atom:title>Rowsets</atom:title>
</collection>
<collection href="Column">
<atom:title>Column</atom:title>
</collection>
<collection href="Row">
<atom:title>Row</atom:title>
</collection>
<collection href="Rowset">
<atom:title>Rowset</atom:title>
</collection>
<collection href="Messages">
<atom:title>Messages</atom:title>
</collection>
</workspace>
</service>
Following this post, I've use this path to gather information from my request (rowsets or something):
<protocol>:<server>:<port>/XMII/IlluminatorOData/Rowset(‘<QueryTemplateName>’)/Rowset
http://myServer:10000/XMII/IlluminatorOData/Rowsets(‘MyProject/MyFolder/MyQuery’)/Rowset
In reality:
http://hostname:10000/XMII/IlluminatorOData/Rowsets(‘Examples/Tests/Tests/Reports/TestData’)/Rowset
However, what I've got is just an error message of the server:
This XML file does not appear to have any style information associated with it. The document tree is shown below.
<error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
<code>ServerErrorException</code>
<message lang="en-US">Internal Server Error</message>
</error>
What am I doing wrong? I'm stuck with this OData topic for weeks now. I really don't get why it's that hard to get data out of this "panacea" of backend service.
A colleague is working on OData with Olingo and he doesn't really seem to be convinced that there may exist a OData request without a valid ".svc" url. Why don't we have such?
Many thanks and kind regards,
(a slightly bugged) Kai
Hi Kai
What is you MII and NW Versions?
regards
Partha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kai
There is no need for that. Ideally even NW 731 should have the same ODATA features. Can you check if the ODATA SCA is deployed on your NW server? From the error message above it seems it is there but to double check.
Also in line with Pedro's comment above I checked the help for ODATA. You can find it here. http://help.sap.com/saphelp_mii140/helpdata/en/44/2e1d2d42994aef85ef91e58db8c7c9/frameset.htm
MII ODATA Does support FixedQueryWithOutput but only with HTTP method set as POST and not GET. You may try this as well. All other modes are supported both with GET as well as POST.
Regards
Partha
Hi Pedro,
thanks for your input!
Okay, what I've done now is:
- Created a simple Query (project "Default", name "ODa")
- Tested the Query (it works =))
- Used the URL http://hostname:10000/XMII/IlluminatorOData?QueryTemplate=Default%2FODa
- Got the Result:
This XML file does not appear to have any style information associated with it. The document tree is shown below.
<error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
<code>ServerErrorException</code>
<message lang="en-US">Internal Server Error</message>
</error>
Hi Kai,
The component information looks fine.
You could try the below URL to get the query data for your QueryTemplate (Default/ODa)
http://<host>:<port>/XMII/IlluminatorOData/Rowsets('Default/ODa')/Rowset or
http://<host>: <port>/XMII/IlluminatorOData/Rowset(QueryTemplate='Default/ODa',RowsetId=1)/Row
Hope this helps!
Thanks and Best Regards,
Ria
User | Count |
---|---|
4 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.