Parse CSV and Load Data to General Data Source

This example shows how to parse a CSV file and send it to a Product Extension with the name Cars.

sku,label,price
1,BMW,10
2,AUDI,20
3,Skoda,10
4,Opel,20
5,Mercedes,10
6,Seat,20
7,Porsche,10
8,Peugeot,20

XML

<pfx:loadMapper id="carsMapper" convertEmptyStringToNull="true">
    <pfx:simple expression="Cars" out="name"/>
    <pfx:body in="sku"/>
    <pfx:body in="label" out="attribute1"/>
    <pfx:body in="price" out="attribute2"/>
</pfx:loadMapper>

.....

<route>
    <from uri="file:src/data-4?noop=true"/>
    <split>
        <tokenize token="\n" group="5000"/>
        <to uri="pfx-csv:unmarshal?header=sku,label,price&amp;skipHeaderRecord=true"/>
        <to uri="pfx-api:loaddata?mapper=carsMapper&amp;objectType=PX"/>
    </split>
</route>