search

SAP / olingo-jpa-processor-v4

The JPA Processor fills the gap between Olingo V4 and the database, by providing a mapping between JPA metadata and OData metadata, generating queries and supporting the entity manipulations.
Apache License 2.0
127 stars 79 forks source link

Not able to use Odata feeds in Excel and Power BI #103

Closed kumarvika closed 3 years ago

kumarvika commented 4 years ago

Hi,

Everything thing is working fine except that, I am not able to use feeds in Excel and Power BI. As they have default connector to get feeds from ODATA. Getting "Invalid URI: The hostname could not be parsed." as an error.

I am using a 0.3.7 version.

error-excel

wog48 commented 4 years ago

Hello,

the problem here is that excel expects absolut links, but olingo produces by default relative links, see https://issues.apache.org/jira/browse/OLINGO-787.

Up to know it is not possible to switch to absolut path. I prepared an enhancement that you can find in branch release-0.3.8. You will find a new method in the service context builder: setUseAbsoluteContextURL. Provide true to switch to absolute path.

Let me know if this works for you

kumarvika commented 4 years ago

Thanks, @wog48 I did some workaround.

I created one CustomeProcessor and register that processor into JPAODataGetHandler.

It is giving me the desired response.

Thank you for your response.

kumarvika commented 3 years ago

Hi @wog48,

It is working now. Thank you very much.