Questions tagged [jolt]

A JSON to JSON transformation library written in Java.

Jolt is a to JSON transformation library written in .

For more information, see the GitHub page.

Latest release: 0.1.6 released on Mar 28, 2022

1312 questions
0
votes
1 answer

how to validate datatype in jolt transformation

I'm new to jolt transformation. I was wondering if there is a way to do a validation on data type then proceed. I'm processing a json to insert record into hbase. From source I'm getting timestamp repeated for the same resource id which I want to…
Vivek Jain
  • 23
  • 4
0
votes
1 answer

jolt array transform using wildcard

I'm using JOLT to transform data from: [{"a" : "a", "b" : "b", "c" : "c", ...}, {"a" : "a", "b" : "b", "c" : "c", ...}] To: [{"a1" : "a", "b1" : "b", "c1" : "c", ...}, {"a1" : "a", "b1" : "b", "c1" : "c", ...}] I'm trying…
FTineo
  • 3
  • 2
0
votes
1 answer

Jolt Transform Demo Not working for me

when i try to open Jolt Transform Demo link (http://jolt-demo.appspot.com/) in any browser (Chrome,IE,Opera) some of the scripts are not loading.Due to that Jolt Transform Demo page not working.Please look into attachment for reference.
Srikanth M
  • 31
  • 5
0
votes
1 answer

JOLT: Transforming comma separated value to object

can someone help with jolt spec . input : { "data": [ { "key": "A,B,C,D,S" } ] } I want output like : { "id":"A" }, { "id":"B" }, { "id":"C" }, { "id":"D" }, { "id":"S" } The key can be of n numbers of commaSeperated…
Pratik Jaiswal
  • 390
  • 1
  • 5
  • 21
0
votes
1 answer

Json Jolt - Shifting data to multiple sub-arrays

I am trying to do a number of shifts to copy some data into multiple arrays and I am having trouble getting the data to correct array. This is what I have { "input": { "rating_date": "2018-08-06", "Rates": { "name": "Generic ratings…
davdic
  • 249
  • 3
  • 10
0
votes
1 answer

Jolt Numeric Constant

In Jolt it is possible to assign a constant value to a field by prefixing the constant value with # as below. { "#2": "myField"} But this constant is always added as a string value. How can I add it as a numeric value?
Udith Gunaratna
  • 2,091
  • 1
  • 13
  • 17
0
votes
2 answers

How to map only when the field is not null in JOLT

Here is my input : { "isPoolPoint": "test", "timeZone": "ET" } I want output to be : { "address" : [{"line2": "test"}] } I should not get any thing as output if isPoolPoint is a null.
0
votes
1 answer

Java Jolt bazaarvoice nested array

I am using Jolt to transform data from { "Data": { "ROOT": { "MODIFIED_DATE": "2018-06-27T13:53:47.8", "A1": [ { "FLD1": "BB", "A2": [ { "FLD2": 1 } ] …
Shawn
  • 5,130
  • 13
  • 66
  • 109
0
votes
1 answer

Fetching the nth element of array

I'm having a json with input: { "customerId": "12345", "customerStatusTrail": [ "INITIATED", "PENDING", "COMPLETED" ], "segment": "S1" } which I want to convert it to: { "customerId": "12345", "customerStatusTrail":…
0
votes
1 answer

Stuck on simple jolt transformation

So I have this json retrieved from the Google Maps API and I just want to get longitude and latitude. I am looking to use the jolt template to extract just the information that I need. { "results": [ { "address_components": [ { …
harry2000
  • 1
  • 1
0
votes
1 answer

How would I use the attribute as input for Value with JOLT?

For a specific function that I am building, I need to parse my JSON and have in some cases the attribute, instead of the value itself, be used as the value for the attribute. But how do I manage that with JOLT? Let's say this is my input: { …
Sander Schaeffer
  • 2,757
  • 7
  • 28
  • 58
0
votes
1 answer

JOLT Flatten Unnamed nested array and Split function

Working on transformation and created spec for the input. The output is nested array but I am expecting flattened array. 2. Need to split the string and get the first element. split function doesn't seems to be working. Please find the input, spec ,…
0
votes
1 answer

How can i filter data with JOLT Transform by several keys

Am trying something with Jolt transformation but struggling to get it to work. If I have an input like: {"options": [ { "id": "18031", "name": "sample", "archived": true, "released": true, "releaseDate": "2014-11-04", …
0
votes
1 answer

Trying to build complex nested JSON using JOLT

I am trying to build complex nested array of JSON objects. I am struggling to get my expected structure using JOLT. Any help would be appreciated. I am trying to understand JOLT from the appspot and it is hard for me to grasp about recursively…
user1997772
  • 81
  • 1
  • 4
0
votes
1 answer

Making complex Array output using JOLT

I am trying to transform json to complex array. The inner array of INVLOC is not generating the way I want. My input json is : { "valid": "true", "message": "", "data": { "ARINVT01": [ { "firstName": "andrew", …
Pratik Jaiswal
  • 390
  • 1
  • 5
  • 21