extracting coordinates from json

One Star

extracting coordinates from json

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... 
One Star

Re: extracting coordinates from json

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.