JSON STRING VALUES INTO COLUMNS
Hi Everyone.. I have a requirement where we have to split the json which is coming into the json but it is in String. We have to divide into the columns. Let me explain you by the example. The Js...
Forum Discussion
I think your initial problem is that the data is not actual json.
Field separators should be ":" - and the parenteses are clearly off.
Snaplogic will still however allow you to do this (you can probably condense this into one mapper if you give it a bit more thought ...):
first mapper: `$String.split('},{')`
2nd mapper: `$splitValue.replace('{', '').replaceAll('}}}', '').split(', ').toObject(x => x.split('=')[0], x => x.split('=')[1])`
The json splitter in between just splits the data into multiple rows.
