Get values outside of jsonArray for loop

I’m working on a grocery app for my project and I got this JSON Array [ { “msg”:”success”, “id”:”1904″, “firstname”:”john”, “lastname”:”doe”, “email”:”johndoe@gmail.com”, “mobile”:”10111213″, “appapikey “:”aba27d8447acd61152ad716696465c27” } ] And I’m using Volley StringRequest val stringRequest = StringRequest(Request.Method.GET, url, Response.Listener { var jsonArrayInfo = JSONArray(it) for(i in 0 until(jsonArrayInfo.length())) { var userInfo = jsonArrayInfo.getJSONObject(i) var fName =…

Converting a pandas dataframe to nested JSON

I have a dataframe in pandas with 39 variables. I need to convert this into JSON format in such a way that it has 3 keys. For e.g. {“Key1″:”Var1″,”Key2”:{“Var2″:”25″,”Var3″:”10″,”Var4″:”5″,”Var5″:”2″},”Key3”:{“Var6″:”1″,”Var7″:”0″,”Var8″:”10”}} also need the values associated with variables as string Any help will be highly appreciated!

Unable to get data from Json string in sql server database

I am trying to get all the fileDisplayName value from my data set column which has json string. select id_ref id, JSON_VALUE(cast(data_map as varchar(max)),’$.dataMap.”4805″.fileDisplayName’) Attachments, data_map dataa from action_data where id_ref = 54432; tried to but failed. my string value in column “4805”:{“@class”:”com.tbitsglobal.dms.persistence.entities.datatypes.FileDataList”,”id”:0,”value”:[{“@class”:”com.tbitsglobal.dms.persistence.entities.datatypes.FileData”,”id”:0,”value”:”28b1d5fb-d4b9-4d2b-8f70-cca1ecc6b64a”,”checkSum”:”91df90d0d72b71d46a633150d3f94117″,”fileDisplayName”:”KSTPP-LTP-LTSO-L-622-0003.pdf”,”fileUploadTime”:1571372081959,”fileSize”:101032,”fileProperties”:null},{“@class”:”com.tbitsglobal.dms.persistence.entities.datatypes.FileData”,”id”:0,”value”:”4a6eabd6-9df8-4ce7-9eb0-25e6875a5a64″,”checkSum”:”a941428a17726c157915293db64aaca9″,”fileDisplayName”:”KSTPP-LTP-LTSO-L-622-0001.pdf”,”fileUploadTime”:1571372082185,”fileSize”:85028,”fileProperties”:null},{“@class”:”com.tbitsglobal.dms.persistence.entities.datatypes.FileData”,”id”:0,”value”:”fb9a37e8-65b8-47a7-8e57-577c5aa4f162″,”checkSum”:”2f0036e074f28d22247608581aeac9ca”,”fileDisplayName”:”KSTPP-LTP-LTSO-L-622-0002.pdf”,”fileUploadTime”:1571372082186,”fileSize”:86907,”fileProperties”:null}]}, ** excepted result All the fileDisplayName value from field having id –…