Importing Data from Tom Tom WEBFLEET

---

MSB_gpc wrote:

Hello everyone,

 

I am trying to import data from Tom Tom WEBFLEET.connect. My goal is to retrieve data once a month to monitorize indicators related with vehicles displacements.

 

I was provided with an account name, username, password and an API Key, each of them are needed to authenticate the user.

 

It is easy to download data by making and HTTP request with the url:

https://csv.telematics.tomtom.com/extern?lang=es&account=[ACCOUNT]&username=[USERNAME]&password=[PASSWORD]&apikey=[APIKEY]&outputformat=csv&action=showTrips&useISO8601=true&range_pattern=ud&rangefrom_string=2016-09-01T00:00:00&rangeto_string=2016-09-30T23:59:59

 

But any idea how to connect with PowerBI?

I tried to do an import from web directly as seen below: 

Doing that, I can retrieve data but with anonymous credentials. Am I doing right? I am a newbie with Power BI and connecting to data.

I also tried to write the script in a blank query, specifying the option of Web.Contents function APIKeyName="apikey" but I was unable to pass username, account and password as URL Headers.

 

I would thank any help!

 

---

MSB_gpc

 

If you mean you put put the url in a web browser and download the csv file, you can simply try "Get-data"->"Other"->"Web"->"Basic", and put the link in URL field.