@Prashant SharmaHere is a link to a script I wrote that pulls billing consumption data from a subscription you could use as a reference. It then writes that data to a Log Analytics Workspace. That data could be written someplace else using whatever method you need.
It requires the Azure Consumption PowerShell Module.
