Help with SimpleJSON

Posted on
Thu Jul 23, 2015 12:20 pm
steinis offline
Posts: 80
Joined: Jul 17, 2015
Location: Oslo, NORWAY

Help with SimpleJSON

Hello

Im a new when its comes to JSON and ned som help how to display the different values in this link: http://reisapi.ruter.no/stopvisit/getdepartures/3012430

This is what I have so far:
Code: Select all
import urllib2
import simplejson as json
f = urllib2.urlopen('http://reisapi.ruter.no/stopvisit/getdepartures/3012430')
json_string = f.read()
parsed_json = json.loads(json_string)

indigo.variable.updateValue(648137543, str(parsed_json['Header']))

f.close()


This is not working and I receive this error: embedded script: list indices must be integers, not str.

This is to receive input about Norwegian bus/subway stops in realtime:) This page is in english and have some commands: http://labs.ruter.no/how-to-use-the-api ... tures.aspx

thanks in advance for any input and sorry for my bad understanding of JSON:)

Posted on
Thu Jul 23, 2015 12:56 pm
kw123 offline
User avatar
Posts: 8366
Joined: May 12, 2013
Location: Dallas, TX

Re: Help with SimpleJSON

add after f.read
indigo.server.log(unicode(json_string))

then post the log file output

and i would just do::
json_string= urllib2.urlopen('http://reisapi.ruter.no/stopvisit/getdepartures/3012430').read()
if you don't want to do anything with the url handle later.

also ' should be " in json. It works in python but not in json everywhere.

Karl

Posted on
Thu Jul 23, 2015 1:42 pm
jay (support) offline
Site Admin
User avatar
Posts: 18224
Joined: Mar 19, 2008
Location: Austin, Texas

Re: Help with SimpleJSON

I just hit the URL in Safari and got back XML (not JSON)...

Jay (Indigo Support)
Twitter | Facebook | LinkedIn

Posted on
Thu Jul 23, 2015 2:19 pm
FlyingDiver offline
User avatar
Posts: 7222
Joined: Jun 07, 2014
Location: Southwest Florida, USA

Re: Help with SimpleJSON

jay (support) wrote:
I just hit the URL in Safari and got back XML (not JSON)...


I did too, but when you fetch it in Terminal with curl, you get back JSON. I think Safari is doing something weird.

joe

joe (aka FlyingDiver)
my plugins: http://forums.indigodomo.com/viewforum.php?f=177

Posted on
Thu Jul 23, 2015 2:30 pm
steinis offline
Posts: 80
Joined: Jul 17, 2015
Location: Oslo, NORWAY

Re: Help with SimpleJSON

thanks for quick replay:)!

maybe this is better: http://reisapi.ruter.no/stopvisit/getde ... ?JSON=true

Im getting an error on the log command: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 302: ordinal not in range(128)


thanks.

Posted on
Thu Jul 23, 2015 2:49 pm
jay (support) offline
Site Admin
User avatar
Posts: 18224
Joined: Mar 19, 2008
Location: Austin, Texas

Re: Help with SimpleJSON

