Parsing JSON with jQuery, retrieving two variables.

Question

I have a online JSON file that looks something like this:

[
{
"j": 0,
"i": 0,
"DepartureTime": "\/Date(1331667480000+0100)\/",
"ArrivalTime": "\/Date(1331668860000+0100)\/",
"Remarks": [],
"TravelStages": [
  {
    "ID": 0,
    "DepartureStop": {
      "WalkingDistance": 0,
      "ArrivalTime": null,
      "AlightingAllowed": false,
      "DepartureTime": null,
      "BoardingAllowed": false,
      "RealTimeStop": true,
      "Rank": 0,
      "Lines": null,
      "StopPoints": [
        {
          "ID": 1,
          "Name": "1",
          "X": 608127,
          "Y": 6645778
        }
      ],
      "Zone": "1",
      "X": 608133,
      "Y": 6645768,
      "ID": 2300500,
      "Name": "Visperud (i Solheimvn)",
      "District": "Lørenskog",
      "Type": 0,
      "Stops": [],
      "ShortName": "VIS"
    }]

What I want is the grab out the DepartureTime and ArrivalTime, I've seen some examples on how to parse the flickr JSON. But I can't figure out how I can parse this. I also want to store the departureTime and arrivalTime in two separate variables since the content of this two is a time measured in milliseconds since 1970. Can somebody give me a hint on how a can do this, am totally new to Javascript/JSON

it's a part of my JSON file, but its too long for posting her. — Tobias Moe Thorstensen
– Tobias Moe Thorstensen, Commented Mar 14, 2012 at 14:58

Dutchie432 · Accepted Answer · 2012-03-14 14:58:22Z

1

Do you have jQuery in your project? If so, you can easily parse the JSON string like this

var obj = $.parseJSON(theJsonText);
alert(obj.DepartureTime);

If not, I suggest including the JSON library (link) and using that.

answered Mar 14, 2012 at 14:58

Dutchie432

29.3k20 gold badges94 silver badges110 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Tobias Moe Thorstensen Over a year ago

But how can I specify the URL? just replacing the parameter? :)

nonchip Over a year ago

what URL? you didn't mention you don't have the string. then you'll need AJAX to get it... please clarify your question: you don't want to parse JSON, you want to download and parse JSON.

Austin Brunkhorst Over a year ago

He says he has an online JSON file, therefore needing to download it.

Tobias Moe Thorstensen Over a year ago

As my first sentence says: "I have a online JSON file that looks something like this" So I need to download it and parse it. But this file is constantly updated, so in this case I can't download it just one time, I guess.

nonchip Over a year ago

yeah, but e.g. many PHP scripts directly dump the json into the generated javascript, so it wasn't quite clear. I'll write an example below...

|

Austin Brunkhorst · Accepted Answer · 2012-03-14 14:59:58Z

1

You can try something like this, assuming that your json file is in jsonfile.json

$.getJSON('jsonfile.json', function(data){
    alert("Departure Time: "+ data.DepartureTime);
    alert("Arrival Time: "+ data.ArrivalTime);
});

http://api.jquery.com/jQuery.getJSON/

answered Mar 14, 2012 at 14:59

Austin Brunkhorst

21.1k6 gold badges49 silver badges61 bronze badges

Comments

nonchip · Accepted Answer · 2012-03-14 15:21:49Z

1

$.getJSON('http://your.domain.example/path/to/file.json', function(data) {
  departure_time=data.DepartureTime;
  arrival_time=data.ArrivalTime;
  do_something_with(departure_time,arrival_time);
});

then do_something_with(str,str) would be called with the strings "\/Date(1331667480000+0100)\/" and "\/Date(1331668860000+0100)\/" (in your example). you'll still have to convert the dates to numbers, e.g. by running:

parsed_date=new Date(parseInt(input_string.substr(7)));
//substr(7) cuts after "\/Date(", and parseInt ignores ")\/"
//but I don't know how it handles "+0100"

edited Mar 14, 2012 at 15:21

answered Mar 14, 2012 at 15:00

nonchip

1,0993 gold badges18 silver badges37 bronze badges

Comments

Kristian · Accepted Answer · 2012-03-14 15:00:50Z

0

Thats an array containing objects, so you should be able to just set some vars equal to the properties of the first index. to use it like an object, it needs to be parsed.. so either eval(thatJson) or $.parseJSON(thatJson) and then iterate through it.

var responses = [
{
"j": 0,
"i": 0,
"DepartureTime": "\/Date(1331667480000+0100)\/",
"ArrivalTime": "\/Date(1331668860000+0100)\/",
"Remarks": [],
...
}];

var dep = responses[0].DepartureTime;
var arr = responses[0].ArrivalTime;

answered Mar 14, 2012 at 15:00

Kristian

22k19 gold badges108 silver badges184 bronze badges

Comments

Ayush · Accepted Answer · 2012-03-14 15:02:17Z

0

According to JSONLint.com, your string isn't valid JSON. That is, however, a different issue than what your question asks for.

Assuming a valid subset of your string

var a = '[{"j": 0,"i": 0,"DepartureTime": "/Date(1331667480000+0100)/",      "ArrivalTime": "/Date(1331668860000+0100)/","Remarks": []}]';

var obj = $.parseJSON(a);
console.log(obj[0].ArrivalTime);

answered Mar 14, 2012 at 15:02

Ayush

42.5k52 gold badges169 silver badges243 bronze badges

Collectives™ on Stack Overflow

Parsing JSON with jQuery, retrieving two variables.

5 Answers 5

6 Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

6 Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related