Consume a web service that response a DataSet

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Consume a web service that response a DataSet

Viewing 1 reply thread
  • Author
    Posts
    • #18256

      Hi,

      I'm new to BizTalk, and the problem is:
      I have a Orchestration to consume a web service and it is working, but now i want to have the response of the web service. I try a simple way and i have a response.
      The web service returns a dataset.
      This is the response:

      <?xml version="1.0" encoding="utf-8" ?>
      <DataSet>
      <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
      <xs:element name="MSG">
      <xs:complexType>
       <xs:sequence>
        <xs:element name="MSGTYPE" type="xs:string" minOccurs="0" />
        <xs:element name="MSGID" type="xs:string" minOccurs="0" />
        <xs:element name="MSGORIGIN" type="xs:string" minOccurs="0" />
        <xs:element name="MSGDESTINATION" type="xs:string" minOccurs="0" />
        <xs:element name="MSGDATETIME" type="xs:string" minOccurs="0" />
        <xs:element name="DATA" type="xs:string" minOccurs="0" />
       <xs:element name="MSGRESPONSE" minOccurs="0" maxOccurs="unbounded">
       <xs:complexType>
       <xs:sequence>
        <xs:element name="MSGTYPERESPONSE" type="xs:string" minOccurs="0" />
        <xs:element name="IDRESPONSE" type="xs:string" minOccurs="0" />
        </xs:sequence>
        </xs:complexType>
        </xs:element>
        </xs:sequence>
        </xs:complexType>
        </xs:element>
       <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
       <xs:complexType>
       <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element ref="MSG" />
        </xs:choice>
        </xs:complexType>
        </xs:element>
        </xs:schema>
       <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
       <NewDataSet>
       <MSG diffgr:id="MSG1" msdata:rowOrder="0" diffgr:hasChanges="inserted" msdata:hiddenMSG_Id="0">
        <MSGTYPE>SUCCESS</MSGTYPE>
        <MSGID>279372</MSGID>
        <MSGORIGIN>MPHC_CRM</MSGORIGIN>
        <MSGDESTINATION>SONHO</MSGDESTINATION>
        <MSGDATETIME>20071023181640</MSGDATETIME>
        <DATA />
       <MSGRESPONSE diffgr:id="MSGRESPONSE1" msdata:rowOrder="0" diffgr:hasChanges="inserted" msdata:hiddenMSG_Id="0">
        <MSGTYPERESPONSE>OUT_INTERALERT</MSGTYPERESPONSE>
        <IDRESPONSE />
        </MSGRESPONSE>
        </MSG>
        </NewDataSet>
        </diffgr:diffgram>
        </DataSet>

       My Orchestration:

      Orchestration:

      Now i want to create two folders, one that save the Success messages, and other to save the error messages. I have a decide shape but i don't know how to access to the <MSGTYPE>SUCCESS</MSGTYPE> or <MSGTYPE>ERROR</MSGTYPE> to redirect the response to the folders.

      I'm using Visual Studio 2005 and Biztalk server 2006. If you need more information to solve the problem, please tell me.
      If some one know how to help, i appreciate.

    • #18280

      You can use a .net class library includs a methods can readthe dataset , and then you find what you want using pure C# code , and then send the response…

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.