To get the last day of the month, the following line is used: $LastDayOfTheMonth = ((Get-Date -Date “01-$Month-$Year” -Hour 0 -Minute 0 -Second 0).AddMonths(1).AddSeconds(-1)).Day Since I’m talking with an API, the main important command is the Invoke-WebRequest with a pipe to ConvertFrom-Json Several nice ‘techniques’ used in this script to get to the goal: This last step I’ve removed from the script that I share with you. In the end I can either mail these files or put them on a file share, so they can be imported by our energy monitoring system. All files that have already been generated don’t need their data to be downloaded again and overwritten, thus it skips this data once it’s downloaded. In the end I’d want all the info to be exported to CSV files containing 1 month of data and/or 1 year of data.

Next to that, I’d want daily values, but also values with a 15 minute interval. I only want to download the information if it’s up-to-date. I wrote this tool to be somewhat smart in what to download and what not. With me working in a company that works on energy savings, monitoring, consultancy etc, it’s a logical step for me to automate downloading the production of my panels, so my collueges at work can import this data in my energy monitoring portal at work and then they can do their magic calculations on them which results in me getting nice graphs of my solar enrgy production. It appeared that this monitoring portal also has an API to automate getting the energy data. I’ve got a nice solar panel setup on my roof, which uploads its data to the SolarEdge monitoring portal (this is the brand of inverter that I got).

Solaredge firmware download