Running reports with powershell api

  • 1
  • Problem
  • Updated 10 months ago
I've been tasked with getting a weekly report for one of the partners in our firm.  His request is simple, he wants a report of any upload activity that occurs in his specific folder in Sharefile.

I just started mucking around with it; and I so far got it to create a report job with no issues:

$report = '{
"Title": "JJ's Report",
"ReportType": "Activity",
"ActivityTypes": "Upload",
"ObjectType": "Folder",
"ObjectId": "guid-info",
"DateOption": "ThisWeek",
"IncludeSubFolders": "true",
"SaveFormat": "Excel"
}'


Send-SfRequest -Client $sfclient -Method POST -Entity Reports -Bodytext $report -Parameters @{"runOnCreate" = "false"}

It returns with a bunch of information, which is a win for me.  But then I go to run the report:

Send-SfRequest -Client $sfclient -Method POST -uri "https://account.sf-api.com/sf/v3/Reports(report-guid)/Run"

It just hangs.  No errors. no nothing.

Photo of Renato Dattilo

Renato Dattilo

  • 32 Posts
  • 6 Reply Likes

Posted 10 months ago

  • 1

Be the first to post a reply!