Refresh on Report server with Web/JSON connection using REST and api token

[RoxyCT]

Hi All, 

I am using a JSON web connection to bring in REST api data from Pipedrive, this works well on the desktop app but when I publish to the Report server the connection string only reflects the first part of the URL and not the parameters or token that I am using.

Full URL:

https://XXXX.pipedrive.com/v1/deals?limit=2000&status=all_not_deleted&start=0&api_token=XXXXXXX

Is there any way to get around this to allow for scheduled refreshes on the Report server?

Thanks!