Making an API call and unzipping a file in Datasphere

[mitko1994]

Hello experts,

We are preparing a migration to Datasphere and one of our daily flows involves making an API call and unzipping a zipped csv file before processing it in BW. My question here is how can we do that in Datasphere?

We need the following:

1. Make an API call and retrieve the zipped file as the response payload.

2. Unzip the file 

3. Process the unzipped CSV file.

If these steps are not all possible in Datasphere, what would be the suggested approach?

[TuncayKaraca]

Hi @mitko1994,

Yes, these steps are not all possible in Datasphere as of now! 

You need to use either SAP Integration Suite Cloud Integration OR  SAP Data Intelligence for that please note that SAP DI is nearing the end of its lifecycle. 

I'm wondering which app and its APIs you are using. Is it something with SAP Ariba?

Regards,
Tuncay

[mitko1994]

Thanks, Tuncay. We are retrieving data from MIRAKL on a daily basis. They send us a zipped CSV file and we have to process it.

[mitko1994]

@TuncayKaraca ,Can you suggest how we can make use of Datasphere and SAP DI or SAP IS to resolve the issue?