Proxy to SFTP csv scenario

[former_member50933]

Hi people,

I have a proxy-> sftp scenario. The final product must be a .csv file with the following layout:

"Name","Supplier Number","Display Name","PO Method","Payment Method","Invoice Matching Level","PO Email","Status"

"1-Fornecedor 1","1","Fornecedor 1","email","invoice","2-way","fornecedor+1@coupa.com","inactive"

"2-Fornecedor 2","2","Fornecedor 2","email","invoice","2-way","fornecedor+2@coupa.com","inactive"

The first line contains the name of the fields and the following line contains the values of these fields. Fields must be quoted and separator is comma

I have the flexibility to determine the source xml layout. How do I convert xml to this csv? By Content Conversion? What parameters should I set?

Thank you

[AlexanderApel]

Hi Wilson,

as you say, use content Conversion and try something like this.

fieldSeparator --> ,

endSeparator --> 'nl'

to put the fields in quotes I would try a mapping.

Regards,

Alex