Using the Azure Pricing API to find VM pricing | using a Spreadsheet

In this video I would l show you how to query the Azure Pricing API and convert the output to JSON and then populate a spreadsheet. The goal is to automate the process of finding pricing information and consolidating that information in one place and utilizing the power of a spreadsheet to make decisions.
the code used in this video can be found here:
github.com/fdu...
Questions, comments, or suggestions are welcomed.

[@AnshumanSingh19]

Thanks, this is a very helpful use case !! can we build a similar script for all the resources at once, if not mainly DB's and Disks

[@victoroghifobibi4090]

Thank you. This is very helpful. How can we do same for Excel

[@freddydubon4619]

Hi, yes you can do it with Excel I just don't have a video on it yet. will work on it. thanks for watching

[@lokeshvasu8908]

How I can display the data in reactjs is not supporting the api

[@christopherquenneville]

This works well but doesn't show CPU and RAM, so unfortunatly pointless for me