How to Use List Generate to Make API calls in Power Query

Learn how to make API calls by using List.Generate in Power Query. This video takes you through what an API is, how to create series with List.Generate and how to shoot requests to the API until the database is empty.

WRITTEN BLOGPOST
gorilla.bi/power-query/list-generate-api-calls/

Master Functions and Syntax in M
powerquery.how/

ABOUT BI GORILLA
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.

SUPPORT MY CHANNEL
Any videos are made free of charge. You can support my channel by giving a donation through: paypal.me/rickmaurinus.

Website: gorilla.bi/

SUBSCRIBE TO MY CHANNEL
youtube.com/bigorilla?sub_confirmation=1

LET'S CONNECT
Blog: gorilla.bi/
Facebook: facebook.com/BIGorilla/
Twitter: twitter.com/rickmaurinus
LinkedIn: linkedin.com/in/rickmaurinus/

Thank you for your support!

CHAPTERS
00:00 Introduction
00:35 Explaining the PokeAPI
02:37 From Web for API Call
05:44 Create API Function
07:11 Understanding List.Generate
09:02 List.Generate with Record
11:50 Add API Function to List.Generate
15:39 Condition for Do While logic

MUSIC
Killing Time Kevin MacLeod (incompetech.com)
Licensed under Creative Commons: By Attribution 3.0 License
creativecommons.org/licenses/by/3.0/

#api #listgenerate #powerquery