topic JSON response issue in Talend Studio

JSON response issue

Ravi_Rajagopal — Thu, 07 Mar 2024 14:03:06 GMT

I have students data from a "getStudents" API call assembled together in a tHashInput component which has 2 students data. I don't know how to create the following output I have included a word document that has a snapshot of the code.

Note: The schema shown in the attached document might look different than the data provided below. Due to data-privacy I have removed the original content.

{

"total": "2",

"limit": 10,

"offset": 0,

"students": [

{

"id": 1,

"first_name": "AAA",

"last_name": "BBB"

{

"id": 2,

"first_name": "YYY",

"last_name": "ZZZ"

}

]

}

Re: JSON response issue

Shicong_Hong — Wed, 13 Mar 2024 03:04:33 GMT

Hello

You need to set the attribute of 'students' element as 'array', see the configuration of JSON tree as below.

It will generate a Json string like this:

{"total":"2","students":[{"id":"1","firstname":"AAA","lastname":"BBB"},{"id":"2","firstname":"CCC","lastname":"DDD"}]}

Please try it and let me know if it works.

Regards

Shicong