not able to read json file properly

rohit1804 — Tue, 04 Oct 2022 16:15:05 GMT

Hi All,

I want to read json file and need to store data in table , I have data like below

"data" : {

"port" : {

"1000" : [

"port 1",

"port 2",

"port 3"

]

}

-----------------------------------------------------------------

RESULT I want as below in table format

ID | Port

---------------------------

1000 | Port 1

1000 | Port 2

1000 | Port 3

---------------------------

Please help me to achieve this using Talend component.

Re: not able to read json file properly

Anonymous — Tue, 04 Oct 2022 22:14:23 GMT

Your JSON file does not look correct. For a start JSON will start with curly bracket ( "{" ) and it looks like your port data may be incorrect. Is this copied directly from your source (if so, I think that may need looking at) or have you typed it out and maybe made a couple of mistake?

topic not able to read json file properly in Talend Studio

not able to read json file properly

Re: not able to read json file properly