I have created an API resource to access Microsoft SQL Server Reporting Server (SSRS), however Retool keeps adding a "=" where:
Http resource: https://ssrs.reports.aus
Additions: ReportServer?/BT/Fleet&MachineId={{value}}&rs:Command=Render&rs:Format=pdf
However this adds an "=" giving /BT/Fleet=&
https://ssrs.reports.aus/ReportServer?/BT/Fleet=&MachineId=1234&rs:Command=Render&rs:Format=pdf failed, reason: getaddrinfo ENOTFOUND ssrs.reports.aus
How can I stop this from occurring?
Hey @klautier ,
It looks like the data is being passed to the next app or page through query parameters, which is likely causing the = issue.
Since there’s no way to completely hide data in query parameters, I recommend removing them when navigating between apps or pages.
There’s no way to pass data in query parameters and also keep it hidden. You’ll need to remove the query parameters from the page or app you’re navigating to when switching between apps or pages.
As a solution, I used the SSRS API URL from Azure APIM, and then used a simple front-end URL for Retool.
