JSON STRING VALUES INTO COLUMNS

Question

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.&nbsp;The Json is coming in this format.[{"String":"{col_name=CTRY_CODE, data_type=varchar(32768)},{col_name=SRCE_CODE, data_type=varchar(32768)},{col_name=PROD_CODE, data_type=varchar(32768)}}}"}]&nbsp;But the result we need is :Can anyone help me to solve this.Thanks in advance.alchemiz&nbsp;j_angelevski&nbsp;&nbsp;

matthias · Answer

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('},{')`&nbsp;2nd mapper: `$splitValue.replace('{', '').replaceAll('}}}', '').split(', ').toObject(x =&gt; x.split('=')[0], x =&gt; x.split('=')[1])`&nbsp;The json splitter in between just splits the data into multiple rows.&nbsp;&nbsp;&nbsp;

alchemiz · Answer

Hi&nbsp;mohit_jain,Good day, you can also try to manipulate the string to be a valid JSON string.. just like what Sir&nbsp;Matthias&nbsp;suggestedExpression:JSON.parse('['.concat($.get('String','').replace(/\{|\=|\}|\,[^\{]/g, m =&gt; match m {'{'=&gt; '{"', '='=&gt; '":"', '}'=&gt; '"}', ', '=&gt; '","', ','=&gt; '","'}),']'))

Forum Discussion

JSON STRING VALUES INTO COLUMNS

Recent Discussions

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?

Multipart Reader failure - 'content-type' was not found