Pull data from Custom Object
Hello Community!
I would like to seek expert guidance on how to implement the following use case:
We have a custom object inside Eloqua that links to the Eloqua contact table in a many-to-one relationship, i.e., one contact record can be associated with multiple custom object records.
Let's assume that we have the following records inside the custom object:
As you can see from the above table, the same contact record has registered their interest in multiple products. While this is the case, I need to pull the most recently created record and its value in the "Interest" column(so, it should pull the record that was created on 04/11/23). Can anyone please suggest the best way to do this?