Json string to Json using Java and Jolt

Question

I have a json string e.g..

 { "value": "{\"userSuspended\":false}" }

What would be the correct Jolt spec to map 'userSuspended' to 'state'?

Well, actually you don't have a JSON string. This is not valid JSON syntax. — Henry
– Henry, Commented Aug 11, 2020 at 12:06
You should edit the question, instead of providing corrections in comments. — andrewJames
– andrewJames, Commented Aug 11, 2020 at 13:20

AMUK786 · Accepted Answer · 2020-08-25 16:41:43Z

1

It needed two transforms and a Javaclass to map the key/value:

Shift "Value":"Value"
Map the keys 'userSuspended' and 'false' through a javaclass to key/value pairs
Shift the output to "userSuspended":"State"

answered Aug 25, 2020 at 16:41

AMUK786

315 bronze badges

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

Comments

TSL · Accepted Answer · 2020-08-21 15:31:30Z

0

One way of doing it is to split the value and save what you wanted to state.

[
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "stateArray": "=split('\"',@(1,value))"
    }
  },
  {
    "operation": "shift",
    "spec": {
      "stateArray": {
        "1": "state"
      }
    }
  }
]

answered Aug 21, 2020 at 15:31

TSL

1611 silver badge9 bronze badges

1 Comment

AMUK786 Over a year ago

Thanks, apologies I wasn't very clear - not exactly what I was intending since I wanted the value "false" to be mapped to state.

Collectives™ on Stack Overflow

Json string to Json using Java and Jolt

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related