Bug in csv response of Traffic Volume API

I’m sending a query to the road_traffic_counts_hourly_permanent table requesting a csv back with a large number of columns back

  params: {
      format: 'csv',
      q: `
        SELECT
        hour_00,hour_01,hour_02,hour_03,hour_04,hour_05,hour_06,hour_07,hour_08,hour_09,hour_10
        FROM road_traffic_counts_station_reference REF
      JOIN road_traffic_counts_hourly_permanent SUMM ON REF.STATION_KEY=SUMM.STATION_KEY
      WHERE YEAR='2019'
        AND STATION_ID='33023'
        AND DAY_OF_WEEK IN ('1', '2', '3', '4', '5')
         `
  }

If you request more than 10 columns in my SELECT then the ordering of the columns in the CSV goes whacky. For example the response to the above is

hour_05,	hour_00,	hour_02,	hour_03,	hour_04,	hour_01,	hour_06,	hour_07,	hour_08,	hour_09,	hour_10

Notice that hour_05 is the first column.

If I request 1 fewer columns then it works fine.

All the data appears however it’s just kind of annoying :slight_smile:

Thanks,
Rowan

© Transport for NSW