I'm trying to utilize the Nimsoft REST API along with SSRS.
Say I make a call along the lines of:
It will prompt me for a user/pass which I can provide in any browser that works fine (returning an xml file)
I can even save that xml document and upload it manually to my report server and query off of it.
My problem arises when I make the same call as a datasource in SSRS (Report Builder to be exact)
I can provide the data source with credentials but I always get the 401 Unauthorized return
Can I somehow embed the user/pass in the URL? Or is there any other way of doing this?
Any help is much appreciated!