[resolved] ExtractJSON Fields

Highlighted
One Star

[resolved] ExtractJSON Fields

Hi Guys
Can anyone point me in the right direction with regards to setting up the Textractjsonfields component to suite my needs.
The Data I am receiving from TrestClient -> TLog is as follows:
Starting job JSON_to_CallStats at 09:55 26/05/2016.
connecting to socket on port 3912
connected
200||{
 "CallDistrDO.AnsDistrPerDay" : , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ],
 "result" : , , , ]
}
disconnected
Job JSON_to_CallStats ended at 09:55 26/05/2016.

Please see screenshots of other settings.

Any help would be highly appreciated.
Regards

Accepted Solutions
One Star

Re: [resolved] ExtractJSON Fields

Ok I managed to get it right.
See screenshots below
 
 

All Replies
One Star

Re: [resolved] ExtractJSON Fields

Apologies, thought images were attached.
Seventeen Stars

Re: [resolved] ExtractJSON Fields

Your format is - simply speaking - a misusage of the JSON format and you will not be able to extract these data in a simple way.
One Star

Re: [resolved] ExtractJSON Fields

Ok I managed to get it right.
See screenshots below
 
 

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