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
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.

      • ChrisAdams's avatar
        ChrisAdams
        Champion Level 3
        4 years ago

        Hi,

         

        That looks like SoapUI has done its job and the backend needs some focus.

         

        In terms how to insert multiple records, then on the backend check the code is finding all entries in the request.  If so, then look at your insert statement.  Are you inserting bulk records or iterating over each entry in the request and doing a single insert?

         

        But, I do think anything beyond is out of scope for this forum.