question How to start the array of json object from Index 1 instead of 0 using Jolt NiFi in Support Questions

How to start the array of json object from Index 1 instead of 0 using Jolt NiFi

Techie123 — Mon, 28 Nov 2022 15:21:45 GMT

Hi Team,

I have an requirement:

Input:

{
"headers": {
"comments": "3"
},
"data": [
{
"Id": "100000",
"Date": "2022-09-22"
},
{
"Id": "100001",
"Date": "2022-09-02"
}
]
}

Jolt Spec:

[{
"operation": "shift",
"spec": {
"data": {
"*": {
"Id": "[&1].Id",
"Date": "[&1].Date",
"$": "[&1].array_Ind"
}
}
}
}, {
"operation": "modify-default-beta",
"spec": {
"*": {
"Record": "=concat('Record ',@(1,array_Ind))"
}
}
}]

I am getting below output:

[ {
"array_Ind" : "0",
"Id" : "100000",
"Date" : "2022-09-22",
"Record" : "Record 0"
}, {
"array_Ind" : "1",
"Id" : "100001",
"Date" : "2022-09-02",
"Record" : "Record 1"
} ]

Expected output:

[ {
"array_Ind" : "1",
"Id" : "100000",
"Date" : "2022-09-22",
"Record" : "Record 1"
}, {
"array_Ind" : "2",
"Id" : "100001",
"Date" : "2022-09-02",
"Record" : "Record 2"
} ]

Can you please help

Re: How to start the array of json object from Index 1 instead of 0 using Jolt NiFi

Faerballert — Mon, 28 Nov 2022 15:47:34 GMT

Hello @Techie123

I added a operation to your Jolt Specification, try it with:

[ { "operation": "shift", "spec": { "data": { "*": { "Id": "[&1].Id", "Date": "[&1].Date", "$": "[&1].array_Ind" } } } }, { "operation": "modify-overwrite-beta", "spec": { "*": { "array_Ind": "=intSum(1,@(1,array_Ind))" } } }, { "operation": "modify-default-beta", "spec": { "*": { "Record": "=concat('Record ',@(1,array_Ind))" } } } ]

Greetings

Re: How to start the array of json object from Index 1 instead of 0 using Jolt NiFi

Techie123 — Tue, 29 Nov 2022 04:50:38 GMT

Hi @Faerballert ,

Its working as expected. Thank you so much.