XML Output Stage to a Webservice
Posted: Mon Jul 15, 2013 10:43 am
I'm looking for some help with the XML Output stage, so far I've just used the stage to write a file to the OS. So my job looks like this so far
So the input tab of the XML Stage I write my XPath expressions and everything is working great. So the next thing I want to do is instead of writing the file to the file system, I want to take that XML as a BLOB/CLOB/STRING and pass it into a webservice (or a database table, etc...) So my job now looks like
My web service just has one column, payload, which I will base64 encode my xml document that I want to upload.
Where I'm stuck is I don't know what the Output Columns on the XML Stage should be? Should my output columns be identical to my input columns? I would think that I would just have one output column which would be my entire finished xml doc, just as if it was going to be written to disk?
Code: Select all
{Database} -> {Transformer} -> {XML Output}
Code: Select all
{Database} -> {Transformer} -> {XML Output} -> {Transformer} -> {Web Service}
Where I'm stuck is I don't know what the Output Columns on the XML Stage should be? Should my output columns be identical to my input columns? I would think that I would just have one output column which would be my entire finished xml doc, just as if it was going to be written to disk?