cancel
Showing results for 
Search instead for 
Did you mean: 

donwload a xlsx file from a url using sap pi

SushantShinde
Advisor
Advisor
0 Kudos

Hello experts,

I need to download a .xlxs file from a public url, how can I approach this using SAP PO. I don't have any constraints in using any adapter on the sender side, require some inputs, please help.

Regards,

Sushant

Accepted Solutions (0)

Answers (3)

Answers (3)

ray_hu
Employee
Employee
0 Kudos

Hi Sushant,

You can also refer to blog below:

https://blogs.sap.com/2019/03/19/how-to-download-a-file-from-amazon-s3-buckets/

Best Regards,

Ray

ray_hu
Employee
Employee
0 Kudos

Hi Sushant,

Given that HTTP Adapter don’t work with format other than XML, you will need to convert the file to binary, then insert the content in a tag of XML. For this conversion I recommend a module adapter FormatConversionBean

Best Regards,

Ray

ray_hu
Employee
Employee
0 Kudos

Hi Sushant,

You may use async-sync bridge in this scenario, i.e., HTTP sender(async) -> HTTP receiver with get action (sync) -> File receiver writhe the file to file system (async).

Best Regards,

Ray

SushantShinde
Advisor
Advisor
0 Kudos

Hello Ray,

Thanks for the reply, can you please elaborate how to proceed with the download using HTTP get action. or point me to some blogs which helps me in understanding it better.

Reagrds,

Sushant