Consuming REST TABLE API in SSRS

[Mark V1]

Hello,

I am exploring to get the data out of a Table and use SSRS to create some reports.

How can I get the authentication part of the API call working from SSRS?

Is it doable in SSRS?

Appreciate any tips!

Thanks,

[MattiasJonsson]

I don't know SSRS at all (assuming you're referring to SQL Server Reporting Services) - however, you can authenticate to a REST call by either

• passing BASIC credentials in the URL (https://username:password@instance.service-now.com) or
• passing an "Authorization" header with the username:password Base64 encoded and prefaced by the string "Basic".

So, for example - if my username and password were "Test" and "Test", you would pass a header

Authorization: Basic VGVzdDpUZXN0

https://www.base64encode.org/

If helpful or correct, please indicate so!

[Mark V1]

Thank you for the reply. Yes, it is SQL Server Reporting Services. It does not work with REST API.

I went with ServiceNow ODBC driver. I was able to make it work with ODBC as Data source.

It ODBC driver has it's own limitations though.

Thanks