[Plugin] Http/s REST, blueprintable JSON query and Parse API manager [VaRest]

Community Showcase Game Development
137

I have 3 returned results coming from an SQL query - they are stored in the JSON object as follows - i can echo them all via php and show them on a web page - but i cant seem to access them in UE4 from the response object - how can i get the response object as an array and iterate it?

//DB ACTION
$result = mysql_query("SELECT * FROM characters a, accounts b WHERE a.accountid_fk = b.id AND b.username = '$username'") or die("Failed to get characters database ".mysql_error());

if (mysql_num_rows($result) > 0){
    while($row = mysql_fetch_assoc($result)) {
        $Name = $row'name'];
        
        $array] = array(
        'Status' => "1",
        'CharNames' => "$Name"
        );
    }
}

$json = json_encode($array);

echo utf8_encode($json);

in IE:

http://puu.sh/v4fPB/e261312166.png