Importing Data from Tom Tom WEBFLEET

[MSB_gpc]

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!

[Eric_Zhang]

---

@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.

[plawrence14]

Hi Eric,

Did you ever work out how to connect to the webfleet database?

Thanks

Paul

[MSB_gpc]

Hello Eric,

Thanks for your answer. I had already succeded in doing what you said but the problem is that my account personal information (username, password, api-key) is always visible in data source settings and if I wanted to share the file this would be an inconvenient.

Moreover, it would be interesting to repeat periodically the data collection with the same data source and changing only some url time parameters.

What is the difference between accessing to web content with anonymous credentials or web API/basic/organizational account?

[plawrence14]

Hi MSB_gpc,

Did you ever work out how to connect to the webfleet database?

Thanks

Paul