[resolved] ExtractJSON Fields

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
 
 

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch