extracting coordinates from json

Anonymous — Tue, 18 Nov 2014 07:22:01 GMT

payload" :
{
"asset" : "356363051312744",
"loc" : ,
"fields" : {
"GPS_DIR" : {
"b64_value" : "AABKLg=="
}
}
}
i have json in this format i would like to extract 'loc' from it, when i give the xpath query as ("../loc") it extracts only the first part i.e. '80.25641' i tried with each and every data type available like string, big decimal, etc but the second part is not showing up.

plz help some one...

Re: extracting coordinates from json

_AnonymousUser — Tue, 18 Nov 2014 20:15:09 GMT

If you want to extract that data once only, you can paste the JSON into json-csv.com then open the CSV file in Excel to extract the data.

topic extracting coordinates from json in Talend Studio

extracting coordinates from json

Re: extracting coordinates from json