Need developer to implement a website api to excel

[TimtheYoutuber]

I am not a developer so I don't know what the best way to do this is.


Basically, I need someone to code or at least tell me how to implement an API that will allow me to pull data from a website automatically and have it update on excel.

The way I have done this before for bitcoins price on coinmarketcap is by going to DATA- Webpage.

However this API looks like it might be harder as it needs some code since it is a password protected webpage.



Here are the developer's notes from the site: https://www.samsara.com/api , look it over and if it is something you can get to automatically update on excel, then PM me.

[PrimeNumber7]

From the website API documentation:

Code:

https://api.samsara.com/<version>/<endpoint>?access_token={access_token}

You should be able to do this the same way as you pull information from CMC.

[TimtheYoutuber]

From the website API documentation:

Code:

https://api.samsara.com/<version>/<endpoint>?access_token={access_token}

You should be able to do this the same way as you pull information from CMC.

If all I have to do is take the {access_token} out and input the key information, then something is wrong because it gives me an error. I think I have to call some sort of endpoint which idk how to do that.

[PrimeNumber7]

What information are you trying to have input into an excel sheet?

[TimtheYoutuber]

What information are you trying to have input into an excel sheet?

The information that samsara collects, so if I could capture a web page that would be great. Samsara collects data on different assets like vehicles and so if I could get information on the assets mileage that would be great.


I see they have a bunch of different endpoints so I'm thinking I should do each of them, and then add them to excel and see what information it pulled.

[Initscri]

I'm a web developer w/ more than 10+ years experience. If you want, we can talk budgets and i can complete this for you.

I haven't looked at the API but if it's throwing you an error, you probably have to generate an access token w/ your API key.

[carter w]

Hello,
Greetings,

i am glad to assist you.

Please Reach to me at Email :- carter@cisinlabs.com
Or at skype :- live:carter_1594

Awaiting your Response

Very Best Regards
Carter W

[wellfare]

Hello,
I can handle this for you.
Reach me via
Telegram: widethoughts
or Discord: widthought #1798

Thanks