set up API query with key

[Wikolin]

Hi All,

Im struggeling to set up connection to MarineTraffic. I have a key from MarineTracffic but im unable to get the source to work.

I have a request limit 1 pr hour. 

When i paste the link in Edge browser i get a expexted result. But not in Power Bi.

https://services.marinetraffic.com/api/expectedarrivals/"APIKEY"?v=3&msgtype=extended&protocol=xml&portid=NOAES&fromdate=2021-11-05%2012%3A00%3A00&todate=2021-11-06%2012%3A00%3A00)

This is what i have in the query:

let
Source = Xml.Document(Web.Contents("https://services.marinetraffic.com/api/expectedarrivals/"APIKEY"?v=3&msgtype=extended&protocol=xml&portid=NOAES&fromdate=2021-11-07%2012%3A00%3A00&todate=2021-11-08%2012%3A00%3A00)"))
in
Source

Any ideas?

[v-eqin-msft]

Hi @Wikolin ,

Any updates?

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @Wikolin ,

You may try:

Source = Xml.Document(Web.Contents("https://xxx&APIKey="))

Similar thread:

https://community.powerbi.com/t5/Power-Query/API-query-return-a-range-of-selection/m-p/1905051

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat]

Please try this instead with 2 sets of quotation marks

let
Source = Xml.Document(Web.Contents("https://services.marinetraffic.com/api/expectedarrivals/""APIKEY""?v=3&msgtype=extended&protocol=xml&portid=NOAES&fromdate=2021-11-07%2012%3A00%3A00&todate=2021-11-08%2012%3A00%3A00)"))
in
Source

Pat