Consuming a soap response and populate the data into custom table(automatically)

[shubham5957]

In the process of setting up an integration between a 3rd party database and ServiceNow.   They have provided a SOAP API to query their database.
I have used SOAP outbound message to pull specific data on demand and use it, but in this case, I'm looking to take the response and put it into a staging table   so that I can transform it into the custom table.

Does anyone have any suggestions for the following:

1. Where should the SOAP messages be called from?   I was thinking a scheduled job since it does not need to be on demand.

2. What method should I use to take the response and write that to a table?

3. Where should I store the response form the SOAP message so that I can run a transform against it and populate into my custom table?  

Thanks for your input.

[Ankur Bawiskar]

Hi Shubham,

Any specific reason to have 2 questions/threads for discussion for the same requirement.

you already have a thread for this discussion.

Parse the XML content received from webservice SOAP response

Regards

Ankur

[shubham5957]

I am not getting the desired result.. my query is... is it possible to call a web service using a schedule job? that will pull the data from the web service response and put it into the target table?

[Sachin Gavhane]

@shubham5957  Did you found any solu. I have the same requirement