SSRS report - XML Query example

Zolotoy 221 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,790 questions
0 comments No comments
{count} votes

6 answers

Sort by: Most helpful
  1. Olaf Helper 40,656 Reputation points
    2020-11-30T09:10:57.35+00:00
    0 comments No comments

  2. Zolotoy 221 Reputation points
    2020-11-30T14:29:26.22+00:00

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


  3. Zolotoy 221 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.

    0 comments No comments

  4. Zolotoy 221 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

    0 comments No comments