I am trying to read the SOAP CSV response in Binary form and write each record into a table. The SOAP response in encoded in Binary for as “content” in one big “string” data type
I want to write them into a table by breaking that string into multiple lines which has header information also.
Below is the flow of the pipeline
Below is the response output of the SOAP Execute. the “content” entity has the output in binary form.
The CSV formatter is getting the output as below.
From here, I am not able to break them into individual records to insert them into a Database table. Also, I am not able to read the Header from the output so that i can substitute each value to a variable in a mapper and subsequently insert them into a DB table.
Note, the first line of the output is the Header for the data.
Please advise to resolve this