Ways to get complete JSON from REST audit table

Hi All,

I am trying to extract the full JSON string from the response_comments column in the UNIFIER_RESTAUDIT_LOG table, but I am unable to retrieve it using a Data View.

The data type for response_comments is shown as VARCHAR. When I run the query below, the output is 4000:

SELECT LENGTH(a.response_comments) AS bytes
FROM UNIFIER_RESTAUDIT_LOG a
WHERE a.id = 14358118;

This suggests that when REST API audit information is stored in UNIFIER_RESTAUDIT_LOG, the maximum length of the stored JSON is limited to 4000 bytes. If the JSON payload exceeds this limit, it is truncated, resulting in incomplete JSON, which cannot be parsed using JSON_TABLE