[resolved] Need help parsing json file

rlmagidson — Tue, 14 Feb 2017 21:43:33 GMT

Given the following in a json file (call it event.json):
{"fc_Mid":"","GPS Quality":"1","fc_fmi":"14","DSN":"7037452","VIN":"ABC1234567890","sentDateTime":"02/10/2017 18:44:59","type":"Fault Codes","fc_SA":"3","version":"1.00","faultcodeType":"2","fc_speed":"0","longitude":"-74.0088599","fc_pid_sidIndicator":"","fc_spn":"70","fc_odometer":"31411.1","cruiseStatus":"0","pfmDriverId":"244040","fc_rpm":"649","fc_Code":"","vehicleNumber":"10807","ignitionStatus":"1","triggerDate":"02/10/2017 18:44:59","occurrenceCount":"1","urgentFlag":"0","latitude":"40.6117188","companyId":"A899"}
I don't seem to have luck getting to the elements of this file. Would someone be able to post an example job that parses the elements and just prints them out with tLogRow? What would the loop Json query and mapping look like?
Clearly I need to do more with the data but I can't even get past this first part.
Many thanks for the help
- rlm

Re: [resolved] Need help parsing json file

Anonymous — Wed, 15 Feb 2017 02:08:41 GMT

Hi
Select 'JsonPath without loop' in the readby list of tFileInputJson, and define the mapping fields which you want to extract, see below:

Regards
Shong

Re: [resolved] Need help parsing json file

rlmagidson — Wed, 15 Feb 2017 14:41:07 GMT

Thank you, Shong, that got me moving. I will no doubt have more questions as I progress deeper into the project and I appreciate your helping out as you did.
- rlm

topic [resolved] Need help parsing json file in Talend Studio

[resolved] Need help parsing json file

Re: [resolved] Need help parsing json file

Re: [resolved] Need help parsing json file