Forum Discussion

t_18's avatar
t_18
New Contributor
4 years ago

Sending Multiple records in single soap request

Hello! Just started using soapui. I have created a soap webservice which contains only single insert statement. Earlier this service was working fine for inserting multiple records in a single soap ...
nmrao's avatar
nmrao
Champion Level 3
4 years ago
Like @ChrisAdam pointed, please check with service provider or your team if internally develop.

What type of API is that? REST / SOAP?
  • t_18's avatar
    t_18
    New Contributor
    4 years ago
    Hi ,
    Its a soap API. I am the service provider. We are testing the API in our environment to check whether multiple records can be inserted in single soap request.
    Also, there are no table constraints.

    Can you please suggest ways in which multiple rows can be inserted in staging table via a single soap request?
    • ChrisAdams's avatar
      ChrisAdams
      Champion Level 3
      4 years ago

      Hi,

      If your API request in SoapUI has several entries in it; you submit the request and one is inserted, then it's a back-end issue and not SoapUI.

       

      However, if your API is not receiving several entries, then something may be wrong.

       

      After you 'submit' from SoapUI, there will be a 'raw' tab, have a look in there.  It shows exactly what SoapUI sent to the API.

       

      We're lucky that you are the developer, because you should be able to log exactly what comes in.  If you see several entries, but only one persisted, then the API is at fault, and not SoapUI.

      Can you share what your payload looks like?

       

       

      • t_18's avatar
        t_18
        New Contributor
        4 years ago

        Hi Chris,

        I didn't mean to imply that SOAPUI is at fault. I just want a way where multiple/bulk records can be inserted in a single soap request. Can you please suggest?

         

        As suggested, I checked the raw tab(plus the SOA Log file). And from what I understand, multiple records are being read but not getting inserted at our db.
        As requested, PFA payload. In this, only the record with org_id 180 is getting inserted.