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

GChest630399416 — Fri, 15 Nov 2024 23:47:42 GMT

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.

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

gjeremy1617088143 — Thu, 02 Sep 2021 14:26:34 GMT

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

topic Parst CSV file and for each row make an API call to start Camunda Process in Talend Studio

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

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