Support Questions
Find answers, ask questions, and share your expertise

Avoiding nested JSON from JsonRecordSetWriter using PostgreSQL

Avoiding nested JSON from JsonRecordSetWriter using PostgreSQL

New Contributor

We're querying PostgreSQL using: ExecuteSQLRecord 1.12.1. The result columns are a mixture of text and JSONB. The JSONB contains nested JSON which is valid JSON but is being escaped:

 

 

{
    "data_uuid": "34bd343f-76b9-4bcd-99e3-cd1220ec506d",
    "keywords": "[{\"id\": 0, \"text\": \"government\", \"value\": 0.03177478621835793}, {\"id\": 1, \"text\": \"spending\", \"value\": 0.011451620741380654}]",
}

 

 

Is it possible to avoid this? so it outputs this:

 

 

{
    "data_uuid": "34bd343f-76b9-4bcd-99e3-cd1220ec506d",
    "keywords": [
        {
            "id": 0,
            "text": "government",
            "value": 0.03177478621835793
        },
        {
            "id": 1,
            "text": "spending",
            "value": 0.011451620741380654
        }
    ]
}