|
Home > Archive > BizTalk Server Orchestration > August 2005 > BizTalk consuming Web services with simple types that return a dat
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
BizTalk consuming Web services with simple types that return a dat
|
|
|
| I hope this is a dumb question.
I wish to consume a web service from BizTalk. I have created a ASP.Net web
service that pass parameters to a SQL server stored procedure and return the
resulting rows. None of the parameters or output use complex types. BizTalk
happily reads the wsdl of the web service, creates message types and port
types as it should. No complex types so BizTalk has not created a
reference.xsd . I can easily assign the elements of an incoming message
schema to the elements of the web service message type for the request.
The issue is the response web message type only has the dataset to assign
to, no elements.
I have used XML spy to extract the request and response xml's from the web
service and the schema information is definitely available.
Do I have to use an xpath reference in the assignment?
Is changing the web service to use complex types the only way?
--
Cheers, Fordy
| |
|
|
Fordy,
"response web message type only has the dataset to assign to, no elements"
-that confuses me, but here is a suggestion anyway:
If I understand you, you can set your output message (for the web service)
to xmlDocument. Take your resulting SQL xml and assign it to the output
(xDoc) message for the web service.
BA
"Fordy" <Fordy@discussions.microsoft.com> wrote in message
news:9A797078-96BB-40C8-A81B-6F9F19D2F9FE@microsoft.com...
> I hope this is a dumb question.
>
> I wish to consume a web service from BizTalk. I have created a ASP.Net web
> service that pass parameters to a SQL server stored procedure and return
the
> resulting rows. None of the parameters or output use complex types.
BizTalk
> happily reads the wsdl of the web service, creates message types and port
> types as it should. No complex types so BizTalk has not created a
> reference.xsd . I can easily assign the elements of an incoming message
> schema to the elements of the web service message type for the request.
>
> The issue is the response web message type only has the dataset to assign
> to, no elements.
> I have used XML spy to extract the request and response xml's from the web
> service and the schema information is definitely available.
> Do I have to use an xpath reference in the assignment?
> Is changing the web service to use complex types the only way?
>
>
> --
> Cheers, Fordy
| |
| Marvin Smit 2005-08-19, 7:53 am |
| Hi,
">Is changing the web service to use complex types the only way?"
No, but it is definitily preferred over using Datasets. This boils
back down to "interop" design. A dataset is .Net specific, Java-Axis
knows nothing of these.
Biztalk takes the 'interop' approach.
Therefore it is advisable to expose only 'interoperable' instances
from a WebService.
Hope this helps,
Marvin Smit.
On Tue, 16 Aug 2005 20:46:23 -0700, "Fordy"
<Fordy@discussions.microsoft.com> wrote:
>I hope this is a dumb question.
>
>I wish to consume a web service from BizTalk. I have created a ASP.Net web
>service that pass parameters to a SQL server stored procedure and return the
>resulting rows. None of the parameters or output use complex types. BizTalk
>happily reads the wsdl of the web service, creates message types and port
>types as it should. No complex types so BizTalk has not created a
>reference.xsd . I can easily assign the elements of an incoming message
>schema to the elements of the web service message type for the request.
>
>The issue is the response web message type only has the dataset to assign
>to, no elements.
>I have used XML spy to extract the request and response xml's from the web
>service and the schema information is definitely available.
>Do I have to use an xpath reference in the assignment?
>Is changing the web service to use complex types the only way?
|
|
|
|
|