Accessing APIs using Excel

What are APIs? and how to access a public API using Microsoft Excel
if you are a business looking for support with API's please reach out to me on [e-mail]
Follow me on LinkedIn: / sid-skills
#excel #microsoftexcel #api #apidevelopment #python #coding #softwareengineer #dataengineering #data 📧 [e-mail] for any business enquiries

[@fredigoettler8073]

clear, concise and to the point - very helpful tutorial. You should have a lot more subscribers

[@skillswithsid]

Thank you so much, I will keep trying :) hoping to grow the subscriber base in future

[@mkolassa]

Excellent Video. Clear and concise

[@skillswithsid]

Thank you! Do let me know if there is any other content you want me to cover in future

[@friodia]

Thank you very much!

[@chrisder1814]

hello in this video so you are integrating an API into Excel? do you also do this on Google sheet? I think the difference is that on Excel it's very simple since there is a function integrated into the Excel software but on Google sheet I have to download an extension? Or do I have to code in app script?

[@riskcatriax]

Ez video to follow

[@alfonsosundblad3275]

Great Video! Question: how could i put the user number in a cell and have it referenced in the query? for my use case it would be a date, since my coworkers wont use power queries they will need the value outside of it

[@cikimoo]

Excel load data from api every time we open the file or loaded old data when it create ?

[@skillswithsid]

Yes you will need to rerun the query each time. Excel won’t auto load. The only way you can schedule the API query is to use some DAX/M language code. But if you want to do that you are better off learning Python. We will cover using Python to schedule an API call in an upcoming video this April

[@cikimoo]

⁠@@skillswithsid yes i get it, Python in this case more powerful for handling API request , sure i will check for other video .. Thanks

[@alexisgonzales3745]

How can I input Google map or Bing map/ route API for calculating daily milage in Excel spreadsheet from address to address. I tried following using your video but Google doesn't show v2 documentation.. very new to this and get lost on the website as what is my next step? Can you do a video on inputting information from google maps in Excel?

[@patil_ji]

how to get private data with access token like we do in postman

[@skillswithsid]

So I don’t use Postman, but I believe the process is the same, you will need a API key to access your API, in PowerQuery there is a field where you need to provide this key, this will then enable you to generate data from a GET request.

[@harjitsandhu7375]

❤

[@MuhlisErtugrul]

Thanks!

[@NS-tp3vr]

How to access api with access token that needs to be refreshed?

[@skillswithsid]

I will cover API tokens later this week including Bearer tokens

[@NS-tp3vr]

@@skillswithsid Can we import data from api with access token needs to be refreshed?

[@riskcatriax]

Ez video to follow