Since v5.3.0, we have a new component called tExtractJSONField, it can parse the response with json format directly. see jira issue:
I suggest you to download v5.3.0RC1 from Talend website and test this component.
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.