SAP CPI: Content based router not working

[former_member450632]

Hi All,

I am currently working on an iFlow where I am getting CSV file from an SFTP and using the CSV to XML converter, I am getting an XML then further I am using splitter (Grouping 1) to split the records and to have further record level validations. Below is the record I get after splitter step.

<?xml version="1.0" encoding="UTF-8"?>

<CSV_EmployeeLeaves>

<EmployeeLeave>

<ID>XSGA123</ID>

<EMPLOYEENUMBER>XXXXXX</EMPLOYEENUMBER> <ORGANISATIONNODE>TEST123</ORGANISATIONNODE>

<LEAVEDDATE>15-Mar-19 00.00.00<LEAVEDATE>

<LEAVETYPE>Sick</LEAVETYPE>

</EmployeeLeave>

</CSV_EmployeeLeaves>

Now in case LEAVETYPE is 'Sick', there is additional processing needs to be executed. In order to achieve this I used Router but it is not working and always going into default route.

Kindly let me know what can be the possible cause/solution.

[bhalchandraswcg]

Hi Abhijeet,

Node LEAVEDATE does not have closing node.

<?xml version="1.0" encoding="UTF-8"?>
<CSV_EmployeeLeaves>
    <EmployeeLeave>
        <ID>XSGA123</ID>
        <EMPLOYEENUMBER>XXXXXX</EMPLOYEENUMBER>
        <ORGANISATIONNODE>TEST123</ORGANISATIONNODE>
        <LEAVEDDATE>15-Mar-19 00.00.00<LEAVEDATE> <<<-- Here, LEAVEDATE isn't closed
        <LEAVETYPE>Sick</LEAVETYPE>
    </EmployeeLeave>
</CSV_EmployeeLeaves>

Hope this helps,

Bala

[rasjoshi]

Hey I am also facing same issue...did you find solution for this?

-Rashmi