Working with Web APIs in Microsoft Power Automate (MS Flow)
API is typically developers’ area of expertise, but Power Automate has made REST are Web API development so easy that now even non-developers can build REST APIs using Power Automate. At the same time consuming REST APIs developed by other third parties from inside Power Automate flow is also a simple task that does not require you to be a developer to achieve it.
This course is targeted to non-developers. You don’t need any software development or coding background and the very basic Web API fundamentals are covered in this course.
We also use Postman to call API’s that we build in this course and we also see how we can consume REST APIs that are build from third parties. This will significantly expand your flow functionality.
Follow the chapters slowly, do all the exercises and follow along the demos. More than anything focus more on understanding the concepts than just doing things and concepts are simplified to a level that non-developers can easily understand it. Regardless, I am there to answer the questions. So when in doubt, just add your question to QA section under the lecture.
This course requires your basic understanding on Power Automate flows like triggers and actions.
Best of luck and I really appreciate your feedback on the course once you finish it.
Understanding Web APIs
Creating web APIs using Microsoft Power Automate
Consuming web APIs using Microsoft Power Automate
-
11
Create your first web API using Microsoft Power Automate -
12
Let’s create a proper GET method
-
13
Let’s create a more complicated GET method
It is time to create a web API that accepts parameter and returns data in response body.
-
14
Creating a POST method using Power Automate
In this lecture you learn how to create a POST method API call that inserts a record into back-end system (SharePoint online in this case)
-
15
Creating PATCH method using Power Automate
-
16
Errors and exceptions in web API and Power Automate
In this lecture we see the possibilities and limitations of web API exception handling with Power Automate.
-
17
Implementing error handling in REST APIs
In this lecture we actually implement the exception handling in REST APIs
-
18
Summary and next steps
Real life examples of web API and Power Automate
-
19
When and where do we make call web APIs from Power Automate
This is a quick discussion on the right scenarios of calling web APIs from Power Automate.
-
20
Finding and testing a sample REST API to consume
In this video we review JSONPlaceholder available REST APIs for our training. We also try a few calls from that server using Postman.
-
21
Hands-on calling web API using Microsoft Power Automate
-
22
Analyzing and parsing JSON results
-
23
Parsing API results with multiple items
In this lecture, we see how JSON parse reacts to a multi item JSON schema
-
24
Filter and Select
In this lecture we learn about query tools that are available in Power Automate to filter web API return values
-
25
Status code and Queries in HTTP Action
A quick review on Status Code and Queries parameter when using HTTP action
-
26
Postman vs HTTP Action
In this lecture we will see how to translate Postman settings to our HTTP action in Power Automate
-
27
Dealing with security when calling REST API from Power Automate
This lecture covers configuring security when calling secure web APIs using Power Automate.
-
28
Are you a developer? I need your opinion.
Although this course is not for developers, I am thinking of just one lecture for developers only. What do you think?
