none
reading Web Service Responses RRS feed

  • Question

  • Hi

    I have a multiple entry Web Service which pulls data from DB and it is working fine.

    I have 2 markets 01782 and 99993 which pull of data like type;ratecenter etc.,

    I am able to read the values for 01782 correctly from the XML file but 99993 values though different never seem to appear in the Infopath Form.

    Please find the request and response below

    Request:

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:qadb="http://cable.comcast.com/webservices/qadb_service">
       <soapenv:Header/>
       <soapenv:Body>
          <qadb:getFTAMA>
             <!--Optional:-->
             <qadb:lcorp>
                <!--Zero or more repetitions:-->
                <qadb:string>01782</qadb:string>
                <qadb:string>99993</qadb:string>
             </qadb:lcorp>
         </qadb:getFTAMA>
       </soapenv:Body>
    </soapenv:Envelope>

    Response:

    <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
       <soap:Body>
          <getFTAMAResponse xmlns="http://cable.comcast.com/webservices/qadb_service">
             <getFTAMAResult>
                <FTAMAResponse>


     For 01782:

                   <Type>RES</Type>
                   <Level5>020</Level5>
                   <Rate_Center>FUCERCDP01</Rate_Center>
                   <Market_Type>FTA</Market_Type>
                </FTAMAResponse>
                <FTAMAResponse>
                   <Type>RES</Type>
                   <Level5>028</Level5>
                   <Rate_Center>DIMSCDVRICRC4</Rate_Center>
                   <Market_Type>FTA</Market_Type>
                </FTAMAResponse>
                <FTAMAResponse>
                   <Type>BUS</Type>
                   <Level5>020</Level5>
                   <Rate_Center>FUCERCDP01</Rate_Center>
                   <Market_Type>FTA</Market_Type>
                </FTAMAResponse>


    For 99993:

                <FTAMAResponse>
                   <Type>COM</Type>
                   <Level5>119</Level5>
                   <Rate_Center>P1CERBTS01</Rate_Center>
                   <Market_Type>MA</Market_Type>
                </FTAMAResponse>
                <FTAMAResponse>
                   <Type>RES</Type>
                   <Level5>101</Level5>
                   <Rate_Center>DSTPHLFAKE</Rate_Center>
                   <Market_Type>MA</Market_Type>
                </FTAMAResponse>
                <FTAMAResponse>
                   <Type>RES</Type>
                   <Level5>119</Level5>
                   <Rate_Center>P1CERCDP01</Rate_Center>
                   <Market_Type>MA</Market_Type>
                </FTAMAResponse>
                <FTAMAResponse>
                   <Type>IMM</Type>
                   <Level5>101</Level5>
                   <Rate_Center>DIMSMDUPHIRC3</Rate_Center>
                   <Market_Type>MA</Market_Type>
                </FTAMAResponse>
                <FTAMAResponse>
                   <Type>BUS</Type>
                   <Level5>127</Level5>
                   <Rate_Center>P1CERBTS01</Rate_Center>
                   <Market_Type>MA</Market_Type>
                </FTAMAResponse>
             </getFTAMAResult>
          </getFTAMAResponse>
       </soap:Body>
    </soap:Envelope>

    I am able to write results of 01782 into the form but not for 99993.

    Friday, June 10, 2011 6:57 PM

All replies

  • Hi,

    Could you please share us the xsn template and the Udcx file (if appliable)?   Also can you give us a better description of your enviornment?

    Where is the data connection you are attempting to connect to?
    What type of data connection is it?
    Are you able to retrieve data from this connection outside of the InfoPath form?
    What version of InfoPath are you running and what Service Pack level are you on?

    You may directly ping me at misun@microsoft.com

    Good day!

    Thanks


    Michael Sun [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Tuesday, June 14, 2011 1:45 AM
    Moderator
  • Hi,

    Thanks a lot for sending us the .saz file for further troubleshooting.   We have reviewed the Fiddler trace file and noticed that there are 2 different web calls made to the web service to request data from. The data is being returned correctly in the web service calls.  So the issue lies somewhere in the way InfoPath is accepting that data.  There is something either in your code, or the lack of code, that is causing this.

    In InfoPath, the controls that are on the forms are not programmatically accessible.  This means that if you have code written to update a certain field that is part of a repeating table, such as the form you have, then the fields within that control are not going to be accessible to program.  There are ways to do such thing, but you require specific coding and this would require some significant time to develop.

    So, either if the you has you own code that is not developed correctly, or if you need code written to accomplish what you want to do, you will need to open up a regular support case via the support methods so the case can be worked correctly.  There will be an additional amount of time, which is more than the amount of time allocated for Forum cases in order to really troubleshoot this issue further.

    Please visit the below link to see the various paid support options that are available to better meet your needs or call call (866) 834-8317 (support)
    http://support.microsoft.com/default.aspx?id=fh;en-us;offerprophone

    Good day!

    Thanks

     


    Michael Sun [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Friday, June 24, 2011 1:53 AM
    Moderator