Jquery Question posted in
The official Jquery Api Documentation can be found here.

Jquery – Extracting info from JSON response

I’m trying to get the last value of "TMiles" in the following JSON.

[{
  "__type": "MileageReport:http://pcmiler.alk.com/APIs/v1.0",
  "RouteID": null,
  "ReportLines": [{
    "Stop": {
      "Address": {
        "StreetAddress": "Apple Park Way",
        "City": "Cupertino",
        "State": "CA",
        "Zip": "95014",
        "County": "Santa Clara",
        "Country": "United States",
        "SPLC": null,
        "CountryPostalFilter": 0,
        "AbbreviationFormat": 0,
        "StateName": "California",
        "StateAbbreviation": "CA",
        "CountryAbbreviation": "US"
      },
      "Coords": {
        "Lat": "37.334866",
        "Lon": "-122.014282"
      },
      "Region": 4,
      "Label": "",
      "PlaceName": "",
      "TimeZone": "PDT",
      "Errors": [],
      "SpeedLimitInfo": null,
      "ConfidenceLevel": "Exact",
      "DistanceFromRoad": 0,
      "CrossStreet": null,
      "TimeZoneOffset": "GMT-7:00",
      "TimeZoneAbbreviation": "PDT",
      "IsDST": true
    },
    "LMiles": "0.000",
    "TMiles": "0.000",
    "LCostMile": "0.00",
    "TCostMile": "0.00",
    "LHours": "0:00",
    "THours": "0:00",
    "LTolls": "0.00",
    "TTolls": "0.00",
    "LEstghg": "0.0",
    "TEstghg": "0.0",
    "EtaEtd": null
  }, {
    "Stop": {
      "Address": {
        "StreetAddress": "22-26 West 34th Street",
        "City": "New York",
        "State": "NY",
        "Zip": "10001",
        "County": "New York",
        "Country": "United States",
        "SPLC": null,
        "CountryPostalFilter": 0,
        "AbbreviationFormat": 0,
        "StateName": "New York",
        "StateAbbreviation": "NY",
        "CountryAbbreviation": "US"
      },
      "Coords": {
        "Lat": "40.748462",
        "Lon": "-73.984770"
      },
      "Region": 4,
      "Label": "",
      "PlaceName": "",
      "TimeZone": "EDT",
      "Errors": [],
      "SpeedLimitInfo": null,
      "ConfidenceLevel": "Exact",
      "DistanceFromRoad": 0.003,
      "CrossStreet": null,
      "TimeZoneOffset": "GMT-4:00",
      "TimeZoneAbbreviation": "EDT",
      "IsDST": true
    },
    "LMiles": "2945.142",
    "TMiles": "2945.142",
    "LCostMile": "5690.99",
    "TCostMile": "5690.99",
    "LHours": "55:44",
    "THours": "55:44",
    "LTolls": "284.55",
    "TTolls": "284.55",
    "LEstghg": "9788.0",
    "TEstghg": "9788.0",
    "EtaEtd": null
  }],
  "TrafficDataUsed": false
}]

I’ve tried using multiple methods but to no avail. Here’s one i tried:

dataM = 'supplied json
var lastTMiles = dataM[0].ReportLines[dataM[0].ReportLines.length - 1].TMiles;

Here is my error:

Uncaught TypeError: Cannot read properties of undefined (reading 'length')
    at reqhttpM.onreadystatechange (mileage-finder.asp:280:60)

I’m not quite sure what to do here. Looking forward to responses. Thank you

Tags:

2

Answers


  1. 0

    A good way for you to do that is creating two variables, like this:

    const lastReportLine = dataM[0].ReportLines.pop();
const lastTMiles = lastReportLine.TMiles;

    Note that the first variable uses the .pop(), this function always gets the last item from the array. And the second variable accesses the TMiles field from the last report line.

    Login or Signup to reply.
  2. 0

    Modern runtimes allow the use of at()

    const lastReportLine = dataM[0].ReportLines.at(-1).lastReportLine.TMiles;
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search