How to view Tidal Job output in a query?

[DCRICTAdmin]

I am using a query to extract the standard output of a job:

select jobrun_id, dbms_lob.substr( jobrun_output, 4000, 1 ) 
from tidal.joboutput
where  jobrun_id = 686361;

The query returns output in an XML format:

<TESXOUTPUT><MSG>Job output data is in XML format. To view job output upgrade your Client to latest version.</MSG><OUTPUT COMP="Y" RUN="1">eJzFVltv2zYUftevOBhQpB1CxXZuDQMXkC9...

How can I translate this output into readable text?

Thanks.

[fintan.halpenny]

I was running the REST api command to get the job output and received the same result as you. I found a method in the documentation that allows you to get the output in readable form.

Here it is:
JobOutput.getOutputContent/id

where id is the job run id

Hope that helps :)