5 Replies Latest reply on Jan 12, 2021 3:10 AM by Nico Heinze

    Need to Display multiple records in REST API webservice

    Heena Rajvanshi New Member

      Hello Team,

       

      We need to display multiple records for REST API webservice and callinng this webservice through java code.

      Please find below screenshot for the mapping and mapplet:

       

      Also attached verbose data log and flatfile which is connected to the same port of output.Kindly anyone guide me to resolve it .

       

       

       

        • 1. Re: Need to Display multiple records in REST API webservice
          Nico Heinze Guru

          As far as I can see, the output file contains three records.

          You did not indicate whether this number is correct, and you did not indicate what output you expect.

           

          Could you please provide a more complete example?

          For example, do you mean you want to split up each line (which consists of 18 fields) into 18 individual records?

           

          Please clarify.

           

          Thanks,

          Nico

          • 2. Re: Need to Display multiple records in REST API webservice
            Heena Rajvanshi New Member

            Hello Nico,

            You are correct. The output file contain 3 records and these 3 records should be display as a output of webservice but in current scenario it showed only one (i.e. first record only).Please find below screenshot for the current working result .Also find the data  current scenario and expected one.

             

            I hope it will helpful for you to analyze it in better way.

             

            Current result==>

            <n5:Envelope xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" xmlns:n3="http://www.w3.org/2003/05/soap-envelope" xmlns:n="http://www.informatica.com/wsdl/" xmlns:n5="http://schemas.xmlsoap.org/soap/envelope/" xmlns:n7="http://schemas.xmlsoap.org/wsdl/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

               <n5:Body>

                  <n:BVD_MATCH_RESULTResponse>

                     <n:BVD_MATCH_RESULTResponseElement>

                        <n:BVD_REQUEST>INPUT PARAMETERS ::Company Name-&gt;BAUER TECHNICS S.R.O::Address-&gt;KOMENSKÉHO 1864::City-&gt;TÁBOR::Code Country-&gt;CZ::Postal code-&gt;390 02::Phone or Fax-&gt;::Email or Web-&gt;::National ID-&gt;25163442::State-&gt;</n:BVD_REQUEST>

                        <n:BVD_REPLY>Rowid_party-&gt;|EUROPEAN_VAT_NUMBER-&gt;CZ25163442|BRANCH_INDICATOR-&gt;false|BVD ID-&gt;CZ25163442|Score-&gt;1|Hint-&gt;Selected|Company Name-&gt;BAUER TECHNICS, S.R.O.|Address-&gt;KOMENSKEHO 1864|PostalCode-&gt;39002|City-&gt;TABOR|Country-&gt;CZ|AddressType-&gt;Priority address: Post(al) address|PhoneOrFax-&gt;+420 381 251 083|EmailOrWeb-&gt;www.bauer-technics.com|NationalID-&gt;25163442|Ticker-&gt;|ISIN-&gt;|State-&gt;null</n:BVD_REPLY>

                     </n:BVD_MATCH_RESULTResponseElement>

                  </n:BVD_MATCH_RESULTResponse>

               </n5:Body>

            </n5:Envelope>

             

             

            Excepted result==>

            <n5:Envelope xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" xmlns:n3="http://www.w3.org/2003/05/soap-envelope" xmlns:n="http://www.informatica.com/wsdl/" xmlns:n5="http://schemas.xmlsoap.org/soap/envelope/" xmlns:n7="http://schemas.xmlsoap.org/wsdl/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

               <n5:Body>

                  <n:BVD_MATCH_RESULTResponse>

                     <n:BVD_MATCH_RESULTResponseElement>

                      <n:BVD_REQUEST>INPUT PARAMETERS ::Company Name-&gt;BAUER TECHNICS S.R.O::Address-&gt;KOMENSKÉHO 1864::City-&gt;TÁBOR::Code Country-&gt;CZ::Postal code-&gt;390 02::Phone or Fax-&gt;::Email or Web-&gt;::National ID-&gt;25163442::State-&gt;</n:BVD_REQUEST>

                        <n:BVD_REPLY>Rowid_party-&gt;246741|BVD ID-&gt;CZ25163442|Score-&gt;1|Hint-&gt;SelectedCandidate|Company Name-&gt;BAUER TECHNICS, S.R.O.|NameLocalAlbhabet-&gt;|Address-&gt;KOMENSKEHO 1864|PostalCode-&gt;39002|City-&gt;TABOR|Country-&gt;CZ|Region-&gt;South Bohemian Region , District of Tabor|AddressType-&gt;Priority address: Post(al) address|PhoneOrFax-&gt;+420 381 251 083|EmailOrWeb-&gt;www.bauer-technics.com|NationalID-&gt;25163442|Ticker-&gt;|ISIN-&gt;|State-&gt;|Status-&gt;Dissolved|BVD10-&gt;061712931****Rowid_party-&gt;246741|BVD ID-&gt;CZ07049510|Score-&gt;0.6|Hint-&gt;PotentialCandidate|Company Name-&gt;BAUER TECHNICS, S.R.O.|NameLocalAlbhabet-&gt;|Address-&gt;PODVINNY MLYN 2178/6|PostalCode-&gt;19000|City-&gt;PRAHA LIBEN (PRAHA 9)|Country-&gt;CZ|Region-&gt;Prague - capital of the CR , District of Prague 9|AddressType-&gt;Priority address: Registered address / Incorporation address / Legal address|PhoneOrFax-&gt;|EmailOrWeb-&gt;|NationalID-&gt;07049510|Ticker-&gt;|ISIN-&gt;|State-&gt;|Status-&gt;Active|BVD10-&gt;382664673****Rowid_party-&gt;246741|BVD ID-&gt;CZ25163442-B0001|Score-&gt;0.6|Hint-&gt;PotentialCandidate|Company Name-&gt;BAUER TECHNICS, S.R.O. (AREAL STADLEC - SKLAD)|NameLocalAlbhabet-&gt;|Address-&gt;12|PostalCode-&gt;39162|City-&gt;STADLEC|Country-&gt;CZ|Region-&gt;|AddressType-&gt;Priority address: Trading address|PhoneOrFax-&gt;|EmailOrWeb-&gt;|NationalID-&gt;|Ticker-&gt;|ISIN-&gt;|State-&gt;|Status-&gt;Inactive (no precision)|BVD10-&gt;174217642</n:BVD_REPLY>

                     </n:BVD_MATCH_RESULTResponseElement>

                  </n:BVD_MATCH_RESULTResponse>

               </n5:Body>

            </n5:Envelope>

             

            • 3. Re: Need to Display multiple records in REST API webservice
              Nico Heinze Guru

              To me that looks as if the WSDL does not list the actual content as a repeatable content. If this is correct, it would mean that the web service hub (in this case the Try-It application) would not consider the content as a repeating XML tag, hence the display of only one record being returned would be "correct".

               

              Please check your WSDL whether the actual content is defined with a MAXOCCURS of > 1.

               

              At least that's what I can see by now. I'm by no means a web services specialist.

               

              Regards,

              Nico

              • 4. Re: Need to Display multiple records in REST API webservice
                Heena Rajvanshi New Member

                Hello,

                 

                Can you help me how can I update WSDL tags ?

                • 5. Re: Need to Display multiple records in REST API webservice
                  Nico Heinze Guru

                  Anyone else, please? I'm really a WSDL rookie, to say at least.

                   

                  On the other hand, who gave you the WSDL for the web service? This person should be able to deliver a new updated WSDL file.

                   

                  Thanks,

                  Nico