Attributes to XML (not JSON)

johnmteabo — Thu, 16 Mar 2017 02:27:35 GMT

Im looking for a way to get attributes in an XML file instead of json. The current proccesor only does attributes to json.

Any ideas? Maybe using an execute script proccesor? Lua code?

Thank you!

Re: Attributes to XML (not JSON)

mburgess — Thu, 16 Mar 2017 06:38:36 GMT

Yes it is possible with ExecuteScript if nothing else. Try the following Groovy script in your ExecuteScript processor:

def flowFile = session.get()
if(!flowFile) return
class WriteCallback implements OutputStreamCallback {
  Map attrs
  WriteCallback(attributes) {
    attrs = attributes
  }
  void process(OutputStream outputStream) {
    outputStream.write('<root>\n'.bytes)
    attrs.each {k,v -> 
      outputStream.write("<property>\n\t<name>$k</name>\n\t<value>$v</value>\n".bytes)
    }
    outputStream.write('</root>'.bytes)
  }
}
def wb = new WriteCallback(flowFile.attributes)
flowFile = session.write(flowFile, wb)
flowFile = session.putAttribute(flowFile, org.apache.nifi.flowfile.attributes.CoreAttributes.MIME_TYPE.key(), 'application/xml')
session.transfer(flowFile, REL_SUCCESS)

This should pretty-print your attributes in a "properties-style" XML format. Of course you can edit the script to give you the schema you like.

Re: Attributes to XML (not JSON)

akp4tibco — Fri, 05 May 2017 21:40:39 GMT

I am looking for a way to convert DB Query reusult set to XML and XML to SQL and also JSON to XML. Is this doable?

question Re: Attributes to XML (not JSON) in Archives of Support Questions (Read Only)

Attributes to XML (not JSON)

Re: Attributes to XML (not JSON)

Re: Attributes to XML (not JSON)