Converting data from the table to JSON

[Zaferozkr]

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}"
]

[Amit_Prajapati]

Hi @Zaferozkr  ,

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

[salmankojar]

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.