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?
