Value can't be obtained C# esq

Hello,

I am trying to do some mass creation of records using a script task in a business process. I have a for loop looping through entities, and on each of these entities there is a account address, but I need the account off of that account address so I have another esq for the account address. The issue is when I try to use the column accountaddress to get the account id I receive the error

Terrasoft.Common.InvalidObjectStateException: Column UpAccountAddress value cannot be obtained because it has not been loaded.

This is my code.

// Get business process parameters.
var tagId = Get<Guid>("TagId");
var userId = Get<Guid>("userId");
 
// Create a reference to the UpMapSearchAccounts schema.
var esq = new EntitySchemaQuery(UserConnection.EntitySchemaManager, "UpMapSearchAccounts");
 
// Add the [UpMapping] column in order to filter for relevants records.
esq.AddColumn("UpMapping");
esq.AddColumn("UpAccountAddress");
 
var esqFilter = esq.CreateFilterWithParameters(FilterComparisonType.Equal, "UpMapping", userId);
 
esq.Filters.Add(esqFilter);
 
var entities = esq.GetEntityCollection(UserConnection);
 
foreach(Entity entity in entities) 
{
 
	// Creating a reference to AccountAddress to get the Account off of it.
	var esqAccountAddress = new EntitySchemaQuery(UserConnection.EntitySchemaManager, "AccountAddress");
	esqAccountAddress.AddColumn("Account");
 
	var accountAddressEntity = esqAccountAddress.GetEntity(UserConnection, 
		entity.GetTypedColumnValue<Guid>("UpAccountAddress"));
 
	// Create a reference to the AccountInTag schema in order to create records.
	var AccountInTagSchema = UserConnection.EntitySchemaManager.GetInstanceByName("AccountInTag");
	var tagEntity = AccountInTagSchema.CreateEntity(UserConnection);
 
	tagEntity.SetColumnValue("TagId", tagId);
	tagEntity.SetColumnValue("EntityId", accountAddressEntity.GetTypedColumnValue<Guid>("Account"));
	tagEntity.SetColumnValue("CreatedById", userId);
 
	tagEntity.SetDefColumnValues();
 
	tagEntity.Save();
 
}
 
return true;

Any help is appreciated. Please ask any questions if I am not clear enough.

Thanks!