Power Query API

My previous post on using Power Query to access API's looked at API's that required either basic or no authorization. This post looks at API's that implement OAuth authorization, and as an example I'll be connecting to PayPal. The following query/process works in both Excel and Power BI Desktop. What is OAuth? OAuth is a …

An Application Programming Interface (API) allows a program to retrieve data from a system. A 'program' could be something written in a language like Python or PHP, or a program could be your web browser or Excel (using Power Query). The 'system' is any repository of data, very often web based. So you might be …