SSRS report - XML Query example

Question

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

Thanks

Answer 1

Hi @Zolotoy ,

You may refer the below links for help.

http://blog.newslacker.net/2013/04/ssrs-how-to-use-web-service-as-data.html

https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2005/administrator/aa964129(v=sql.90)?redirectedfrom=MSDN

https://learn.microsoft.com/en-us/sql/reporting-services/report-data/xml-query-syntax-for-xml-report-data-ssrs?view=sql-server-ver15

https://www.mssqltips.com/sqlservertip/3148/sql-server-reporting-services-xml-data-source-and-data-set/

Regards，
Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

What can I do if my transaction log is full?--- Hot issues November

How to convert Profiler trace into a SQL Server table -- Hot issues November

Answer 2

Additional see XML Query Syntax for XML Report Data (SSRS)

Answer 3

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

Answer 4

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

Answer 5

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