topic Re: How to extract the columns using textractjsonfields component? in Talend Studio

How to extract the columns using textractjsonfields component?

Anonymous — Sat, 16 Nov 2024 08:23:22 GMT

Hi, can anyone please tell me how to extract the columns from the json fields using textractjsonfields component. Actually, I got

statuscode,

body,

string, fields from trestclient. But i want to extract the fields like

Id,

UnitId,

Direction,
DriverKeyCode,
EventTypeId,
EventTypeDescription,
LocalTimestamp,
Odometer,
Position.

from textractjsonfields to store in a tables in mysql db. how can i achieve that?

Re: How to extract the columns using textractjsonfields component?

vboppudi — Wed, 18 Apr 2018 14:55:55 GMT

Hi,

If possible, can you please provide some sample source data and expected output.

Regards,

Re: How to extract the columns using textractjsonfields component?

Anonymous — Wed, 18 Apr 2018 15:04:03 GMT

{"Id":42977953848,"UnitId":"261321220784","Direction":357.00,"DriverKeyCode":4554,"EventTypeId":149,"EventTypeDescription":"Start of Speeding","LocalTimestamp":"2018-04-17T13:38:40+03:00","Odometer":538966,"Position":[47.05319,-20.02582],"Speed":47.00,"UnitOfDistanceCode":"km","StartOfExceptionData":{"Limit":45.0}},{"Id":42977956432,"UnitId":"261321255664","Direction":359.00,"DriverKeyCode":5609,"EventTypeId":150,"EventTypeDescription":"Speeding","LocalTimestamp":"2018-04-17T13:38:49+03:00","Odometer":538966,"Position":[47.05311,-20.02482],"Speed":47.00,"UnitOfDistanceCode":"km","EndOfExceptionData":{"Limit":45.0,"Maximum":47.0,"Duration":15}}

Re: How to extract the columns using textractjsonfields component?

Anonymous — Wed, 18 Apr 2018 20:38:29 GMT

Hi, here is my sample data. Thanks for reply.{"Id":42977454532,"UnitId":"261321754876","Direction":357.00,"DriverKeyCode":7659,"EventTypeId":149,"EventTypeDescription":"Start of Speeding","LocalTimestamp":"2018-04-17T13:38:40+03:00","Odometer":538966,"Position":[47.05319,-20.02582],"Speed":47.00,"UnitOfDistanceCode":"km","StartOfExceptionData":{"Limit":45.0}},{"Id":42977657488,"UnitId":"261321977589","Direction":359.00,"DriverKeyCode":6754,"EventTypeId":150,"EventTypeDescription":"Speeding","LocalTimestamp":"2018-04-17T13:38:49+03:00","Odometer":538966,"Position":[47.05311,-20.02482],"Speed":47.00,"UnitOfDistanceCode":"km","EndOfExceptionData":{"Limit":45.0,"Maximum":47.0,"Duration":15}}

Re: How to extract the columns using textractjsonfields component?

Anonymous — Thu, 19 Apr 2018 08:46:22 GMT

Hi sir, Here ia a sample code.

{"Id":43052523918,"UnitId":"261328569321","Direction":3.00,"DriverKeyCode":4636,"EventTypeId":149,"EventTypeDescription":"Start of Speeding","LocalTimestamp":"2018-04-18T07:06:38+03:00","Odometer":849199,"Position":[47.54472,-18.97462],"Speed":52.00,"UnitOfDistanceCode":"km","StartOfExceptionData":{"Limit":45.0}},{"Id":43006548637,"UnitId":"261321525445","Direction":78.00,"DriverKeyCode":5622,"EventTypeId":150,"EventTypeDescription":"Speeding","LocalTimestamp":"2018-04-18T07:06:49+03:00","Odometer":801156,"Position":[49.26359,-18.26405],"Speed":48.00,"UnitOfDistanceCode":"km","EndOfExceptionData":{"Limit":45.0,"Maximum":48.0,"Duration":33}},

Re: How to extract the columns using textractjsonfields component?

vboppudi — Fri, 20 Apr 2018 15:23:00 GMT

Hi,

Please find the job details below.

Regards,