Hi
I'm trying to extract some json values into tables for a dashboard. The log line that i'm using is something like the below
username=myUser notificationPreferences=
[class NotificationPreferences { category=cat1, categoryDescription=category1 receiveEmailNotifications=false receiveSmsNotifications=false },
class NotificationPreferences { category=cat2 categoryDescription=category2 receiveEmailNotifications=false receiveSmsNotifications=true }]
As you can see, its just a standard toString on a java class that the developers are outputting. What i want is a table of users and categories, with each category having the associated details, eg
User
Category
Email
SMS
myUser1
Category1
false
false
myUser1
Category2
false
true
myUser2
Category1
true
true
I started by trying to tidy up the json
| rex field=notificationPreferences mode=sed "s/\[class NotificationPreferences/prefs:[ /g"
| rex field=notificationPreferences mode=sed "s/, class NotificationPreferences/, /g"
Which makes the notificationPreferences field a bit better
username=myUser notificationPreferences=
prefs:[ { category=cat1, categoryDescription=category1 receiveEmailNotifications=false receiveSmsNotifications=false },{ category=cat2 categoryDescription=category2 receiveEmailNotifications=false receiveSmsNotifications=true }]
But from here im struggling with what i need to do in terms of spath and extractions to get both categories to work. I only ever seem to get the first category to appear in my results.
Any help would be great
Thanks
... View more