Hi All,
Let me explain what i am trying to do exactly.
Layer7 stores Audits in MySql db. audit_message stores the request and response messages of an API. We need to list all APIs which contains speicific data.
For example: CustomerId = 123,
To list all APIs audits whose request contains customerid:123.
MySQL Query: Select * from audit_message where request_zipxml like '%123%'
This query has given a result but we are not able to validate as columns request_zipxml and response_zipxml are of type blob. It is not in human readable format.
There are some other fields like 'goid' which is of type binary.
How to convert this data into human readable format on query?
I am looking at the wrong place? Any suggestions ?
The DB i have connected to is an External RDS Mysql DataBase.
The client I am using is MySQL Query Browser.
Regards,
Neha