I was able to parse it by fetching xml via spath then using eval _raw=xml_field | xmlkv | table amount
_json is a built in sourcetype which should automatically parse this event. If you are setting this to a different sourcetype then it will not parse though. Suggest you first try: | spath
as this should force the json to be parsed.
I was able to parse the json via SPATH command and I fetched the XML in a new field. For Ex :command - Spath output=xml_field path=field3.message | table xml_field
If you are still having an issue please post the query and example output.
I'm not sure what is an issue but I complete comment is getting posted.
I was able to parse the xml from the event but I'm unable to fetch the value of amount from this xml. I have tried both spath and xpath.
{"field1":"value1","field2":"value2", "field3":{"message:"