You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@olingo.apache.org by Peter Lawrence <pe...@inova8.com> on 2017/09/07 16:27:36 UTC
Odata v4 $metadata issue with Excel
Sorry but this is a poorly defined problem, but any help will be useful.
I am now using Olingo v4.4.0 to create a Odata service (for any SPARQL
accessible triple store at the backend).
The service is up and running, accessible by my test code, accessible via
tools such as Linqpad. However Excel w/PowerQuery simply reports the
following error
[image: image.png]
True to form, Excel offers no further help with regard to the problems that
it is finding in the metadata. Ive attached a copy $metadata.
Some notes:
1. I had the same Excel issue with the metadata from Olingo 4.3.
2. I have used the Olingo V2 library successful for a long time without
any issues with Excel (or any other consumer of the service)
3. I understand that Linqpad uses MS libraries but it does not have any
issues with the metadata or service.
i would be happy to provide any more information that is required. Sorry
for the impreciseness of the definition of the issue.
Thanks
Peter
--
*Peter J. Lawrence*
*inova8*
*Providing answers for users' information questions*
*Mobile:* +1 330 631 3772 | *Phone:* +1 330 342 0582 |*Skype:*
PeterJLawrence
*Mobile UK:*: +44 754 6095977 | *Phone UK:* +44 1298 872375
*Email:* peter.lawrence@inova8.com | *Web:* www.inova8.com
*LinkedIn: **http://www.linkedin.com/in/peterjohnlawrence
<http://www.linkedin.com/in/peterjohnlawrence>*
Re: Odata v4 $metadata issue with Excel
Posted by Christian Amend <ch...@apache.org>.
Hi Peter,
this issue has appeared before. The problem is that Olingo uses
relative URLs in the context as recommended by the OData TC. Excel
expects absolute URLs.
Here is the issue which includes a solution by adding absolute URLs in
your payloads: https://issues.apache.org/jira/browse/OLINGO-787
Best Regards,
Christian
On Thu, Sep 7, 2017 at 7:50 PM, Peter Lawrence
<pe...@inova8.com> wrote:
> That was the case. Excel will now access services declared to be V4 such as
> http://services.odata.org/V4/Northwind/Northwind.svc/ and
> http://services.odata.org/TripPinRESTierService/
>
> On Thu, Sep 7, 2017 at 1:19 PM Hans Kruse <kr...@hanskruse.eu> wrote:
>>
>> As far as I Know Excel only supports ODATA V3.
>>
>>
>> On do 7 sep. 2017 18:27 Peter Lawrence <pe...@inova8.com> wrote:
>>>
>>> Sorry but this is a poorly defined problem, but any help will be useful.
>>>
>>> I am now using Olingo v4.4.0 to create a Odata service (for any SPARQL
>>> accessible triple store at the backend).
>>>
>>> The service is up and running, accessible by my test code, accessible via
>>> tools such as Linqpad. However Excel w/PowerQuery simply reports the
>>> following error
>>>
>>>
>>>
>>> True to form, Excel offers no further help with regard to the problems
>>> that it is finding in the metadata. Ive attached a copy $metadata.
>>>
>>> Some notes:
>>>
>>> I had the same Excel issue with the metadata from Olingo 4.3.
>>> I have used the Olingo V2 library successful for a long time without any
>>> issues with Excel (or any other consumer of the service)
>>> I understand that Linqpad uses MS libraries but it does not have any
>>> issues with the metadata or service.
>>>
>>> i would be happy to provide any more information that is required. Sorry
>>> for the impreciseness of the definition of the issue.
>>>
>>> Thanks
>>>
>>> Peter
>>>
>>> --
>>> Peter J. Lawrence
>>>
>>> inova8
>>> Providing answers for users' information questions
>>> Mobile: +1 330 631 3772 | Phone: +1 330 342 0582 |Skype: PeterJLawrence
>>> Mobile UK:: +44 754 6095977 | Phone UK: +44 1298 872375
>>> Email: peter.lawrence@inova8.com | Web: www.inova8.com
>>> LinkedIn: http://www.linkedin.com/in/peterjohnlawrence
>>
>> --
>>
>> Hans Kruse
>>
>> : +31683968991
>>
>> ✉ kruse@hanskruse.eu
>>
>> Disclaimer
>>
>> E-mail correspondence is secret only if encrypted.
>> Digital signatures are only recognized as a signature when using public
>> key cryptography.
>> E-mail messages without digital signature are not legally binding and
>> included disclaimers are not relevant.
>
> --
> Peter J. Lawrence
>
> inova8
> Providing answers for users' information questions
> Mobile: +1 330 631 3772 | Phone: +1 330 342 0582 |Skype: PeterJLawrence
> Mobile UK:: +44 754 6095977 | Phone UK: +44 1298 872375
> Email: peter.lawrence@inova8.com | Web: www.inova8.com
> LinkedIn: http://www.linkedin.com/in/peterjohnlawrence
Re: Odata v4 $metadata issue with Excel
Posted by Peter Lawrence <pe...@inova8.com>.
That was the case. Excel will now access services declared to be V4 such as
http://services.odata.org/V4/Northwind/Northwind.svc/ and
http://services.odata.org/TripPinRESTierService/
On Thu, Sep 7, 2017 at 1:19 PM Hans Kruse <kr...@hanskruse.eu> wrote:
> As far as I Know Excel only supports ODATA V3.
>
> On do 7 sep. 2017 18:27 Peter Lawrence <pe...@inova8.com> wrote:
>
>> Sorry but this is a poorly defined problem, but any help will be useful.
>>
>> I am now using Olingo v4.4.0 to create a Odata service (for any SPARQL
>> accessible triple store at the backend).
>>
>> The service is up and running, accessible by my test code, accessible via
>> tools such as Linqpad. However Excel w/PowerQuery simply reports the
>> following error
>>
>> [image: image.png]
>>
>> True to form, Excel offers no further help with regard to the problems
>> that it is finding in the metadata. Ive attached a copy $metadata.
>>
>> Some notes:
>>
>> 1. I had the same Excel issue with the metadata from Olingo 4.3.
>> 2. I have used the Olingo V2 library successful for a long time
>> without any issues with Excel (or any other consumer of the service)
>> 3. I understand that Linqpad uses MS libraries but it does not have
>> any issues with the metadata or service.
>>
>> i would be happy to provide any more information that is required. Sorry
>> for the impreciseness of the definition of the issue.
>>
>> Thanks
>>
>> Peter
>>
>> --
>> *Peter J. Lawrence*
>>
>> *inova8*
>> *Providing answers for users' information questions*
>> *Mobile:* +1 330 631 3772 <(330)%20631-3772> | *Phone:* +1 330 342 0582
>> <(330)%20342-0582> |*Skype:* PeterJLawrence
>> *Mobile UK:*: +44 754 6095977 <+44%207546%20095977> | *Phone UK:* +44
>> 1298 872375 <+44%201298%20872375>
>> *Email:* peter.lawrence@inova8.com | *Web:* www.inova8.com
>> *LinkedIn: **http://www.linkedin.com/in/peterjohnlawrence
>> <http://www.linkedin.com/in/peterjohnlawrence>*
>>
> --
>
> Hans Kruse
>
> ☎: +31683968991 <+31%206%2083968991>
>
> ✉ kruse@hanskruse.eu
>
> Disclaimer
>
> E-mail correspondence is secret only if encrypted.
> Digital signatures are only recognized as a signature when using public
> key cryptography.
> E-mail messages without digital signature are not legally binding and
> included disclaimers are not relevant.
>
--
*Peter J. Lawrence*
*inova8*
*Providing answers for users' information questions*
*Mobile:* +1 330 631 3772 | *Phone:* +1 330 342 0582 |*Skype:*
PeterJLawrence
*Mobile UK:*: +44 754 6095977 | *Phone UK:* +44 1298 872375
*Email:* peter.lawrence@inova8.com | *Web:* www.inova8.com
*LinkedIn: **http://www.linkedin.com/in/peterjohnlawrence
<http://www.linkedin.com/in/peterjohnlawrence>*
Re: Odata v4 $metadata issue with Excel
Posted by Hans Kruse <kr...@hanskruse.eu>.
As far as I Know Excel only supports ODATA V3.
On do 7 sep. 2017 18:27 Peter Lawrence <pe...@inova8.com> wrote:
> Sorry but this is a poorly defined problem, but any help will be useful.
>
> I am now using Olingo v4.4.0 to create a Odata service (for any SPARQL
> accessible triple store at the backend).
>
> The service is up and running, accessible by my test code, accessible via
> tools such as Linqpad. However Excel w/PowerQuery simply reports the
> following error
>
> [image: image.png]
>
> True to form, Excel offers no further help with regard to the problems
> that it is finding in the metadata. Ive attached a copy $metadata.
>
> Some notes:
>
> 1. I had the same Excel issue with the metadata from Olingo 4.3.
> 2. I have used the Olingo V2 library successful for a long time
> without any issues with Excel (or any other consumer of the service)
> 3. I understand that Linqpad uses MS libraries but it does not have
> any issues with the metadata or service.
>
> i would be happy to provide any more information that is required. Sorry
> for the impreciseness of the definition of the issue.
>
> Thanks
>
> Peter
>
> --
> *Peter J. Lawrence*
>
> *inova8*
> *Providing answers for users' information questions*
> *Mobile:* +1 330 631 3772 | *Phone:* +1 330 342 0582 |*Skype:*
> PeterJLawrence
> *Mobile UK:*: +44 754 6095977 | *Phone UK:* +44 1298 872375
> *Email:* peter.lawrence@inova8.com | *Web:* www.inova8.com
> *LinkedIn: **http://www.linkedin.com/in/peterjohnlawrence
> <http://www.linkedin.com/in/peterjohnlawrence>*
>
--
Hans Kruse
☎: +31683968991
✉ kruse@hanskruse.eu
Disclaimer
E-mail correspondence is secret only if encrypted.
Digital signatures are only recognized as a signature when using public key
cryptography.
E-mail messages without digital signature are not legally binding and
included disclaimers are not relevant.