SSRS report - XML Query example

Zolotoy 226 Reputation points

Can someone please provide an example of XML Query that would get data from a web service?


SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,832 questions
0 comments No comments
{count} votes

6 answers

Sort by: Most helpful
  1. Olaf Helper 41,571 Reputation points
    0 comments No comments

  2. Zolotoy 226 Reputation points

    Is it possible to do POST with data to an endpoint?

  3. Zolotoy 226 Reputation points

    Well, I know how to create a POST request. The question is how to make POST from a report.

    0 comments No comments

  4. Zolotoy 226 Reputation points

    Finally got to it. Here is my dataset:
    <Method Namespace="https://localhost:5001/" Name="runNodeScript">
    <Parameter Name="WebMethodParameter"></Parameter>
    <ElementPath IgnoreNamespaces="true">*</ElementPath>

    Here is the error I am getting running it in the builder:

    Invalid URI: The URI is empty.

    Failed to prepare web request for the specified URL. (rsXmlDataProviderError)

    Failed to prepare web request for the specified URL. (rsXmlDataProviderError)

    Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)

    An error has occurred during report processing. (rsProcessingAborted)

    Any help?


    0 comments No comments