Five Stars

How to extract the columns using textractjsonfields component?

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?

design.png

1 ACCEPTED SOLUTION

Accepted Solutions
Nine Stars

Re: How to extract the columns using textractjsonfields component?

Hi,

 

Please find the job details below.

 

jsonNew1.PNGJsonNew2.PNG

 

Regards,

Veeru Boppudi
5 REPLIES
Nine Stars

Re: How to extract the columns using textractjsonfields component?

Hi,

 

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

 

Regards,

Veeru Boppudi
Five Stars

Re: How to extract the columns using textractjsonfields component?

{"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}}
Five Stars

Re: How to extract the columns using textractjsonfields component?

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}}
Five Stars

Re: How to extract the columns using textractjsonfields component?

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}},

Nine Stars

Re: How to extract the columns using textractjsonfields component?

Hi,

 

Please find the job details below.

 

jsonNew1.PNGJsonNew2.PNG

 

Regards,

Veeru Boppudi