Skip to Content

Is it mandatory to import xml or xsd for csv to xml convertor

I am using scenario sftp to odata. In sftp i have to pick csv file but in mapping it shows error because mapping didn't understand csv, so i use csv to xml convertor. So is it mandatory to add xml/xsd in convertor path. Is there any alternative to accept csv file or i have to make xml/xsd file everytime for csv file.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 18, 2017 at 07:21 AM

    Hello Siddharth,

    Message Mapping accepts input data only in XML format.If you want to do transformation using message mapping it is mandatory to convert the CSV to XML.

    You can leverage CSV to XML Converter to achieve the same and its mandatory to pass schema [ XSD ]of output message you want in converter.

    Regards,

    Sriprasad Shivaram Bhat

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Sidharth,

      1. In your modeling you need to include the conversion step if your runtime input message format is CSV, so that the conversion happens for every message.

      2. You have to provide the XML schema.

      Regards,

      Gayathri

  • Jul 19, 2017 at 05:19 AM

    Thanks!!..
    if we are using sftp to odata scenario, picking csv from sftp, mapping not required and in odata we want payload in json, so we have to add csv to xml convertor and xml to json convertor before odata adaptor or just sftp adaptor and odata adaptor and in odata payload format select json without using convertors.

    Add comment
    10|10000 characters needed characters exceeded