SAP Datasphere Connector for REST API

[#1]

Hello experts, 

I want to connect a third-party REST API (Eurostat) to SAP Datasphere. This should be a simple GET REST request where data is read and should be saved into a local table in Datasphere. 

The GET request in Postman is working. 
Example URI: https://ec.europa.eu/eurostat/api/dissemination/statistics/1.0/data/nama_10_gdp?format=JSON&time=202... 

However, in SAP Datasphere I only find the generic Odata connector. This is not working in the validation, error: 406 not accepted. Probably this is due to the fact, that it is a REST-API and no Odata endpoint... 
Cause: Invalid odata connection! Getting odata metadata failed because of (406) Not Acceptable [HTTP/1.1 406 Not Acceptable]

We tested the generic HTTP connector too. This was validated and saved successfully. The problem here is that in the API task (in the task chain) only supports POST and PUT operations, no GET operation. So, this is as well no option. 

As we researched for Datasphere and REST-APIs we found this blog article. 
https://community.sap.com/t5/technology-blog-posts-by-members/streamlining-rest-api-integrations-in-... 
Is this the only option to connect REST APIs with an additionally BTP microservice? Is there no option in the SAP standard of Datasphere?

Thanks for your help!

Best regards,
Sarah

[XaviPolo]

Hi @SarahAlbrecht 

As you mentioned, the generic OData and HTTP connectors cannot be used to retrieve data from REST services. To achieve this, you need an additional service such as SAP BTP, a SAP Open Connectors integration (where you can create a REST API connection), or a similar solution.

Regards,

[ramkumar_thayumanavan]

Thanks for the question @SarahAlbrecht and clarification. We are also trying a similar requirement.

[patelyogesh]

Hello @SarahAlbrecht @ramkumar_thayumanavan @XaviPolo ,

What I found is - SAP note 3696110: Activation of REST API connectivity in SAP Datasphere

Custom connection types are not available by default - you must raise an SAP support ticket using component DS-DI-CON to request activation, providing your Tenant URL and Tenant ID (SAP Note 3696110)

This feature is only available for file spaces.  If enabling on an existing Object Store space, a redeployment of the space is required after activation.

Please ask SAP to activate this functionality on your DS tenant and you will be able to use this.

Thank you

Yogesh