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