API Report Types and excluding missing data

  • 84 Views
  • Last Post 29 June 2018
James_ posted this 26 June 2018

Hello,

On the swagger page (http://webtris.highwaysengland.co.uk/api/swagger/ui/index#!/Reports/Reports_Index)

It lists different types of reports:

Report Type Id (i.e Daily, Monthly, Annual)

How does one select the hourly version of the daily report through the API?

Additionally, is it possible to exclude missing data from the API so it doesn't return an empty row?

Thanks,

Order By: Standard | Newest | Votes
Shaun Ryan-Izzard posted this 27 June 2018

Hi James

 

The hourly data exists within the Daily Report of the API (after the "Hourly Aggregations" tags). This of course will need to be translated using a system or process that recognises JSON (there are several websites out there that explain this, depending on the software and method that best suits you).

 

I hope that helps

 

Shaun

James_ posted this 28 June 2018

Is this part of the

 

Unfortunately there is no documentation to ascertain to what values relate to what and given it takes an integer that leaves a lot of possibilities.

James_ posted this 28 June 2018

It would be good practice to include the list of integers and their description to the swagger otherwise users are left to trial and error without being able to pass all  the parameters that they need.

reportSubTypeID

Value   Description

0 | Standard Report (15 minute raw data)

1 | 15-minute Tabular Report

2 | Hourly Tabular Report

3+ Errors

 

 

 

James_ posted this 28 June 2018

Also, the question about returning non-null results appears unaddressed

Shaun Ryan-Izzard posted this 29 June 2018

I can certainly add a request for more detail of the nature of the data supplied via the API to the list of future developments for the WebTris platform (which includes the API). However, as you can appreciate, it is not Highways England policy to prescribe any specific method of interpret the data itself, as this would be something bespoke to the individual extracting the data. As I've no doubt your aware, the same data is available via the Map based WebTris portal. The API is supplied as a more "technical" route to the data for Data Scientists who seek to make the extraction of API data a part of a more automated process. 

Close