What do I need to add to my pipeline to take parsed CSV values and add them to my database?

I’m using WebMethods 10.4 and trying to write records of a CSV file to a database. I have followed this tutorial – https://techcommunity.softwareag.com/pwiki/-/wiki/Main/Flat+File+Processing+Tutorial – for writing records to an output file. I have also built an adapter service based on the InsertSQL template for writing a record to the appropriate database table. However, I’m not clear on what I need to add to my pipeline to take the output of parsing the CSV file and repeatedly invoke the “InsertPersonService,” which is the adapter service I created to write a record to the table. So far I have

pub.file.getFile
pub.flatFile.convertToValues

but I’m confused about how to proceed from here. Any help would be appreciated.

Hi Tony,

loop over the converted document (output of convertToValues)

  • map the fields to the inputs of InsertPersonService

Add Transaction Handling if neccessary.

See Service Development Help and “Working with Designer” Guide for details.

Regards,
Holger