Forum Discussion

dcarlson's avatar
dcarlson
New Contributor
8 years ago

Format to XML in an Ultra Pipeline?

Has anyone been able to format multiple input fields into XML in a pipeline that will be executed via an Ultra task?

I attached a screenshot of my pipeline.
In the highlighted XML Format snap, if I clear the Root Element field (as required by the instructions for building an Ultra pipeline), I get an error when it runs; it appears it needs a root element in which to place my many input fields. However, when I add a Root Element of “DocumentRoot” to that snap… the pipeline fails when run by Ultra.

I conclude that we cannot format multiple inputs into XML when run via Ultra… but I’m hoping there is some other way to accomplish my goal.

My overall need is… I capture whatever (it can vary alot) JSON elements are input to me, store them in an XML field in our SQL Server database, to be retrieved/parsed later.

Thanks in advance - David.