Read a Excel File from AWS S3 Bucket using ABAP Rest API

[former_member465187]

Hi Experts,

Is it possible to read a excel file from AWS S3 Bucket using ABAP Rest API?

Requirement is to read the data in excel file stored in AWS and then do posting in SAP. This should be achieved using ABAP REST API.

We are currently in S/4 HANA 1709 version.

[Former Member]

Hi Anand,

Please refer to following.

References

https://docs.aws.amazon.com/AmazonS3/latest/dev/RetrieveObjSingleOpREST.html

https://docs.aws.amazon.com/AmazonS3/latest/dev/s3-dg.pdf#RetrieveObjSingleOpREST

https://docs.aws.amazon.com/AmazonS3/latest/dev/HLuploadFileDotNet.html

https://docs.aws.amazon.com/AmazonS3/latest/dev/s3-dg.pdf#HLuploadFileDotNet

https://s3-eu-west-1.amazonaws.com/gxmedia.galileo-press.de/leseproben/3688/Reading_Sample_SAPPRESS_...

https://dzone.com/articles/how-to-implements-the-file-upload-process-in-a-res

https://doc.dataiku.com/dss/latest/connecting/s3.html

[OlegBash]

Yes, it is possible.

There are two ways

1) (NEED BASIS work) install s3fs into you application and mount directory like a logical path

2) your need to provide correct GET request with signature. There are examples of ABAP code here.