Unable to map the JSON file using TFileInputJSON

Highlighted
Four Stars

Unable to map the JSON file using TFileInputJSON

Hi All,

 

I'm unable to map the JSON file using tFileInputJSON and attached the sample file .

Can anyone advice me on this?


Accepted Solutions
Employee

Re: Unable to map the JSON file using TFileInputJSON

Hi,

 

   I was able to do it by adding the file to Repository flow as shown below. In the repository, create JSON and select Input. The next stages are as shown below. First add the root path and after that map the columns.

image.png

 

image.png

 

I was able to print the data as shown below. Please note that I selected vertical mode in tLogrow to show the data easily. You can select normal or table mode too.

image.png

 

I hope you got the answer for your query. Please spare a second to mark the topic as resolved. Kudos will be a bonus :-)

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)

 

 

 

 


All Replies
Twelve Stars

Re: Unable to map the JSON file using TFileInputJSON

try to remove spaces.
check couples of {}
try to shrink it star wit a smaller one.

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Employee

Re: Unable to map the JSON file using TFileInputJSON

Hi,

 

   I was able to do it by adding the file to Repository flow as shown below. In the repository, create JSON and select Input. The next stages are as shown below. First add the root path and after that map the columns.

image.png

 

image.png

 

I was able to print the data as shown below. Please note that I selected vertical mode in tLogrow to show the data easily. You can select normal or table mode too.

image.png

 

I hope you got the answer for your query. Please spare a second to mark the topic as resolved. Kudos will be a bonus :-)

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)

 

 

 

 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog