dcsearle
3 years agoNew Contributor
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...