Fetch custom object properties using Hubl

[ChrisChiha]

Hello,
 
So i am building an email template that will promote to my stakeholders appartments similar to the appartment they are associated to.
 
To do so, we have a custom object "Appartments", and we are storing all our appartments in it.
My scenario:
Appartment A is associated to a contact.
Appartment B and appartment C are similar to Appartment A.
I am storing in 2 properties on Appartment A the record IDs of appartment B and C (Similar property ID)
 
Now i would like to enrol appartment A in a workflow, and fetch the properties of appartment B and C to the email using their IDs. Is this possible?
Like fetch the property of the appartment where ID = Similar property ID ?
  
Thank you!!
@ChrisChiha 

[LeeBartelme]

I think to do this you will need operations Hub to use custom coded workflow actions where you can run API requests during the workflow to pull out data.

If you are doing it in an email template though, I "think" you could probably create a custom module (make sure to enable programmable email on the module) and then use data from the contact or it's associations to output data for the module. So the module itself would lookup and output the data you want in the email.