Below is what you're getting back. It's a list of dictionaries (which is why you can't use parsed_json["Header"] - the top level object is a list not a dictionary).

Further, each dictionary has 4 elements: "Extensions", "MonitoringRef", MonitoredVehicleJourney", and "RecordedAtTime", so none of those are "Header". In fact, the only "Header" key is a very buried in the structure:

Code: Select all
parsed_json[0]["Extensions"]["Deviations"][0]["Header"]


Not sure that's what you're looking for but that's the only one I can spot. And each of the dictionaries in the list has one (I just referred to the first one above) so I don't know if it's the right one for your purpose.

Code: Select all
>>> print json.dumps(parsed_json, indent=4)
[
    {
        "Extensions": {
            "IsHub": false,
            "LineColour": "F07800",
            "OccupancyData": {
                "OccupancyAvailable": false,
                "OccupancyPercentage": 0
            },
            "Deviations": [
                {
                    "Header": "T-bane 5: Endret morgenavgang fra 21. juni",
                    "ID": 31505
                }
            ]
        },
        "MonitoringRef": "3012430",
        "MonitoredVehicleJourney": {
            "MonitoredCall": {
                "VisitNumber": 29,
                "DestinationDisplay": "\u00d8ster\u00e5s",
                "VehicleAtStop": false,
                "AimedDepartureTime": "2015-07-23T22:32:50+02:00",
                "DeparturePlatformName": "2 (Retning \u00d8ster\u00e5s)",
                "AimedArrivalTime": "2015-07-23T22:32:50+02:00",
                "ExpectedDepartureTime": "2015-07-23T22:37:31+02:00",
                "ExpectedArrivalTime": "2015-07-23T22:37:31+02:00"
            },
            "OperatorRef": "me",
            "OriginAimedDepartureTime": "0001-01-01T00:00:00",
            "Delay": "PT281S",
            "DestinationRef": 2190090,
            "DestinationAimedArrivalTime": "0001-01-01T00:00:00",
            "PublishedLineName": "5",
            "Monitored": true,
            "TrainBlockPart": {
                "NumberOfBlockParts": 6
            },
            "VehicleMode": 4,
            "LineRef": "5",
            "FramedVehicleJourneyRef": {
                "DataFrameRef": "2015-07-23",
                "DatedVehicleJourneyRef": "1540"
            },
            "DirectionRef": "2",
            "InCongestion": false,
            "DestinationName": "\u00d8ster\u00e5s",
            "OriginName": "VES2",
            "OriginRef": "3011730",
            "VehicleFeatureRef": "",
            "VehicleRef": "69",
            "BlockRef": "505:4S15H02",
            "DirectionName": "2",
            "VehicleJourneyName": ""
        },
        "RecordedAtTime": "2015-07-23T22:36:43.98+02:00"
    },
    {
        "Extensions": {
            "IsHub": false,
            "LineColour": "F07800",
            "OccupancyData": {
                "OccupancyAvailable": false,
                "OccupancyPercentage": 0
            },
            "Deviations": [
                {
                    "Header": "T-bane 5: Endret morgenavgang fra 21. juni",
                    "ID": 31505
                }
            ]
        },
        "MonitoringRef": "3012430",
        "MonitoredVehicleJourney": {
            "MonitoredCall": {
                "VisitNumber": 6,
                "DestinationDisplay": "Vestli",
                "VehicleAtStop": false,
                "AimedDepartureTime": "2015-07-23T22:40:57+02:00",
                "DeparturePlatformName": "1 (Retning sentrum)",
                "AimedArrivalTime": "2015-07-23T22:40:57+02:00",
                "ExpectedDepartureTime": "2015-07-23T22:41:47+02:00",
                "ExpectedArrivalTime": "2015-07-23T22:41:47+02:00"
            },
            "OperatorRef": "me",
            "OriginAimedDepartureTime": "0001-01-01T00:00:00",
            "Delay": "PT50S",
            "DestinationRef": 3011730,
            "DestinationAimedArrivalTime": "0001-01-01T00:00:00",
            "PublishedLineName": "5",
            "Monitored": true,
            "TrainBlockPart": {
                "NumberOfBlockParts": 6
            },
            "VehicleMode": 4,
            "LineRef": "5",
            "FramedVehicleJourneyRef": {
                "DataFrameRef": "2015-07-23",
                "DatedVehicleJourneyRef": "1515"
            },
            "DirectionRef": "1",
            "InCongestion": false,
            "DestinationName": "Vestli",
            "OriginName": "\u00d8S\u00c52",
            "OriginRef": "2190090",
            "VehicleFeatureRef": "",
            "VehicleRef": "68",
            "BlockRef": "504:4S15H02",
            "DirectionName": "1",
            "VehicleJourneyName": "59491"
        },
        "RecordedAtTime": "2015-07-23T22:36:43.98+02:00"
    },
    {
        "Extensions": {
            "IsHub": false,
            "LineColour": "F07800",
            "OccupancyData": {
                "OccupancyAvailable": false,
                "OccupancyPercentage": 0
            },
            "Deviations": [
                {
                    "Header": "T-bane 5: Endret morgenavgang fra 21. juni",
                    "ID": 31505
                }
            ]
        },
        "MonitoringRef": "3012430",
        "MonitoredVehicleJourney": {
            "MonitoredCall": {
                "VisitNumber": 29,
                "DestinationDisplay": "\u00d8ster\u00e5s",
                "VehicleAtStop": false,
                "AimedDepartureTime": "2015-07-23T22:47:50+02:00",
                "DeparturePlatformName": "2 (Retning \u00d8ster\u00e5s)",
                "AimedArrivalTime": "2015-07-23T22:47:50+02:00",
                "ExpectedDepartureTime": "2015-07-23T22:48:32+02:00",
                "ExpectedArrivalTime": "2015-07-23T22:48:32+02:00"
            },
            "OperatorRef": "me",
            "OriginAimedDepartureTime": "0001-01-01T00:00:00",
            "Delay": "PT42S",
            "DestinationRef": 2190090,
            "DestinationAimedArrivalTime": "0001-01-01T00:00:00",
            "PublishedLineName": "5",
            "Monitored": true,
            "TrainBlockPart": {
                "NumberOfBlockParts": 3
            },
            "VehicleMode": 4,
            "LineRef": "5",
            "FramedVehicleJourneyRef": {
                "DataFrameRef": "2015-07-23",
                "DatedVehicleJourneyRef": "1564"
            },
            "DirectionRef": "2",
            "InCongestion": false,
            "DestinationName": "\u00d8ster\u00e5s",
            "OriginName": "VES2",
            "OriginRef": "3011730",
            "VehicleFeatureRef": "",
            "VehicleRef": "70",
            "BlockRef": "506:4S15H02",
            "DirectionName": "2",
            "VehicleJourneyName": "58844"
        },
        "RecordedAtTime": "2015-07-23T22:36:43.98+02:00"
    },
    {
        "Extensions": {
            "IsHub": false,
            "LineColour": "F07800",
            "OccupancyData": {
                "OccupancyAvailable": false,
                "OccupancyPercentage": 0
            },
            "Deviations": [
                {
                    "Header": "T-bane 5: Endret morgenavgang fra 21. juni",
                    "ID": 31505
                }
            ]
        },
        "MonitoringRef": "3012430",
        "MonitoredVehicleJourney": {
            "MonitoredCall": {
                "VisitNumber": 6,
                "DestinationDisplay": "Ryen",
                "VehicleAtStop": false,
                "AimedDepartureTime": "2015-07-23T22:55:57+02:00",
                "DeparturePlatformName": "1 (Retning sentrum)",
                "AimedArrivalTime": "2015-07-23T22:55:57+02:00",
                "ExpectedDepartureTime": "2015-07-23T22:55:57+02:00",
                "ExpectedArrivalTime": "2015-07-23T22:55:57+02:00"
            },
            "OperatorRef": "me",
            "OriginAimedDepartureTime": "0001-01-01T00:00:00",
            "Delay": "PT0S",
            "DestinationRef": 3011200,
            "DestinationAimedArrivalTime": "0001-01-01T00:00:00",
            "PublishedLineName": "5",
            "Monitored": true,
            "TrainBlockPart": {
                "NumberOfBlockParts": 6
            },
            "VehicleMode": 4,
            "LineRef": "5",
            "FramedVehicleJourneyRef": {
                "DataFrameRef": "2015-07-23",
                "DatedVehicleJourneyRef": "1541"
            },
            "DirectionRef": "1",
            "InCongestion": false,
            "DestinationName": "Ryen",
            "OriginName": "\u00d8S\u00c52",
            "OriginRef": "2190090",
            "VehicleFeatureRef": "",
            "VehicleRef": "69",
            "BlockRef": "505:4S15H02",
            "DirectionName": "1",
            "VehicleJourneyName": "60322"
        },
        "RecordedAtTime": "2015-07-23T22:36:43.98+02:00"
    },
    {
        "Extensions": {
            "IsHub": false,
            "LineColour": "F07800",
            "OccupancyData": {
                "OccupancyAvailable": false,
                "OccupancyPercentage": 0
            },
            "Deviations": [
                {
                    "Header": "T-bane 5: Endret morgenavgang fra 21. juni",
                    "ID": 31505
                }
            ]
        },
        "MonitoringRef": "3012430",
        "MonitoredVehicleJourney": {
            "MonitoredCall": {
                "VisitNumber": 6,
                "DestinationDisplay": "Vestli",
                "VehicleAtStop": false,
                "AimedDepartureTime": "2015-07-23T23:10:57+02:00",
                "DeparturePlatformName": "1 (Retning sentrum)",
                "AimedArrivalTime": "2015-07-23T23:10:57+02:00",
                "ExpectedDepartureTime": "2015-07-23T23:10:57+02:00",
                "ExpectedArrivalTime": "2015-07-23T23:10:57+02:00"
            },
            "OperatorRef": "me",
            "OriginAimedDepartureTime": "0001-01-01T00:00:00",
            "Delay": "PT0S",
            "DestinationRef": 3011730,
            "DestinationAimedArrivalTime": "0001-01-01T00:00:00",
            "PublishedLineName": "5",
            "Monitored": true,
            "TrainBlockPart": {
                "NumberOfBlockParts": 3
            },
            "VehicleMode": 4,
            "LineRef": "5",
            "FramedVehicleJourneyRef": {
                "DataFrameRef": "2015-07-23",
                "DatedVehicleJourneyRef": "1565"
            },
            "DirectionRef": "1",
            "InCongestion": false,
            "DestinationName": "Vestli",
            "OriginName": "\u00d8S\u00c52",
            "OriginRef": "2190090",
            "VehicleFeatureRef": "",
            "VehicleRef": "70",
            "BlockRef": "506:4S15H02",
            "DirectionName": "1",
            "VehicleJourneyName": "59488"
        },
        "RecordedAtTime": "2015-07-23T22:36:43.98+02:00"
    },
    {
        "Extensions": {
            "IsHub": false,
            "LineColour": "F07800",
            "OccupancyData": {
                "OccupancyAvailable": false,
                "OccupancyPercentage": 0
            },
            "Deviations": [
                {
                    "Header": "T-bane 5: Endret morgenavgang fra 21. juni",
                    "ID": 31505
                }
            ]
        },
        "MonitoringRef": "3012430",
        "MonitoredVehicleJourney": {
            "MonitoredCall": {
                "VisitNumber": 29,
                "DestinationDisplay": "\u00d8ster\u00e5s",
                "VehicleAtStop": false,
                "AimedDepartureTime": "2015-07-23T23:17:50+02:00",
                "DeparturePlatformName": "2 (Retning \u00d8ster\u00e5s)",
                "AimedArrivalTime": "2015-07-23T23:17:50+02:00",
                "ExpectedDepartureTime": "2015-07-23T23:17:50+02:00",
                "ExpectedArrivalTime": "2015-07-23T23:17:50+02:00"
            },
            "OperatorRef": "me",
            "OriginAimedDepartureTime": "0001-01-01T00:00:00",
            "Delay": "PT0S",
            "DestinationRef": 2190090,
            "DestinationAimedArrivalTime": "0001-01-01T00:00:00",
            "PublishedLineName": "5",
            "Monitored": false,
            "TrainBlockPart": {
                "NumberOfBlockParts": 3
            },
            "VehicleMode": 4,
            "LineRef": "5",
            "FramedVehicleJourneyRef": {
                "DataFrameRef": "2015-07-23",
                "DatedVehicleJourneyRef": "1611"
            },
            "DirectionRef": "2",
            "InCongestion": false,
            "DestinationName": "\u00d8ster\u00e5s",
            "OriginName": "VES2",
            "OriginRef": "3011730",
            "VehicleFeatureRef": "",
            "VehicleRef": "72",
            "BlockRef": "508:4S15H02",
            "DirectionName": "2",
            "VehicleJourneyName": "58842"
        },
        "RecordedAtTime": "2015-07-23T22:36:43.996+02:00"
    },
    {
        "Extensions": {
            "IsHub": false,
            "LineColour": "F07800",
            "OccupancyData": {
                "OccupancyAvailable": false,
                "OccupancyPercentage": 0
            },
            "Deviations": [
                {
                    "Header": "T-bane 5: Endret morgenavgang fra 21. juni",
                    "ID": 31505
                }
            ]
        },
        "MonitoringRef": "3012430",
        "MonitoredVehicleJourney": {
            "MonitoredCall": {
                "VisitNumber": 0,
                "DestinationDisplay": "Vestli",
                "VehicleAtStop": false,
                "AimedDepartureTime": "2015-07-23T23:41:00+02:00",
                "DeparturePlatformName": "1 (Retning sentrum)",
                "AimedArrivalTime": "2015-07-23T23:41:00+02:00",
                "ExpectedDepartureTime": "2015-07-23T23:41:00+02:00",
                "ExpectedArrivalTime": "2015-07-23T23:41:00+02:00"
            },
            "OperatorRef": null,
            "OriginAimedDepartureTime": "0001-01-01T00:00:00",
            "Delay": null,
            "DestinationRef": 0,
            "DestinationAimedArrivalTime": "0001-01-01T00:00:00",
            "PublishedLineName": "5",
            "Monitored": false,
            "TrainBlockPart": null,
            "VehicleMode": 4,
            "LineRef": "5",
            "FramedVehicleJourneyRef": null,
            "DirectionRef": null,
            "InCongestion": false,
            "DestinationName": "Vestli",
            "OriginName": null,
            "OriginRef": null,
            "VehicleFeatureRef": null,
            "VehicleRef": null,
            "BlockRef": null,
            "DirectionName": null,
            "VehicleJourneyName": "59486"
        },
        "RecordedAtTime": "0001-01-01T00:00:00"
    },
    {
        "Extensions": {
            "IsHub": false,
            "LineColour": "F07800",
            "OccupancyData": {
                "OccupancyAvailable": false,
                "OccupancyPercentage": 0
            },
            "Deviations": [
                {
                    "Header": "T-bane 5: Endret morgenavgang fra 21. juni",
                    "ID": 31505
                }
            ]
        },
        "MonitoringRef": "3012430",
        "MonitoredVehicleJourney": {
            "MonitoredCall": {
                "VisitNumber": 0,
                "DestinationDisplay": "\u00d8ster\u00e5s",
                "VehicleAtStop": false,
                "AimedDepartureTime": "2015-07-23T23:48:00+02:00",
                "DeparturePlatformName": "2 (Retning \u00d8ster\u00e5s)",
                "AimedArrivalTime": "2015-07-23T23:48:00+02:00",
                "ExpectedDepartureTime": "2015-07-23T23:48:00+02:00",
                "ExpectedArrivalTime": "2015-07-23T23:48:00+02:00"
            },
            "OperatorRef": null,
            "OriginAimedDepartureTime": "0001-01-01T00:00:00",
            "Delay": null,
            "DestinationRef": 0,
            "DestinationAimedArrivalTime": "0001-01-01T00:00:00",
            "PublishedLineName": "5",
            "Monitored": false,
            "TrainBlockPart": null,
            "VehicleMode": 4,
            "LineRef": "5",
            "FramedVehicleJourneyRef": null,
            "DirectionRef": null,
            "InCongestion": false,
            "DestinationName": "\u00d8ster\u00e5s",
            "OriginName": null,
            "OriginRef": null,
            "VehicleFeatureRef": null,
            "VehicleRef": null,
            "BlockRef": null,
            "DirectionName": null,
            "VehicleJourneyName": "58839"
        },
        "RecordedAtTime": "0001-01-01T00:00:00"
    },
    {
        "Extensions": {
            "IsHub": false,
            "LineColour": "F07800",
            "OccupancyData": {
                "OccupancyAvailable": false,
                "OccupancyPercentage": 0
            },
            "Deviations": [
                {
                    "Header": "T-bane 5: Endret morgenavgang fra 21. juni",
                    "ID": 31505
                }
            ]
        },
        "MonitoringRef": "3012430",
        "MonitoredVehicleJourney": {
            "MonitoredCall": {
                "VisitNumber": 0,
                "DestinationDisplay": "Vestli",
                "VehicleAtStop": false,
                "AimedDepartureTime": "2015-07-24T00:11:00+02:00",
                "DeparturePlatformName": "1 (Retning sentrum)",
                "AimedArrivalTime": "2015-07-24T00:11:00+02:00",
                "ExpectedDepartureTime": "2015-07-24T00:11:00+02:00",
                "ExpectedArrivalTime": "2015-07-24T00:11:00+02:00"
            },
            "OperatorRef": null,
            "OriginAimedDepartureTime": "0001-01-01T00:00:00",
            "Delay": null,
            "DestinationRef": 0,
            "DestinationAimedArrivalTime": "0001-01-01T00:00:00",
            "PublishedLineName": "5",
            "Monitored": false,
            "TrainBlockPart": null,
            "VehicleMode": 4,
            "LineRef": "5",
            "FramedVehicleJourneyRef": null,
            "DirectionRef": null,
            "InCongestion": false,
            "DestinationName": "Vestli",
            "OriginName": null,
            "OriginRef": null,
            "VehicleFeatureRef": null,
            "VehicleRef": null,
            "BlockRef": null,
            "DirectionName": null,
            "VehicleJourneyName": "59484"
        },
        "RecordedAtTime": "0001-01-01T00:00:00"
    },
    {
        "Extensions": {
            "IsHub": false,
            "LineColour": "F07800",
            "OccupancyData": {
                "OccupancyAvailable": false,
                "OccupancyPercentage": 0
            },
            "Deviations": [
                {
                    "Header": "T-bane 5: Endret morgenavgang fra 21. juni",
                    "ID": 31505
                }
            ]
        },
        "MonitoringRef": "3012430",
        "MonitoredVehicleJourney": {
            "MonitoredCall": {
                "VisitNumber": 0,
                "DestinationDisplay": "\u00d8ster\u00e5s",
                "VehicleAtStop": false,
                "AimedDepartureTime": "2015-07-24T00:18:00+02:00",
                "DeparturePlatformName": "2 (Retning \u00d8ster\u00e5s)",
                "AimedArrivalTime": "2015-07-24T00:18:00+02:00",
                "ExpectedDepartureTime": "2015-07-24T00:18:00+02:00",
                "ExpectedArrivalTime": "2015-07-24T00:18:00+02:00"
            },
            "OperatorRef": null,
            "OriginAimedDepartureTime": "0001-01-01T00:00:00",
            "Delay": null,
            "DestinationRef": 0,
            "DestinationAimedArrivalTime": "0001-01-01T00:00:00",
            "PublishedLineName": "5",
            "Monitored": false,
            "TrainBlockPart": null,
            "VehicleMode": 4,
            "LineRef": "5",
            "FramedVehicleJourneyRef": null,
            "DirectionRef": null,
            "InCongestion": false,
            "DestinationName": "\u00d8ster\u00e5s",
            "OriginName": null,
            "OriginRef": null,
            "VehicleFeatureRef": null,
            "VehicleRef": null,
            "BlockRef": null,
            "DirectionName": null,
            "VehicleJourneyName": "58836"
        },
        "RecordedAtTime": "0001-01-01T00:00:00"
    },
    {
        "Extensions": {
            "IsHub": false,
            "LineColour": "F07800",
            "OccupancyData": {
                "OccupancyAvailable": false,
                "OccupancyPercentage": 0
            },
            "Deviations": [
                {
                    "Header": "T-bane 5: Endret morgenavgang fra 21. juni",
                    "ID": 31505
                }
            ]
        },
        "MonitoringRef": "3012430",
        "MonitoredVehicleJourney": {
            "MonitoredCall": {
                "VisitNumber": 0,
                "DestinationDisplay": "Ryen",
                "VehicleAtStop": false,
                "AimedDepartureTime": "2015-07-24T00:41:00+02:00",
                "DeparturePlatformName": "1 (Retning sentrum)",
                "AimedArrivalTime": "2015-07-24T00:41:00+02:00",
                "ExpectedDepartureTime": "2015-07-24T00:41:00+02:00",
                "ExpectedArrivalTime": "2015-07-24T00:41:00+02:00"
            },
            "OperatorRef": null,
            "OriginAimedDepartureTime": "0001-01-01T00:00:00",
            "Delay": null,
            "DestinationRef": 0,
            "DestinationAimedArrivalTime": "0001-01-01T00:00:00",
            "PublishedLineName": "5",
            "Monitored": false,
            "TrainBlockPart": null,
            "VehicleMode": 4,
            "LineRef": "5",
            "FramedVehicleJourneyRef": null,
            "DirectionRef": null,
            "InCongestion": false,
            "DestinationName": "Ryen",
            "OriginName": null,
            "OriginRef": null,
            "VehicleFeatureRef": null,
            "VehicleRef": null,
            "BlockRef": null,
            "DirectionName": null,
            "VehicleJourneyName": "60323"
        },
        "RecordedAtTime": "0001-01-01T00:00:00"
    },
    {
        "Extensions": {
            "IsHub": false,
            "LineColour": "F07800",
            "OccupancyData": {
                "OccupancyAvailable": false,
                "OccupancyPercentage": 0
            },
            "Deviations": [
                {
                    "Header": "T-bane 5: Endret morgenavgang fra 21. juni",
                    "ID": 31505
                }
            ]
        },
        "MonitoringRef": "3012430",
        "MonitoredVehicleJourney": {
            "MonitoredCall": {
                "VisitNumber": 0,
                "DestinationDisplay": "\u00d8ster\u00e5s",
                "VehicleAtStop": false,
                "AimedDepartureTime": "2015-07-24T00:48:00+02:00",
                "DeparturePlatformName": "2 (Retning \u00d8ster\u00e5s)",
                "AimedArrivalTime": "2015-07-24T00:48:00+02:00",
                "ExpectedDepartureTime": "2015-07-24T00:48:00+02:00",
                "ExpectedArrivalTime": "2015-07-24T00:48:00+02:00"
            },
            "OperatorRef": null,
            "OriginAimedDepartureTime": "0001-01-01T00:00:00",
            "Delay": null,
            "DestinationRef": 0,
            "DestinationAimedArrivalTime": "0001-01-01T00:00:00",
            "PublishedLineName": "5",
            "Monitored": false,
            "TrainBlockPart": null,
            "VehicleMode": 4,
            "LineRef": "5",
            "FramedVehicleJourneyRef": null,
            "DirectionRef": null,
            "InCongestion": false,
            "DestinationName": "\u00d8ster\u00e5s",
            "OriginName": null,
            "OriginRef": null,
            "VehicleFeatureRef": null,
            "VehicleRef": null,
            "BlockRef": null,
            "DirectionName": null,
            "VehicleJourneyName": "58835"
        },
        "RecordedAtTime": "0001-01-01T00:00:00"
    },
    {
        "Extensions": {
            "IsHub": false,
            "LineColour": "F07800",
            "OccupancyData": {
                "OccupancyAvailable": false,
                "OccupancyPercentage": 0
            },
            "Deviations": [
                {
                    "Header": "T-bane 5: Endret morgenavgang fra 21. juni",
                    "ID": 31505
                }
            ]
        },
        "MonitoringRef": "3012430",
        "MonitoredVehicleJourney": {
            "MonitoredCall": {
                "VisitNumber": 0,
                "DestinationDisplay": "Majorstuen",
                "VehicleAtStop": false,
                "AimedDepartureTime": "2015-07-24T01:11:00+02:00",
                "DeparturePlatformName": "1 (Retning sentrum)",
                "AimedArrivalTime": "2015-07-24T01:11:00+02:00",
                "ExpectedDepartureTime": "2015-07-24T01:11:00+02:00",
                "ExpectedArrivalTime": "2015-07-24T01:11:00+02:00"
            },
            "OperatorRef": null,
            "OriginAimedDepartureTime": "0001-01-01T00:00:00",
            "Delay": null,
            "DestinationRef": 0,
            "DestinationAimedArrivalTime": "0001-01-01T00:00:00",
            "PublishedLineName": "5",
            "Monitored": false,
            "TrainBlockPart": null,
            "VehicleMode": 4,
            "LineRef": "5",
            "FramedVehicleJourneyRef": null,
            "DirectionRef": null,
            "InCongestion": false,
            "DestinationName": "Majorstuen",
            "OriginName": null,
            "OriginRef": null,
            "VehicleFeatureRef": null,
            "VehicleRef": null,
            "BlockRef": null,
            "DirectionName": null,
            "VehicleJourneyName": "60391"
        },
        "RecordedAtTime": "0001-01-01T00:00:00"
    }
]

Jay (Indigo Support)
Twitter | Facebook | LinkedIn

Posted on
Thu Jul 23, 2015 2:49 pm
FlyingDiver offline
User avatar
Posts: 7222
Joined: Jun 07, 2014
Location: Southwest Florida, USA

Re: Help with SimpleJSON

I just grabbed that JSON and reformatted it so it's readable. I find it's much easier to figure out how to get the parts I want when I do that. Turns out that response is actually an array of dictionaries. So you need to figure out which one you want. Or iterate through them. That "Header" field is referenced as:

Code: Select all
parsed_json[i]["Extensions"]["Deviations"][0]["Header"]


Where 'i' is the record in the array for the route or departure you want. There were 10 records in the response when I just tried it.

This is just one record.

joe

Code: Select all
[
   {
      "RecordedAtTime":"2015-07-23T22:37:25.216+02:00",
      "MonitoringRef":"3012430",
      "MonitoredVehicleJourney":{
         "LineRef":"5",
         "DirectionRef":"1",
         "FramedVehicleJourneyRef":{
            "DataFrameRef":"2015-07-23",
            "DatedVehicleJourneyRef":"1515"
         },
         "PublishedLineName":"5",
         "DirectionName":"1",
         "OperatorRef":"me",
         "OriginName":"ØSÅ2",
         "OriginRef":"2190090",
         "DestinationRef":3011730,
         "DestinationName":"Vestli",
         "OriginAimedDepartureTime":"0001-01-01T00:00:00",
         "DestinationAimedArrivalTime":"0001-01-01T00:00:00",
         "Monitored":true,
         "InCongestion":false,
         "Delay":"PT50S",
         "TrainBlockPart":{
            "NumberOfBlockParts":6
         },
         "BlockRef":"504:4S15H02",
         "VehicleRef":"68",
         "VehicleMode":4,
         "VehicleJourneyName":"59491",
         "MonitoredCall":{
            "VisitNumber":6,
            "VehicleAtStop":true,
            "DestinationDisplay":"Vestli",
            "AimedArrivalTime":"2015-07-23T22:40:57+02:00",
            "ExpectedArrivalTime":"2015-07-23T22:41:47+02:00",
            "AimedDepartureTime":"2015-07-23T22:40:57+02:00",
            "ExpectedDepartureTime":"2015-07-23T22:41:47+02:00",
            "DeparturePlatformName":"1 (Retning sentrum)"
         },
         "VehicleFeatureRef":""
      },
      "Extensions":{
         "IsHub":false,
         "OccupancyData":{
            "OccupancyAvailable":false,
            "OccupancyPercentage":0
         },
         "Deviations":[
            {
               "ID":31505,
               "Header":"T-bane 5: Endret morgenavgang fra 21. juni"
            }
         ],
         "LineColour":"F07800"
      }
   },
   {
      More of the same
   }
]
Last edited by FlyingDiver on Thu Jul 23, 2015 2:51 pm, edited 1 time in total.

joe (aka FlyingDiver)
my plugins: http://forums.indigodomo.com/viewforum.php?f=177

Posted on
Thu Jul 23, 2015 2:50 pm
FlyingDiver offline
User avatar
Posts: 7222
Joined: Jun 07, 2014
Location: Southwest Florida, USA

Re: Help with SimpleJSON

Jay's faster than me. ;)

joe (aka FlyingDiver)
my plugins: http://forums.indigodomo.com/viewforum.php?f=177

Posted on
Thu Jul 23, 2015 4:24 pm
steinis offline
Posts: 80
Joined: Jul 17, 2015
Location: Oslo, NORWAY

Re: Help with SimpleJSON

Two fast answers, now I understand a little more how this work:)

I will look more into what I need to show and make a replay here later.

Thanks again!

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 5 guests