CSV file to AWS s3 bucket via REST channel - HTTP 400 Error

[poornimal_nathan]

Hi,

We're trying to push a file into AWS s3 bucket using REST API. The message is successful if the payload has only one line. But when we try to push an actual file, we get a HTTP 400 Error. We narrowed down the issue to the occurrence of the new line character. I followed Rajesh's blog to cover the basics - https://blogs.sap.com/2019/05/31/integrating-amazon-simple-storage-service-amazon-s3-and-sap-ecc-v6....

In my case, the source file is a csv, which is then concatenated into a single string to be sent into the payload. These are my configurations.

My payload gets transformed from

<root>

<record>

<text>This,is,line,number,1</text>

</record>

<record>

<text>This,is,line,number,2</text>

</record>

<record>

<text>This,is,line,number,3</text>

</record>

</root>

to

<root>

<record>

<text>This,is,line,number,1

This,is,line,number,2

This,is,line,number,3 </text>

</record>

</root>

This works if I have one single record only. Any pointers would be greatly appreciated.