FHttpResponsePtr - MULTIPLE Rows returned

Development Programming & Scripting
1

How do I handle multiple rows returned from my JSON server response? This could be N# of rows from an SQL Select statement - consider Inventory, abilities, loadout etc…

So far - i can only seem to get 1 return object to function with the FJsonSerializer::Deserialize(Reader, JsonObj).

I am getting an FHttpResponsePtr return - and doing: Response->GetContentAsString(); which is the only thing i can see as a possible way to handle JSON response from database from the web. Perhaps theres a better alternative? CODE:

TSharedPtr<FJsonObject> JsonObj = MakeShareable(new FJsonObject());

	FString MsgBody = Response->GetContentAsString();
	UE_LOG(LogTemp, Warning, TEXT("%s"), *MsgBody);

	TSharedRef<TJsonReader<TCHAR>> Reader = TJsonReaderFactory<TCHAR>::Create(*MsgBody);
	if (FJsonSerializer::Deserialize(Reader, JsonObj))
	{
		TSharedPtr<FJsonObject> AchObj = JsonObj->GetObjectField("Achievements");
		UE_LOG(LogTemp, Warning, TEXT("JSON IS VALID"));
		// All is okay, json is valid
		FString ID = AchObj->GetStringField(TEXT("ID"));
		FString TaskType = AchObj->GetStringField(TEXT("TaskType"));
		FString ClassID = AchObj->GetStringField(TEXT("ClassID"));
		FString Amount_Current = AchObj->GetStringField(TEXT("Amount_Current"));
		FString Amount_Needed = AchObj->GetStringField(TEXT("Amount_Needed"));

		UE_LOG(LogTemp, Warning, TEXT("%s %s %s %s %s"), *ID, *TaskType, *ClassID, *Amount_Current, *Amount_Needed);
	}

JSON RESPONSE:
{“Achievements”:{“ID”:“0”,“TaskType”:“kill”,“ClassID”:“ClassStuffHere”,“Amount_Current”:“0”,“Amount_Needed”:“25”}}{“Achievements”:{“ID”:“1”,“TaskType”:“kill”,“ClassID”:“bears”,“Amount_Current”:“0”,“Amount_Needed”:“50”}}

2

Turns out this was a PHP formatting issue - i was able to format a proper JSON Array from php with the following - and then successfully pull off a JSON reader with the code below the php.

PHP:

function resultToArray($result) {
	$rows = array();
	while($row = $result->fetch_assoc()) {
		$rows[] = array(
				'ID' => $row['ID'],
				'TaskType' => $row['TaskType'],
				'ClassID' => $row['ClassID'],
				'Amount_Current' => $row['Amount_Current'],
				'Amount_Needed' => $row['Amount_Needed']
			);
	};
	return $rows;
}

//DB ACTION
$stmt = "SELECT * FROM achievementscompleted a, accounts b WHERE a.AccountFK = b.id AND b.username = '$pName'";
$result = $con->query($stmt);
$rows = resultToArray($result);
if($rows)
	echo json_encode(array("Achievements" => $rows));

.CPP

TSharedPtr<FJsonObject> JsonObj = MakeShareable(new FJsonObject());

FString MsgBody = Response->GetContentAsString();
TSharedRef<TJsonReader<TCHAR>> Reader = TJsonReaderFactory<TCHAR>::Create(*MsgBody);
if (FJsonSerializer::Deserialize(Reader, JsonObj))
{
	TArray<TSharedPtr<FJsonValue>> ArrayObj = JsonObj->GetArrayField("Achievements");
	UE_LOG(LogTemp, Warning, TEXT("ARRAY IS VALID WITH AMOUNT OF : %d"), ArrayObj.Num());

}