cancel
Showing results for 
Search instead for 
Did you mean: 

Error during CSV to XML conversion in CPI interface

0 Kudos

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>


0 Kudos

XSD screenshot

Accepted Solutions (1)

Accepted Solutions (1)

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

Answers (1)

Answers (1)

0 Kudos

Thanks Praveen it worked.