Forum Discussion

dcsearle's avatar
dcsearle
New Contributor
3 years ago

XML Response to SQL

Hi,

I have a functional test routine which outputs the dump of our SOAP API calls to individual text files. Instead, we would like to write the response into a SQL column.

I've setup a Data Sink and can write values from each response into my SQL table however I can't seem to find a way of writing the raw response XML into a column.  Ideally I'd just have the <body> section but I can deal with having the whole thing and manipulating it after the fact.

Can anyone offer any advice?

Thanks,

Dave

  • Found that writing the #Response property from the SOAP request into the data sink property did the job...

     

     

     

  • dcsearle's avatar
    dcsearle
    New Contributor

    Found that writing the #Response property from the SOAP request into the data sink property did the job...