We have the above requirement
Step by step instructions to call a web service using HTTP connector is availble in below link. You replace the RESTLet services with your SOAP call.
How to call a NetSuite RESTlet web service
Thanks All for this solution But We don't want NetSuite solution. Please any alternate solution for the same.
Calling a SOAP/XML web service with the http connector is very similar to calling a REST API. You will find many examples on this community on how to do that. Check out this link. Regarding oauth, I have documented an oauth 2.0 example in a blog, see How to integrate Exact Online using Oauth 2.0. Not SOAP/XML but the oauth 2.0 part is generic.
Retrieving data ...