topic Re: [resolved] ExtractJSON Fields in Talend Studio

[resolved] ExtractJSON Fields

Anonymous — Sat, 16 Nov 2024 10:37:14 GMT

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

Re: [resolved] ExtractJSON Fields

Anonymous — Thu, 26 May 2016 09:09:37 GMT

Apologies, thought images were attached.

Re: [resolved] ExtractJSON Fields

Anonymous — Thu, 26 May 2016 13:42:51 GMT

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.

Re: [resolved] ExtractJSON Fields

Anonymous — Fri, 27 May 2016 10:15:30 GMT

Ok I managed to get it right.
See screenshots below