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
Â
<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&skipHeaderRecord=true"/>
<to uri="pfx-api:loaddata?mapper=carsMapper&objectType=PX"/>
</split>
</route>
IntegrationManager version 5.8.0