Json Parsing

One Star

Json Parsing

Hi,
I am new to Talend. Just started exploring. I need some help on below things.
I have made a http request to a site and i got the output in json format. so now the challenge is in parsing this data.
How do i do this with talend. The only way which i found is to load this data to a file using tFileOutputJSON and then in a new job import this file using tFileInputJSON. Also it is not parsing the data in right way.
Where as things were much straight forward in the other ETL tool which i was using earlier.
Also is there a way to preview the data after each step(within the job). currently I am loading the data to an Excel or table and then previewing it.
Please help.
Thanks,
Berin.
Community Manager

Re: Json Parsing

Hi Berin
Since v5.3.0, we have a new component called tExtractJSONField, it can parse the response with json format directly. see jira issue:
https://jira.talendforge.org/browse/DOCT-1376
I suggest you to download v5.3.0RC1 from Talend website and test this component.
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Json Parsing

Hi Berin
Since v5.3.0, we have a new component called tExtractJSONField, it can parse the response with json format directly. see jira issue:
https://jira.talendforge.org/browse/DOCT-1376
I suggest you to download v5.3.0RC1 from Talend website and test this component.
Shong

Thanks Shong, currently I am using v5.2.2 I'll dowload v5.3 and check it.
I need one more help.
Is there a way to preview the data after each step(within the job). currently I am loading the data to an Excel or table and then previewing it.

Berin
One Star

Re: Json Parsing

Thanks Shong, currently I am using v5.2.2 I'll dowload v5.3 and check it.
I need one more help.
Is there a way to preview the data after each step(within the job). currently I am loading the data to an Excel or table and then previewing it.

Also while fetching data from excel, is there a way to fetch only some required columns in random order. Currently using tFileInputExcel we can fetch the columns in order.
Example. If we are having 4 columns (say A,B,C,D) and I want to fetch only 3 random columns(say A,C,D). Also is there a way to interchange the columns (say C,A,D).
Please help.
Thanks
Berin
Seventeen Stars

Re: Json Parsing

With the build-in components you have to read all columns (from the first relevant column until the last relevant column) and this can cause sometimes problems especially for Excel files because of the possibility of different data types from row to row in the same column.
You can try the component suite tFileExcelSheetInput:
http://www.talendforge.org/exchange/index.php?eid=663&product=tos&action=view&nav=1,1,1
This component lets you decide what you will read and you will ommit. For text files a similiar functionality is possible with tFileInputTextFlat:
http://www.talendforge.org/exchange/index.php?eid=745&product=tos&action=view&nav=0,1,1
One Star

Re: Json Parsing

Thanks jlolling.
Will check this.