AirlineFlightSchedules Returning Flights Outside Query Dates


#1

Hi,

It was my understanding that this query should be returning flights which are due to depart between 1464991200 and 1464998399:


https://flightxml.flightaware.com/json/FlightXML2/AirlineFlightSchedules?startDate=1464991200&endDate=1464998399&offset=0&howMany=15&destination=EGLL

However, the results show flights which have a departuretime field outside of that timeframe, e.g. 1465006200. Is this a bug or have I missed something?

Thanks

Phil


{
  "AirlineFlightSchedulesResult": {
    "next_offset": 15,
    "data": 
      {
        "ident": "EIN8926",
        "actual_ident": "BAW226",
        "departuretime": 1465006200,
        "arrivaltime": 1465035600,
        "origin": "KATL",
        "destination": "EGLL",
        "aircrafttype": "",
        "meal_service": "",
        "seats_cabin_first": 14,
        "seats_cabin_business": 56,
        "seats_cabin_coach": 227
      },
      {
        "ident": "AAL6171",
        "actual_ident": "BAW226",
        "departuretime": 1465006200,
        "arrivaltime": 1465035600,
        "origin": "KATL",
        "destination": "EGLL",
        "aircrafttype": "",
        "meal_service": "First: Meal / Business: Meal / Economy: Meal",
        "seats_cabin_first": 14,
        "seats_cabin_business": 56,
        "seats_cabin_coach": 227
      },
      {
        "ident": "FIN5426",
        "actual_ident": "BAW226",
        "departuretime": 1465006200,
        "arrivaltime": 1465035600,
        "origin": "KATL",
        "destination": "EGLL",
        "aircrafttype": "",
        "meal_service": "First: Meal / Business: Meal / Economy: Meal",
        "seats_cabin_first": 14,
        "seats_cabin_business": 56,
        "seats_cabin_coach": 227
      },
      {
        "ident": "IBE4646",
        "actual_ident": "BAW226",
        "departuretime": 1465006200,
        "arrivaltime": 1465035600,
        "origin": "KATL",
        "destination": "EGLL",
        "aircrafttype": "",
        "meal_service": "",
        "seats_cabin_first": 14,
        "seats_cabin_business": 56,
        "seats_cabin_coach": 227
      },
      {
        "ident": "BAW226",
        "actual_ident": "",
        "departuretime": 1465006200,
        "arrivaltime": 1465035600,
        "origin": "KATL",
        "destination": "EGLL",
        "aircrafttype": "",
        "meal_service": "First: Meal / Business: Meal / Economy: Meal",
        "seats_cabin_first": 14,
        "seats_cabin_business": 56,
        "seats_cabin_coach": 227
      },
      {
        "ident": "EIN8902",
        "actual_ident": "BAW202",
        "departuretime": 1465008000,
        "arrivaltime": 1465031400,
        "origin": "KBOS",
        "destination": "EGLL",
        "aircrafttype": "B744",
        "meal_service": "",
        "seats_cabin_first": 14,
        "seats_cabin_business": 70,
        "seats_cabin_coach": 215
      },
      {
        "ident": "AAL6200",
        "actual_ident": "BAW202",
        "departuretime": 1465008000,
        "arrivaltime": 1465031400,
        "origin": "KBOS",
        "destination": "EGLL",
        "aircrafttype": "B744",
        "meal_service": "First: Meal / Business: Meal / Economy: Meal",
        "seats_cabin_first": 14,
        "seats_cabin_business": 70,
        "seats_cabin_coach": 215
      },
      {
        "ident": "FIN5502",
        "actual_ident": "BAW202",
        "departuretime": 1465008000,
        "arrivaltime": 1465031400,
        "origin": "KBOS",
        "destination": "EGLL",
        "aircrafttype": "B744",
        "meal_service": "First: Meal / Business: Meal / Economy: Meal",
        "seats_cabin_first": 14,
        "seats_cabin_business": 70,
        "seats_cabin_coach": 215
      },
      {
        "ident": "IBE4732",
        "actual_ident": "BAW202",
        "departuretime": 1465008000,
        "arrivaltime": 1465031400,
        "origin": "KBOS",
        "destination": "EGLL",
        "aircrafttype": "B744",
        "meal_service": "",
        "seats_cabin_first": 14,
        "seats_cabin_business": 70,
        "seats_cabin_coach": 215
      },
      {
        "ident": "BAW202",
        "actual_ident": "",
        "departuretime": 1465008000,
        "arrivaltime": 1465031400,
        "origin": "KBOS",
        "destination": "EGLL",
        "aircrafttype": "B744",
        "meal_service": "First: Meal / Business: Meal / Economy: Meal",
        "seats_cabin_first": 14,
        "seats_cabin_business": 70,
        "seats_cabin_coach": 215
      },
      {
        "ident": "THY8464",
        "actual_ident": "AVA120",
        "departuretime": 1465013040,
        "arrivaltime": 1465051500,
        "origin": "SKBO",
        "destination": "EGLL",
        "aircrafttype": "B788",
        "meal_service": "Economy: Dinner, Breakfast",
        "seats_cabin_first": 0,
        "seats_cabin_business": 0,
        "seats_cabin_coach": 250
      },
      {
        "ident": "ANA7840",
        "actual_ident": "AVA120",
        "departuretime": 1465013040,
        "arrivaltime": 1465051500,
        "origin": "SKBO",
        "destination": "EGLL",
        "aircrafttype": "B788",
        "meal_service": "Economy: Dinner, Breakfast",
        "seats_cabin_first": 0,
        "seats_cabin_business": 0,
        "seats_cabin_coach": 250
      },
      {
        "ident": "DLH9649",
        "actual_ident": "AVA120",
        "departuretime": 1465013040,
        "arrivaltime": 1465051500,
        "origin": "SKBO",
        "destination": "EGLL",
        "aircrafttype": "B788",
        "meal_service": "Economy: Dinner, Breakfast",
        "seats_cabin_first": 0,
        "seats_cabin_business": 0,
        "seats_cabin_coach": 250
      },
      {
        "ident": "ETD2600",
        "actual_ident": "AVA120",
        "departuretime": 1465013040,
        "arrivaltime": 1465051500,
        "origin": "SKBO",
        "destination": "EGLL",
        "aircrafttype": "B788",
        "meal_service": "",
        "seats_cabin_first": 0,
        "seats_cabin_business": 0,
        "seats_cabin_coach": 250
      },
      {
        "ident": "AVA120",
        "actual_ident": "AVA120",
        "departuretime": 1465013040,
        "arrivaltime": 1465051500,
        "origin": "SKBO",
        "destination": "EGLL",
        "aircrafttype": "A330",
        "meal_service": "Business: Dinner, Breakfast / Economy: Dinner, Breakfast",
        "seats_cabin_first": 0,
        "seats_cabin_business": 30,
        "seats_cabin_coach": 222
      }
    ]
  }
}


