Forum Discussion
What type of API is that? REST / SOAP?
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?
- ChrisAdams4 years agoChampion Level 3
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_184 years agoNew Contributor
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.- ChrisAdams4 years agoChampion Level 3
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.
Related Content
- 2 years ago
Recent Discussions
- 13 hours ago
- 15 hours ago