Using API to download SMM reports into Google Sheets

I've been doing some testing and successfully using the API to get data from LSW/SMM into Google Sheets, using App Script.

Where I'm getting stuck, however, is downloading the an CSV report.

Has anyone managed to do this already?

I get this error:

Request failed for https://socialweb-analytics-emea.lcloud.com/api/public/reports/report/<rest of url> returned code 400. Truncated server response: <?xml version="1.0" encoding="UTF-8"?> <Error><Code>InvalidArgument</Code><Message>Only one auth mechanism allowed; only the X-Amz-Algorithm query ... (use muteHttpExceptions option to examine full response) (line 60, file "Code")

A Google search leads me to believe that the redirect from LSW, when getting the download url is causing the issue, but maybe someone has found a way around this?