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.