I am trying to help only.

This is an example to create Json Array in Javascript dynamically using new Array(), new Object() and .push(). < script > var obj = new Array ( ) ; for ( i = 1 ; i <= 5 ; i ++ ) { var jsonData = new Object ( ) ; jsonData . key = "ID" ; jsonData . value = i ; obj . push ( jsonData ) ; } console . log ( obj ) ; < / script >    

Parses the json object and displays the contents of its arrays using DeserializeJSON, This function is useful any time a ColdFusion page receives data as JSON strings. I Type Json: <cfoutput>     <cfset JsonData='[{"reason": "email address is unknown", "email": "abc@hotmail.comh"},     {"reason": "email address is unknown", "email": "bbc@68gmail.com"},     {"reason": "email address is unknown", "email": "ff@ff.com"},     {"reason": "Known bad domain", "email": "rr@hotmai.com"},     {"reason": "email address is unknown", "email": "ll@pp.rr.com"}]'>         <cfset JsonData=REReplace(JsonData,"^\s*[[:word:]]*\s*\(\s*","")>     <cfset JsonData=REReplace(JsonData, "\s*\)\s*$", "")>         <cfset cfData=DeserializeJ...

array with struct - Create Json using array with struct in coldfusion   <cfquery name="GetUsers" datasource="TestDB"> SELECT UserID, UserName,Active, CASE Active WHEN 1 THEN 'Active' WHEN 0 THEN 'InActive' END AS Status FROM shema_users </cfquery> <cfset resultStruct = Structnew() /> <cfset JsonArray = ArrayNew(1) /> <cfset Counter=1> <cfloop query="GetUsers"> <CFSET color = FormatBaseN(RandRange(0,255), 16)  & FormatBaseN(RandRange(0,255), 16)  & FormatBaseN(RandRange(0,255), 16)> <cfset JsonArray[Counter] = Structnew() /> <cfset JsonArray[Counter]["UserID"] = "#UserID#" /> <cfset JsonArray[Counter]["UserName"] = "#UserName#" /> <cfset JsonArray[Counter]["Active"] ...