Error during CSV to XML conversion in CPI interface

former_member105339 — Tue, 28 Jul 2020 14:52:17 GMT

Hello experts,

I have configured the CSV to XML converter as per the attached screenshot. I am getting below error while CSV to XML conversion.Also attaching sceenshot of the payload coming before CSV to XML converter step.Below is the xsd for CSV to XML converter.Request your help to resolve the issue.

Error :java.lang.IllegalStateException: Element name [] not found in provided XML schema file

XSD:

<?xml version="1.0" encoding="UTF-8"?> <xsd:schema targetNamespace="http://SFTP_Resignation_RR" xmlns="http://SFTP_Resignation_RR" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <xsd:element name="MT_Resignation" type="DT_Resignation"/> <xsd:complexType name="DT_Resignation"> <xsd:sequence> <xsd:element name="Employee_info"> <xsd:complexType> <xsd:sequence> <xsd:element name="Emplid" type="xsd:string" minOccurs="0"/> <xsd:element name="Resignation_Status" type="xsd:string" minOccurs="0"/> <xsd:element name="Resignation_Date" type="xsd:string" minOccurs="0"/> <xsd:element name="Resignation_Type" type="xsd:string" minOccurs="0"/> <xsd:element name="Last_Working_Date" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> </xsd:element> </xsd:sequence> </xsd:complexType> </xsd:schema>

Re: Error during CSV to XML conversion in CPI interface

former_member105339 — Tue, 28 Jul 2020 14:55:50 GMT

XSD screenshot

Re: Error during CSV to XML conversion in CPI interface

former_member1924 — Tue, 28 Jul 2020 15:00:37 GMT

Hi shrutib,

Seems you are using wrong Xpath.

It shouldn't start with "/", It should be like rootNode/record.

"MT_Resignation/Employee_info"

Hope this helps !

thanks and regards,

Praveen T

Re: Error during CSV to XML conversion in CPI interface

former_member105339 — Tue, 04 Aug 2020 09:04:28 GMT

Thanks Praveen it worked.

Question Re: Error during CSV to XML conversion in CPI interface in Technology Q&A

Error during CSV to XML conversion in CPI interface

Re: Error during CSV to XML conversion in CPI interface

Re: Error during CSV to XML conversion in CPI interface

Re: Error during CSV to XML conversion in CPI interface