Parst CSV file and for each row make an API call to start Camunda Process

[GChest630399416]

I'm new to Open Studio so be gentle and thanks in advance for the help.

My overall goal is to parse a CSV file and for each row make an API call.

I want to start a Camunda Process and pass the row header & row data in the JSON format to pass variables to the process.

The JSON passed to the API call will be formatted like;

{

"variables": {

"HeaderColumn1": {"value":"Row1DataColumn1","type":"String"},

"HeaderColumn2": {"value":"Row1DataColumn2","type":"String"},

}

}

Here is what I have so far.

 

Any help is greatly appreciated.

[gjeremy1617088143]

Hi @George Chester​  you can use tFlowToIterate component , it will stock each column of a row in globalVar, you can call them at any time in the iteration

eg:

if you iterate on a main flow row1 and your column name is col1 you can get the value of col1 with :

(String)globalMap.get("row1.col1")

Send me love and kudos