Nifi - Groovy Json Script define null attributes

Question

I have a Nifi Groovy Script. Assigns fields to nifi attributes but it define null if json values are empty. if json value is null I want to define attribute empty.

null attributes look like this ;

I want to like this ;

this is the script i use ;

import org.apache.commons.io.IOUtils
import java.nio.charset.*
def flowFile = session.get();
if (flowFile == null) {
    return;
}
def slurper = new groovy.json.JsonSlurper()
def attrs = [:] as Map<String,String>
session.read(flowFile,
    { inputStream ->
        def text = IOUtils.toString(inputStream, StandardCharsets.UTF_8)
        def obj = slurper.parseText(text)
        obj.each {k,v ->
           attrs[k] = v.toString()
        }
    } as InputStreamCallback)
flowFile = session.putAllAttributes(flowFile, attrs)
session.transfer(flowFile, REL_SUCCESS)

daggett · Accepted Answer · 2022-11-27 19:34:09Z

0

flowFile = session.putAllAttributes(flowFile, attrs.collectEntries{k,v->[k,v?:'']})

edited Nov 27, 2022 at 19:34

answered Nov 27, 2022 at 8:09

daggett

29k3 gold badges52 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

veganzombie Over a year ago

i got an error ; ExecuteGroovyScript[id=01841011-21f7-17f3-3f20-e267910070a8] groovy.lang.MissingMethodException: No signature of method: org.apache.nifi.processors.groovyx.flow.GroovyProcessSessionWrap.putAllAttributes() is applicable for argument types: (org.apache.nifi.processors.groovyx.flow.GroovySessionFile, ArrayList) values: [WRAP[StandardFlowFileRecord[uuid=0d722ced-0e23-4f0f-a8b4-0026fbadcb6c,claim=StandardContentClaim

veganzombie · Accepted Answer · 2022-11-27 21:59:32Z

0

This is i solved it ;

import org.apache.commons.io.IOUtils
import java.nio.charset.*
def flowFile = session.get();
if (flowFile == null) {
    return;
}
def slurper = new groovy.json.JsonSlurper()
def attrs = [:] as Map<String,String>
session.read(flowFile,
    { inputStream ->
        def text = IOUtils.toString(inputStream, StandardCharsets.UTF_8)
        def obj = slurper.parseText(text)
        obj.each {k,v ->

          if (v.toString()=="null")
          {
            attrs[k] = ''
          } else {
            attrs[k] = v.toString()
          }

        }
    } as InputStreamCallback)
flowFile = session.putAllAttributes(flowFile, attrs)
session.transfer(flowFile, REL_SUCCESS)

answered Nov 27, 2022 at 21:59

veganzombie

12910 bronze badges

Collectives™ on Stack Overflow

Nifi - Groovy Json Script define null attributes

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related