question Re: JoltTransformJSON - Extract attribute witouth remove it in Support Questions

JoltTransformJSON - Extract attribute witouth remove it

calonsca — Mon, 17 Jun 2019 18:23:16 GMT

Hello everyone,

first at all, i am kind of newbie with nifi so feel free to change everywhting you see.

I am ussing JoltTransformJSON. My input JSON is the next one:

{

"ID": "123",

"Text1": "aaa",

"Text2": "aaa",

"Text3": "aaa"

}

And i need the next output:

{

"data": {

"ID": "123",

"Text1": "aaa",

"Text2": "aaa",

"Text3": "aaa"

"date": "",

"dataset": "",

"ID": "123"

}

The var date and dataset are attributes from the flow, so there is no problem here, the problem is i need to extract the value of ID, in this case 123 but this is just an example, without deleted the ID inside de field data. My Jolt Specification is the next one:

[{

"operation": "shift",

"spec": {

"*": "data.&"

}

}, {

"operation": "default",

"spec": {

"dataset": "${dataset:toLower()}",

"date": "${date}"

}

}]

and with that i have all EXCEPT the ID field, that i dont know how to do it :(.

Thankss

Re: JoltTransformJSON - Extract attribute witouth remove it

Shu_ashu — Tue, 18 Jun 2019 07:58:13 GMT

@Carlos

Try with below spec:

[{
  "operation": "shift",
  "spec": {
    "*": "data.&",
    "ID": ["ID", "data.ID"]
  }
}, {
  "operation": "default",
  "spec": {
    "dataset": "${dataset:toLower()}",
    "date": "${date}"
  }
}]

Output:

{
  "ID" : "123",
  "data" : {
    "ID" : "123",
    "Text1" : "aaa",
    "Text2" : "aaa",
    "Text3" : "aaa"
  },
  "date" : "${date}",
  "dataset" : "${dataset:toLower()}"
}

Re: JoltTransformJSON - Extract attribute witouth remove it

ask_bill_brooks — Tue, 18 Jun 2019 10:09:11 GMT

The above was originally posted in the Community Help Track. On Tue Jun 18 03:07 UTC 2019, a member of the HCC moderation staff moved it to the Data Ingestion & Streaming track. The Community Help Track is intended for questions about using the HCC site itself.

Re: JoltTransformJSON - Extract attribute witouth remove it

calonsca — Tue, 18 Jun 2019 12:59:18 GMT

thanks!! it's works

Re: JoltTransformJSON - Extract attribute witouth remove it

PVVK — Wed, 30 Sep 2020 19:47:02 GMT

Hi @calonsca!

Please have a look at this spec as well!

[
 {
  "operation": "shift",
  "spec": {
   "@": "data",
   "ID": "&",
   "#${date}": "date",
   "#${dataset:toLower()}": "dataset"
  }
 }
]