Forum Discussion

arvindnsn's avatar
arvindnsn
Contributor
4 years ago

Read SOAP Execute Response content which is in CSV and write into a DB table

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 th...
JensDeveloper's avatar
JensDeveloper
Contributor II
4 years ago

Hi @arvindnsn ,

Have you configurated the CSV formatter with contains headers? Could you show your configuration of the csv fromatter?
Also is it possible to paste the output in a way that I can copy it and try some transformations with it.
Because right now I don’t have/know the exact expression to get your required result.

Regards

Jens

arvindnsn's avatar
arvindnsn
Contributor
4 years ago

Hi @JensDeveloper,

I figured the solution. After converting the Binary to Document, I have to Parse it by using the CSV Parser. In stead, I was using the CSV Formatter before CSV Parser that messed up the whole converted output coming from the BinaryToDocument Snap.

Below is the pipeline flow that worked good.

Thank you
Aravind N

  • JensDeveloper's avatar
    JensDeveloper
    Contributor II
    4 years ago

    Hi @arvindnsn ,

    Aah yeah I see it now also. Good to know.