#2

The startdate and enddate arguments are best to be treated as simply whole day selectors, rather than precise times to the second. Your application should then be prepared to walk through the results returned and discard results that are outside of the precise time window you are looking for.


#3

Hi

i have same problem i passing below parameters as per your document .

$startDate = 1468490400 , [Date : 2016-07-14 10:00:00]
$endDate = 1468497600 , [Date : 2016-07-14 12:00:00]
$origin = “CYYZ”

But i can’t got the proper result from API , they given data OutSide of datetime instead of i given . I’m also passing datetime format UTC .

I received below result and that look wrong, I requested for time between 10-12, i received data for between 14-16 , 4 hours difference




Array
(
    [0] => Array
        ( 
            [ident] => ETH503
            [actual_ident] => 
            [departure_time] => 1468509600 **[Thu, 14 Jul 2016 15:20:00 UTC]**
            [arrival_time] => 1468556700 
            [origin] => CYYZ
            [destination] => HAAB
            [aircraft_type] => B788
            [meal_service] => Economy: Lunch, Dinner
            [seats_cabin_first] => 0
            [seats_cabin_business] => 0
            [seats_cabin_coach] => 250 
        )

    [1] => Array
        ( 
            [ident] => AMX5118
            [actual_ident] => ASQ5441
            [departure_time] => 1468505700  ** Thu, 14 Jul 2016 14:15:00 GMT ]**
            [arrival_time] => 1468513740
            [origin] => CYYZ
            [destination] => KATL
            [aircraft_type] => CRJ9
            [meal_service] => 
            [seats_cabin_first] => 0
            [seats_cabin_business] => 12
            [seats_cabin_coach] => 64 
        )

    [2] => Array
        ( 
            [ident] => DAL5441
            [actual_ident] => ASQ5441
            [departure_time] => 1468505700
            [arrival_time] => 1468513740
            [origin] => CYYZ
            [destination] => KATL
            [aircraft_type] => CRJ9
            [meal_service] => Business: Refreshments / Economy: Refreshments
            [seats_cabin_first] => 0
            [seats_cabin_business] => 12
            [seats_cabin_coach] => 64 
        )

    [3] => Array
        ( 
            [ident] => KLM7911
            [actual_ident] => ASQ5441
            [departure_time] => 1468505700
            [arrival_time] => 1468513740
            [origin] => CYYZ
            [destination] => KATL
            [aircraft_type] => CRJ9
            [meal_service] => Business: Refreshments / Economy: No meal
            [seats_cabin_first] => 0
            [seats_cabin_business] => 12
            [seats_cabin_coach] => 64 
        )

    [4] => Array
        ( 
            [ident] => WJA7185
            [actual_ident] => ASQ5441
            [departure_time] => 1468505700
            [arrival_time] => 1468513740
            [origin] => CYYZ
            [destination] => KATL
            [aircraft_type] => CRJ9
            [meal_service] => 
            [seats_cabin_first] => 0
            [seats_cabin_business] => 12
            [seats_cabin_coach] => 64 
        )

    [5] => Array
        ( 
            [ident] => WJA2710
            [actual_ident] => 
            [departure_time] => 1468505100
            [arrival_time] => 1468515060
            [origin] => CYYZ
            [destination] => TXKF
            [aircraft_type] => B737
            [meal_service] => 
            [seats_cabin_first] => 0
            [seats_cabin_business] => 0
            [seats_cabin_coach] => 136 
        )

    [6] => Array
        ( 
            [ident] => ACA358
            [actual_ident] => 
            [departure_time] => 1468505100
            [arrival_time] => 1468510740
            [origin] => CYYZ
            [destination] => KBOS
            [aircraft_type] => E190
            [meal_service] => Business: Continental Breakfast / Economy: No meal
            [seats_cabin_first] => 0
            [seats_cabin_business] => 9
            [seats_cabin_coach] => 88 
        )

    [7] => Array
        ( 
            [ident] => UAL8370
            [actual_ident] => ACA358
            [departure_time] => 1468505100
            [arrival_time] => 1468510740
            [origin] => CYYZ
            [destination] => KBOS
            [aircraft_type] => E190
            [meal_service] => Business: No meal / Economy: No meal
            [seats_cabin_first] => 0
            [seats_cabin_business] => 9
            [seats_cabin_coach] => 88 
        )

    [8] => Array
        ( 
            [ident] => WJA2582
            [actual_ident] => 
            [departure_time] => 1468506900
            [arrival_time] => 1468521180
            [origin] => CYYZ
            [destination] => MMUN
            [aircraft_type] => B737
            [meal_service] => 
            [seats_cabin_first] => 0
            [seats_cabin_business] => 0
            [seats_cabin_coach] => 136 
        )

    [9] => Array
        ( 
            [ident] => ACA7616
            [actual_ident] => SKV7616
            [departure_time] => 1468508100
            [arrival_time] => 1468512900
            [origin] => CYYZ
            [destination] => KDCA
            [aircraft_type] => E170
            [meal_service] => Business: Snack or brunch / Economy: No meal
            [seats_cabin_first] => 0
            [seats_cabin_business] => 9
            [seats_cabin_coach] => 64 
        )

    [10] => Array
        ( 
            [ident] => AAL2609
            [actual_ident] => 
            [departure_time] => 1468511640
            [arrival_time] => 1468523400
            [origin] => CYYZ
            [destination] => KDFW
            [aircraft_type] => A319
            [meal_service] => First: Lunch / Economy: Food for sale
            [seats_cabin_first] => 8
            [seats_cabin_business] => 0
            [seats_cabin_coach] => 120 
        )

    [11] => Array
        ( 
            [ident] => LAN8665
            [actual_ident] => AAL2609
            [departure_time] => 1468511640
            [arrival_time] => 1468523400
            [origin] => CYYZ
            [destination] => KDFW
            [aircraft_type] => A319
            [meal_service] => First: No meal / Economy: No meal
            [seats_cabin_first] => 8
            [seats_cabin_business] => 0
            [seats_cabin_coach] => 120 
        )

    [12] => Array
        ( 
            [ident] => WJA5020
            [actual_ident] => AAL2609
            [departure_time] => 1468511640
            [arrival_time] => 1468523400
            [origin] => CYYZ
            [destination] => KDFW
            [aircraft_type] => A319
            [meal_service] => 
            [seats_cabin_first] => 8
            [seats_cabin_business] => 0
            [seats_cabin_coach] => 120 
        )

    [13] => Array
        ( 
            [ident] => DAL6220
            [actual_ident] => GJS6220
            [departure_time] => 1468512000
            [arrival_time] => 1468516260
            [origin] => CYYZ
            [destination] => KDTW
            [aircraft_type] => CRJ9
            [meal_service] => 
            [seats_cabin_first] => 0
            [seats_cabin_business] => 12
            [seats_cabin_coach] => 64 
        )

    [14] => Array
        ( 
            [ident] => KLM8051
            [actual_ident] => GJS6220
            [departure_time] => 1468512000
            [arrival_time] => 1468516260
            [origin] => CYYZ
            [destination] => KDTW
            [aircraft_type] => CRJ9
            [meal_service] => 
            [seats_cabin_first] => 0
            [seats_cabin_business] => 12
            [seats_cabin_coach] => 64 
        )
)



#4

As I mentioned above, the startdate and enddate arguments are best to be treated as simply whole day selectors. The time portion (modulo 86400) is not considered.


#5

The startdate and enddate arguments are best to be treated as simply whole day selectors, rather than precise times to the second. Your application should then be prepared to walk through the results returned and discard results that are outside of the precise time window you are looking for.

As I mentioned above, the startdate and enddate arguments are best to be treated as simply whole day selectors. The time portion (modulo 86400) is not considered.

This is not only completely non-sensical behaviour, is not only completely undocumented, but also contradicts the API documentation that does exist. As a paying customer of your API, this is not good enough.

I want to get flights departing in a 24 hour window from midnight Sydney time. Why should I have to:

  • Pay for expensive flight results that aren’t relevant to the query parameters I provide.
  • Manually massage the results you give me to match the query parameters I provide.

This is incredibly frustrating.