GOV.UK API

[SV616]

Has anyone got Alteryx to pull data from https://coronavirus.data.gov.uk/details/download ?

I know the API has a limit of up to 5 metrics per call. I can run this fine in a browser but when trying to download via Alteryx it is being blocked due to exceeding that limit.

https://api.coronavirus.data.gov.uk/v2/data?areaType=nation&metric=hospitalCases&metric=newAdmission...

"detail":"You may only request a maximum number of 5 metrics per request. Current number of metrics in your query: 6 - please reduce the number of metrics and try again."

Metrics

Required. Select up to 5 metrics. Some metrics may not be available for your selected area type. Such metrics will still be included in the resulting document, but will not contain any data.

Records contain at least 4 additional metrics as follows: areaType, areaCode, areaName, date

It seems to be counting the 4 default metrics in the limit, meaning I can only run the API with 1 additional metric which just isn't workable. Does anyone have a solution to this?

[jrgo · Accepted solution]

@SV616 

Make change in your Download tool as shown below. When I ran with that option selected, all requests were successful. 

[SV616]

Many thanks, seems that in effect I was adding the payload twice hence the breaking limit.