Beginners Guide to APIs and Parse JSON in the Power Platform

Опубликовано: 25 Февраль 2025
на канале: Andrew Hess

1,184

In this video, we will walk through how to use Power Automate to make an API call to a Weather API, parse the JSON response, and extract key weather details like name, description, and location. While avoiding an apply to each loop. This is a great first step for understanding JSON and API calls in the Power Platform.

✅ Set up an HTTP action to make an API call
✅ Use the safe navigation operator (?) for null handling in your compose statements
✅ Parse JSON data for weather info
✅ Avoid Apply to Each actions.

Example Compose Statements:
✅ outputs('Parse_JSON')?['body']?['weather']?[0]?['main']
✅ outputs('Parse_JSON')?['body']?['weather']?[0]?['description']
✅ concat(outputs('Compose_First_Weather'),'-',outputs('Compose_First_Description'))

Chapter:
0:00 Introduction
0:30 What is an API in Power Platform
1:53 Weather API OpenWeatherMap
4:08 Creating a Power Automate
6:34 Methods of a REST Call
10:10 Get Weather by City Name
11:27 Parse JSON your API Call
14:40 Fx formula to get out of Apply to Each
20:08 Using the data in another Formula
23:50 Writing to a Data Source
25:55 Conclusion Final Tip