question Re: Jolt Spec for populating field based on value of another field in Support Questions

Jolt Spec for populating field based on value of another field

Biswa — Fri, 21 Feb 2020 14:42:56 GMT

I want to populate my target JSON with a field based on value of another field.

e.g.

Input JSON:
[

{
"examUrl": "https://exam.test.com/page/1473161074",
"urlTypeName": "Spring URL"
},

{
"examUrl": "https://exam.test.com/page/12423222",
"urlTypeName": "Java URL"
},

]

Expected Output:

{

"ExamDashBoardURL" : "https://exam.test.com/page/1473161074"

}

In the above example, I will populate ExamDashBoardURL only if urlTypeName is "Spring URL".

Can anyone please help me on this.

Thanks and Regards,

Biswa

Re: Jolt Spec for populating field based on value of another field

Biswa — Tue, 25 Feb 2020 13:26:46 GMT

I found out the solution. It may be helpful for someone.

If anyone has better spec, please let me know

[
{
"operation": "shift",
"spec": {
"*": {
"urlTypeId": {
"1": {
"@2": "domoDashboardLink"
}
}
}
}
},
{
"operation": "shift",
"spec": {
"domoDashboardLink": {
"examUrl": "&1"
}
}
}
]

Re: Jolt Spec for populating field based on value of another field

PVVK — Wed, 30 Sep 2020 18:03:58 GMT

Hi @Biswa,

Please look at the below spec:

[
 {
  "operation": "shift",
  "spec": {
   "*": {
    "urlTypeName": {
     "Spring URL": {
      "@(2,examUrl)": "ExamDashBoardURL[]"
     }
    }
   }
  }
 }
]

Output will be:

{
"ExamDashBoardURL" : [ "https://exam.test.com/page/1473161074" ]
}

Tell me if this is ok.