Automate CSV Report Export

Hello,

With the help of @Keiji Otsubo, I was able to get the url hack to work to download a report in CSV format per this thread: 

https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007X6C9ZSAV

The next step is I want to be able to automate this view PowerShell.  I know this would be all based on url hacks which could fail in the future, but in the meantime I want to try :)

I was able to use the Salesforce CLI to authenticate, so that's good. But looking at this: https://salesforce.stackexchange.com/questions/381515/retrieve-a-report-via-sfdx but as noted, this seems to be the report metadata, so I think this is a dead end right? 

Alternatively I tried to use the Invoke-WebRequest per a link like this: https://adamtheautomator.com/powershell-download-file/ but that ends up downloading an HTML file that starts with this: 

"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "

<html>

<head>

    <meta HTTP-EQUIV="PRAGMA" CONTENT="NO-CACHE">

<script src="/jslibrary/1699262264248/ui-sfdc-javascript-impl/SfdcCore.js"></script><script src="/jslibrary/1698336665248/sfdc/AuraAlohaFrameNavigator.js"></script>

<script>

function redirectOnLoad() {"

Instead of the actual CSV I get when going to that same url in a web browser that I put in the Invoke-WebRequest line.

Unfortunately I can't use the subscription and standard email route because I have exhausted the number of reports I can subscribe to as a user. 

Any thoughts on this? I feel like I'm actually pretty close!