Ask a Question

XML Response to SQL

SOLVED
dcsearle
New 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

1 REPLY 1
dcsearle
New Contributor

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

 

dcsearle_0-1659610562398.png

 

dcsearle_0-1659609822410.png

 

cancel
Showing results for 
Search instead for 
Did you mean: