[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
 
 

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download