topic Re: Converting data from the table to JSON in Qlik Automate

Converting data from the table to JSON

Zaferozkr — Tue, 14 Oct 2025 15:16:24 GMT

I want to convert the data I get from a table into JSON format using automation and the attached model, and then serve it within the API. However, the data is returning as a string, not JSON. I would appreciate your support.

Below you can see the incorrect string output.

[
"{id:1,name:2222 TEST,sapCode: 12345321,gradeRate:13,grade:TEST1}",
"{id:2,name:2213 TEST sapCode: 12345623,gradeRate:11,grade:TEST2}"
]

Re: Converting data from the table to JSON

Amit_Prajapati — Thu, 16 Oct 2025 06:38:34 GMT

Hi @Zaferozkr ,

Please find the attached JSON you can use to get the details from exsiting JSON file.

Re: Converting data from the table to JSON

salmankojar — Thu, 16 Oct 2025 06:35:25 GMT

Hi @Zaferozkr you don't need to manually create Json content. Just apply Json formula over the output of Get straight table data block using the Add Formula Option. it will format your table data into Json content which can be served to your desired API.