Problem trying to import ODAta in Excel 2016

Data Abstract
1

Hi,

I have created a very simple server with the DA Wizard to make a viaailable throught OData.

http://localhost:8099/odata/

In Excel 2016 when I try to load the data from the adress I have a message saying : The Feed’s metadata document appears …

2018-06-15_14-33-20

Any idea ?

Best regards

2

we generate ODATA v1, but seems Excel 2016 requires modern version of ODATA like v4

3

Any plan to improve it ?
Could it be an authentication problem also ? since the DA wizard generate a sample with authentication ?

4

we have an issue for improving ODATA but it has low priority

afaik, you can generate application w/o authentication.
alos you can disable it. for it, change DataService.RequireSessions to False

5

Hi Evgeny,
my Excel 206 works fine with old version of OData but not with RemObjects One.
Not that I have rebuilt the project with no authentication this time.

There is a Strange thing is that at http://localhost:8099/odata/
I get only:

<service xmlns:atom="http://www.w3.org/2005/Atom" xmlns:app="http://www.w3.org/2007/app" xmlns="http://www.w3.org/2007/app" xml:base="http://localhost:8099/odata/">
<workspace>
<atom:title>ODataService</atom:title>
<collection href="CLIENT">
<atom:title>CLIENT</atom:title>
</collection>
</workspace>
</service>

no data on the XML data.
So I wondering if I’m not doing Something wrong or if there is not a problem somewhere else.

Best regards

6

looks like you have only one table on server - CLIENT
for data, you need to call http://localhost:8099/odata/CLIENT
if you call http://localhost:8099/odata/$metadata - you will receive tables structures

1 Like
7

http://localhost:8099/odata/CLIENT shows me the data in my web browser but Excel fails loading it, same message of my first post.

8

as I said, we generate ODATA v1, but seems that Excel expects later version of ODATA …

for example, Excel can require MaxDataServiceVersion: 2.0 header that is unknown for ODATA v1…