go to post Florian Hansmann · Apr 22, 2020 Solution: First thanks for your help! Now I wrote my own class to get JSON direclty from SQL with custom keys declared with as in SQL: ClassMethod GetArrayFromSQL(pVar As %String = "", pSQL As %String = "") As %Library.ListOfDataTypes { #dim parameter = 0 for { set value=$piece(pVar,"#",$increment(parameter)) if ( value = "" ) { quit } set parameter(parameter) = value } set parameter = parameter - 1 #dim list = ##class(%Library.ListOfDataTypes).%New() #dim tStatement = ##class(%SQL.Statement).%New() #dim tStatus = tStatement.%Prepare(pSQL) #dim tResult = tStatement.%Execute(parameter...) #dim columnCount = tResult.%ResultColumnCount while( tResult.%Next() ) { set offsetName = -8 set object = ##class(%ZEN.proxyObject).%New() for i = 1:1:columnCount { set newKeyName = $list(tResult.%Metadata(0),$increment(offsetName,10)) set command = "set object.%data("_$char(34)_newKeyName_$char(34)_") = tResult."_newKeyName xecute command } do list.Insert(object) } return list } Best regards