Hi there,
BACKGROUND: I'm building a set of reports that all acquire data via an anonymous web API - API calls to collect data from one system the company uses.
I've set up two simple dataflows - basically both contains a one row one column table with the username in one, the password in the other. I did this so that should this ever change in future I could easily make the change once at the dataflow level and that would update credentials for each of my reports.
My problem is that even though I can bring these dataflows in successfully each time for each report, they come in as a table with a single entry. How can I use that single attribute as part of the login credentials in the API call, and that will also work in the Service when I publish the report? I don't know how to convert the single value in my one row, one column dataflows into a variable so I can use it in the API call.
Any help really appreciated. Is this a sensible approach in general? Is there a better way of managing this that I haven't thought about?
We have Pro user license here.
