Power Query - API Call from Web

[Sharism]

Hi,

I am trying to get the minimum prices from winesearcher with an API call in power query.

Here is the code:

Xml.Tables(Web.Contents(

"https://api.wine-searcher.com/x?api_key=????????

&winename=[Weingut] [Weinname]

&vintage=[Jahrgang]

&location=Europe

&currencycode=EUR

&bottle_size=b

"))

However, I get the follow error when I expand the columns:

The vintage is in the second column and it should work with that.
When I change the url into a specific value, e.g. winename=Petrus and vintage=2001 it works.

Any help is appreciated.

 

[Sharism]

Anyone has an idea?