Share via

SSRS Report - how to get data from webservice

Zolotoy 226 Reputation points
2021-01-22T15:26:11.263+00:00

Here is what I am trying to do:

Data source: http://localhost/methodname

dataset:
<Query>
<Method Name="methodname" Namespace="http://localhost" />
</Query>

Getting this:
59701-image.png

My data looks like this:
"<?xml version='1.0' encoding='UTF-8'?><note><to>Tove</to><from>Jani</from><heading>Reminder</heading><body>Dont forget me this weekend!</body></note>"

Please help.

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.
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,536 Reputation points
    2021-01-25T02:54:39.783+00:00

    Hi @Zolotoy ,

    The issue seems occur due to the missing SOAP Action in the query.

    You may need to add <SoapAction></SoapAction>. Here is a query example:

    <SoapAction>http://localhost/methodname</SoapAction>
    <Method Namespace=" http://localhost/" Name="methodname">

    For detailed steps, you can refer to:

    reporting-services-web-service-data.html

    ssrs-how-to-use-web-service-as-data.html

    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.
    Hot issues October

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.