SSRS report - XML Query example

Zolotoy 191 Reputation points
2020-11-29T20:48:58.55+00:00

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

Thanks

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,248 questions
No comments
{count} votes

5 answers

Sort by: Most helpful
  1. Olaf Helper 27,296 Reputation points
    2020-11-30T09:10:57.35+00:00
  2. Zolotoy 191 Reputation points
    2020-11-30T14:29:26.22+00:00

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


  3. Zolotoy 191 Reputation points
    2020-12-01T15:33:18.267+00:00

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

  4. Zolotoy 191 Reputation points
    2021-01-20T23:18:29.717+00:00

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

    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?

    Thanks