Json Reader

CloverDX Platform
1

Hi together,

Is there any way to extract the im:id value from the following JSON string? Any help would be greatly appreciated :slight_smile:

“attributes”:{“im:id”:“3413123”, “im:bundleId”:“com.ddd.aaaa”}}

Thank you,

Peter

2

Hi Peter,

there are 2 components available (only in commercial versions of our products):

* http://doc.cloveretl.com/documentation/ … tract.html
* http://doc.cloveretl.com/documentation/ … eader.html

So that is one possibility. Other options are:

* parse information you need by CTL2 code (regular expressions, substring search, …)
* create own tranformation using Java (http://doc.cloveretl.com/documentation/ … rmers.html) and use some external JSON library (Jackson, …) for parsing

I hope this helps.