SAP Datasphere Connector for REST API

[SarahAlbrecht]

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,