REST API Calls in Power Automate - Beginners Tutorial

Video Description

This video tutorial shows how to do REST API Calls, also known as HTTP Requests, and interpret the response with JSON parsing. In the last advanced part, we'll do multiple REST API calls from an Excel sheet, write the results back to Excel, and error handling based on the status codes. 📂 Download the course materials: https://andersjensen.org/microsoft-power-automate/http-requests-rest-api/ VIDEOS FOR YOU: 🔹 Power Automate Beginners Course: https://youtube.com/playlist?list=PLXXz88_TPiHqGlJoWhBDCAxZ9m1N_jsB6 🔹 Power Automate BREAKING NEWS: https://youtu.be/U5ppA3J9qM4 POWER AUTOMATE GROUPS: 👨‍👩‍👧‍👦 Discord: https://discord.gg/iloveautomation - Join my network with 4300+ Automation/RPA developers, where we solve Automation/RPA problems, network, and help each other upgrade our careers. It's free! 👩🏻‍🎓 LinkedIn: https://www.linkedin.com/groups/12566435 👨🏻‍💻 Facebook: https://www.facebook.com/groups/754059285247921 FOLLOW ME: 💼 LinkedIn: https://www.linkedin.com/in/andersjensenorg 📸 Instagram: https://www.instagram.com/andersjensenorg 👨 Facebook: https://www.facebook.com/andersjensenorg 🐦 Twitter: https://twitter.com/andersjensenorg 💌 Email Newsletter: https://and ersjensen.org/email-newsletter 0:00 REST API Call A REST API Call, also known as HTTP Request, is like a Google search: You make a request and get a response back. The response is usually in JSON format. In Power Automate, we use an HTTP action. Provide a Method and a URL (the endpoint). 4:29 JSON Parsing With a Parse JSON action, we make it easy to refer to the response data from the REST API Call (HTTP Request). Provide a JSON schema. 7:52 Multiple REST API Calls at once The complete solution reads ID data from an Excel sheet, performs multiple REST API Calls, and writes the results back to Excel. Use a List rows present in a table action to read the Excel data. Then the Apply to each action to iterate through the Excel data. Finally, an Update a row action to write the results back. 13:58 Error-handling the API Responses Power Automate is exceptional in doing error handling. First, we'll create our error handling based on the Status codes from the API response. Then, use a Condition of a Switch on the Status code and perform the actions in the branches/cases. Remember to use the Configure run after setting in the Switch. #powerautomate #powerplatform #office365