split data into single data

[former_member76287]

Dear Expert,

i need advice

currently i have this data

<jsonAsXml>
<0>
<effectiveStartDate>2020-02-04T00:00:00.000</effectiveStartDate>
<externalCode>00115373</externalCode>
<transactionSequence>4</transactionSequence>
<cust_status>success</cust_status>
<cust_notes>
<id_voucher>GRAB50-20200210-000244</id_voucher>
<kode_voucher>R1JBQjc4OTc0NjQ=</kode_voucher>
<tgl_expired>2021-01-01</tgl_expired>
<url>https://dev.uvcr.me/e6cc5218d1f852a7bb1c5bdde725be59/1581406035</url>
</cust_notes>
<cust_Balance>null</cust_Balance>
<cust_Amount>null</cust_Amount>
<id_voucher>GRAB50-20200210-000244</id_voucher>
<kode_voucher>R1JBQjc4OTc0NjQ=</kode_voucher>
<tgl_expired>2021-01-01</tgl_expired>
<url>https://dev.uvcr.me/e6cc5218d1f852a7bb1c5bdde725be59/1581406035</url>
<backgroundElementId>0</backgroundElementId>
</0>
<1>
<effectiveStartDate>2020-02-04T00:00:00.000</effectiveStartDate>
<externalCode>00115373</externalCode>
<transactionSequence>4</transactionSequence>
<cust_status>success</cust_status>
<cust_notes>
<id_voucher>GRAB50-20200210-000703</id_voucher>
<kode_voucher>R1JBQjc4OTc5MjM=</kode_voucher>
<tgl_expired>2021-01-01</tgl_expired>
<url>https://dev.uvcr.me/6fc2d4fef33a5925a45c9874a70f3509/1581406035</url>
</cust_notes>
<cust_Balance>null</cust_Balance>
<cust_Amount>null</cust_Amount>
<id_voucher>GRAB50-20200210-000703</id_voucher>
<kode_voucher>R1JBQjc4OTc5MjM=</kode_voucher>
<tgl_expired>2021-01-01</tgl_expired>
<url>https://dev.uvcr.me/6fc2d4fef33a5925a45c9874a70f3509/1581406035</url>
<backgroundElementId>0</backgroundElementId>
</1>
</jsonAsXml>

i would like to upsert this data into SuccessFactors , but stuck because this data is multiple data.

i'm currently using this splitter

but i find this error

Error Details



org.apache.camel.CamelExchangeException: Sequential processing failed for number 0. Exchange[ID-vsa7092616-37268-1581180070606-818-6]. Caused by: [org.apache.camel.CamelExchangeException - Parallel processing failed for number 0. Exchange[ID-vsa7092616-37268-1581180070606-818-20]. Caused by: [java.lang.IllegalStateException - com.ctc.wstx.exc.WstxUnexpectedCharException: Unexpected character '0' (code 48) in content after '<' (malformed start element?).
at [row,col {unknown-source}]: [2,4]]], cause: com.ctc.wstx.exc.WstxUnexpectedCharException: Unexpected character '0' (code 48) in content after '<' (malformed start element?).
at [row,col {unknown-source}]: [2,4]

is there any way i'm doing split on single data ?

thank you

[former_member76287]

Hi lakshmiprasanna

how can i convert from <0> into text tags ?

because the problem is <0> is strange records

please advise