How to format JSON value from ODBC query(get)

[DarkWall]

I have a item from a OBDC query that return a json like this


[{"job_name":"UpdateRSView","job_status":"Enable d", "last_run_status":"Error Failed","last_run_date":"2021-06-02 12:00:00.000","run_duration":"00:00:03","next_sche duled_run_date":"2021-06-02 13:00:00.000","step_description":"The job failed. Unable to determine if the owner (COSCO/USER) of job UpdateRSView has server access (reason: Could not obtain information about Windows NT group/user 'COSCO/USER, error code 0x2. [SQLSTATE 42000] (Error 15404))."}]

Is there a way to format to have it more human readable something like I know it's possible with preprocessing but the only i found is with Javascript... but i don't know JS is there another way?

[
{
"job_name":"UpdateRSView",
"job_status":"Enabled",
"last_run_status":"Error Failed",
"last_run_date":"2021-06-02 12:00:00.000",
"run_duration":"00:00:03",
"next_sche duled_run_date":"2021-06-02 13:00:00.000",
"step_description":"The job failed. Unable to determine if the owner (COSCO/USER) of job UpdateRSView has server access (reason: Could not obtain information about Windows NT group/user 'COSCO/USER, error code 0x2. [SQLSTATE 42000] (Error 15404))."
}
]

or any suggestion will be appreciate.


Thanks in advance