Concatenate Rows into a JSON String

_AnonymousUser — Mon, 04 May 2015 18:30:35 GMT

I need to write a job that reads rows from a table and posts those records to a REST Web service with a JSON Object.
I'm newer to Talend so I need some advice. how/or which is the best way to concatenate rows into a JSON string object?
I tried using a THashInput component to hold the rows and then a tJava components to loop through the records but this just gives me one record at a time. Is there a way I could write a loop that would read all the records from the tHashInput object?

int currentRow=0;
while (currentRow<= tHashInput.lenght90)
{
//create a JsonString with 10 row records each
      for(i=0; i<=10; i++)
       {
        JsonString = JsonString  + "{\"u_Name\": \"" +row7.name + "\"}";
       }
currentRow = currentRow+1;
}

How can I read rows and concatenate their data into a single string?

Re: Concatenate Rows into a JSON String

Anonymous — Fri, 08 May 2015 11:58:13 GMT

Hello
Take a look tJavaFlex component, you can initialize a string in the begin part, and concatenate all the input records in the main part, and finally, store the string to global variable for used later on other component, you can find some explanation and an example about tJavaFlex in this KB article, let me know if you have any doubts.
Best regards
Shong

topic Concatenate Rows into a JSON String in Talend Studio

Concatenate Rows into a JSON String

Re: Concatenate Rows into a JSON String